HP 3000 Manuals HP 3000 Manuals
Chapter 4 ISQL Commands
This chapter describes all the ISQL commands, giving syntax and examples
for each and authorization requirements for commands that result in
database access. The commands are presented in alphabetical order; those
related to query results are defined under "SELECTSTATEMENT."
The size of commands submitted at a terminal or from an ISQL command file
is unlimited. Commands submitted through the ISQL command buffer cannot
exceed 32K bytes; the LOAD and UNLOAD size is unlimited.
Table 4-1 groups the commands you can execute from ISQL into functional
categories. Refer to the ALLBASE/SQL Reference Manual for a description
of those in the category named SQL statement. Refer to the ALLBASE/SQL
Database Administration Guide for SQLGEN and SQLUtil commands.
Table 4-1. ISQL Command Summary
---------------------------------------------------------------------------------------------------
| | | | |
| Group | Category | Command | Command Use |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| DBEnvironment | SQL statements | Refer to the | Define, access, and maintain |
| access | | ALLBASE/SQL | databases. |
| | | Reference Manual. | |
| | | | |
| | 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.[REV BEG] |
| | | | |
| | Application program | EXTRACT | Copy a stored module into an |
| | support | | installable module file.[REV |
| | | | END] |
| | | | |
| | | INSTALL | Store a |
| | | | preprocessor-generated module |
| | | | in a DBEnvironment. |
| | | | |
| | | LIST INSTALL | Identify the module in a file |
| | | | created by an ALLBASE/SQL |
| | | | preprocessor. |
| | | | |
---------------------------------------------------------------------------------------------------
Table 4-1. ISQL Command Summary (cont.)
---------------------------------------------------------------------------------------------------
| | | | |
| Group | Category | Command | Command Use |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| 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. |
| | | | |
---------------------------------------------------------------------------------------------------
Table 4-1. ISQL Command Summary (cont.)
---------------------------------------------------------------------------------------------------
| | | | |
| Group | Category | Command | Command Use |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| Command support | Command buffer | RECALL CURRENT | Display current contents of |
| (continued) | (continued) | | 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 | DO | Execute a command in the |
| | buffer | | 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 | | END or EXIT | Terminate an ISQL session. |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| System access | | SYSTEM | Execute MPE/iX command(s). |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| SQLGEN invocation | | SQLGEN | Execute SQLGEN commands. |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| SQLUtil invocation | | SQLUTIL | Execute SQLUtil commands. |
| | | | |
---------------------------------------------------------------------------------------------------