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[REV BEG] command
buffer cannot exceed 32K bytes; the LOAD and UNLOAD[REV END] 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 commands in the group named SQLUtil
commands.
Table 4-1. ISQL Command Summary
---------------------------------------------------------------------------------------------------
| | | | |
| Group | Category | Command | Command Use |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| DBEnvironment | SQL commands | 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. |
| | | | |
| | Application program | INSTALL | Store a |
| | support | | 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. |
| | | | [REV BEG] |
| | | | |
| | Command history | DO | Execute a command in the |
| | buffer | | command history buffer.[REV |
| | | | END] |
| | | | |
| | | 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 XL command(s). |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| SQLGEN invocation | | SQLGEN | Execute SQLGEN commands. |
| | | | |
---------------------------------------------------------------------------------------------------
| | | | |
| SQLUtil invocation | | SQLUTIL | Execute SQLUtil commands. |
| | | | |
---------------------------------------------------------------------------------------------------