IBM GC09-2830-00 Entering Commands Using the Command Line Processor, Command Line Mode, OS/2

To save commands as scripts, select Script->Save as from the menu bar. For more information, click on the Help push button or press the F1 key.

If you want to store commonly used SQL statements or DB2 commands as scripts, click on the Script Center icon from the main tool bar. For more information, click on the Help push button or press the F1 key.

Entering Commands Using the Command Line Processor

You can use the command line processor to enter DB2 commands, SQL statements, and operating system commands. It operates in the following modes:

Command Line Mode

The DB2 command line processor behaves like a command window from your operating system. You can enter operating system commands, DB2 commands, or SQL statements and view their output.

Interactive Input Mode

The db2 pre®x that you use for DB2 commands (in Command Line Mode) is pre-entered for you. You can enter operating systems commands, DB2 commands, or SQL statements and view their output.

File Input Mode

Processes commands that are stored in a ®le. For information on the ®le input mode, refer to the Command Reference.

Command Line Mode

To invoke a DB2 Command window, do the following:

OS/2	Click on OS/2 Warp, and select DB2 for OS/2->Command
	Line Processor, or open any command window.

Windows 9x or Windows NT

Click on Start and select Programs->DB2 for

Windows->Command Window

You can also invoke the DB2 command window by entering the db2cmd command at an MS-DOS prompt.

If you are entering commands via the Command Window, you must include the db2 pre®x. For example:

db2 list database directory

136Quick Beginnings