DBEnvironment access | SQL statements | Refer to the ALLBASE/SQL Reference Manual. | Define, access, and maintain databases. |
| Column information | INFO | Display column definitions. |
| Data utility | INPUT | Insert rows into a table. |
| | LOAD | Insert rows into a table from a file. |
| | UNLOAD | Copy rows from one or more tables to a file. |
| Application program support | EXTRACT | Copy a stored module into an installable module file. |
| | INSTALL | Store a preprocessor-generated module in a DBEnvironment. |
| | LIST INSTALL | Identify the module in a file created by an ALLBASE/SQL preprocessor. |
Command support | Query results | UP | Display previous rows in a query result. |
| | DOWN | Display next rows in a query result. |
| | TOP | Display the group of selected rows of a query result. |
| | BOTTOM | Display the last group of selected rows of a query result. |
| | LEFT | Display previous screen columns in a query result. |
| | RIGHT | Display next screen columns in a query result. |
| | PRINT | Print a query result. |
| | PAUSE | Suspend command file processing to enable review of a query result. |
| | END | Terminate query result display. |
| File management | EDIT | Invoke an editor for creating or changing a file. |
| | ERASE | Purge a file. |
| | LIST FILE | Display a file. |
| | RECALL FILE | Display a file and store its contents in command buffer. |
| | RENAME | Change the name of a file. |
| | STORE | Save the contents of the command buffer in a file. |
| Command files | START | Execute a command file. |
| Command buffer | CHANGE | Modify the contents of the command buffer. |
| | HOLD | Put command(s) into the command buffer. |
Command Support (Continued) | Command Buffer (Continued) | RECALL CURRENT | Display current contents of the command buffer. |
| | RECALL FILE | Displays a file and stores its contents in the command buffer. |
| | RECALL HISTORY | Place a command from the command history buffer into the command buffer and display it. |
| | START | Execute command(s) in the command buffer or a file. |
| | STORE | Save the contents of the command buffer in a file. |
| Command history buffer | DO | Execute a command in the command history buffer. |
| | LIST HISTORY | Display commands in the command history buffer. |
| | RECALL HISTORY | Place a command from the command history buffer into the command buffer and display it. |
| | REDO | Edit a command in the command history buffer. |
| ISQL environment | LIST SET | Display SET option values. |
| | SET | Set operational options, such as display line length, to specific values. |
| Command information | HELP | Display description, syntax, and example of SQL or ISQL commands.
|
ISQL termination | | ENDorEXIT | Terminate an ISQL session.
|
System access | | SYSTEM | Execute HP-UX command(s).
|
SQLGEN invocation | | SQLGEN | Execute SQLGEN commands.
|
SQLUtil invocation | | SQLUTIL | Execute SQLUtil commands.
|