User's Guide

Part II. Tutorials

Chapter 13. Command Files

SQL commands can get quite large. You have already seen how to use the editor to enter commands on several lines. The ISQL environment also allows multiple commands to be entered at the same time. This is done by ending each command with a semi-colon (;).

You may want to grow the Command window:

• In DOS, OS/2 or QNX, choose Command->Zoom from the menu bar.
• In Windows or Windows NT, click the maximize button.

Example: entering multiple statements

To enter multiple statement in the ISQL Command Window

1. Try entering the following three commands into the Command window.

        
        UPDATE employee
        SET dept_id = 400,
        manager_id = 1576
        WHERE emp_id = 467;
        
        UPDATE employee
        SET dept_id = 400,
        manager_id = 1576
        WHERE emp_id = 195;
        
        SELECT *
        FROM employee
        WHERE emp_id IN ( 195, 467 )
   

2. Press the execute key (F9). All three of these commands are executed. After execution, the commands are left in the Command window.

You can modify the commands if there are errors.