Accessing Auxiliary Storage: FILE › DB2 and SQL/DS Databases › SQL Commands

SQL Commands

Enter Structured Query Language (SQL) commands to perform DB2 or SQL/DS functions. FILE accepts the following SQL commands, subject to user authorization: SELECT, UPDATE, DELETE, INSERT, CREATE, ALTER, DROP, LABEL ON, GRANT, REVOKE, and COMMENT ON.

Note: For more information, see IBM's DB2 Application Programming and SQL Guide.

Observe the following rules in entering SQL commands:

• Begin the command in column one.
• Enter only one command at a time.
• A command can exceed several lines. If the command does not fit in the allowed space, press PF4 to obtain a larger input area. The command remains in the large input area for redisplay (using PF4), modification, and execution.