HP 3000 Manuals HP 3000 Manuals
Setting Command Options
Various options are controlled with the SET command.
The SET options have initial settings, which you can change for the
duration of an ISQL session with the SET command. To determine the
current value of a SET option, you use the LIST SET command. The
following example illustrates the initial values of all SET options:
isql=> LIST SET @;
autoc[ommit] - OFF
autos[ave] - 5[REV BEG]
c[ontinue] - ON
conv[ert] - OFF
ec[ho] - OFF
echo_[all] - OFF
ed[itor] - EDITOR.PUB.SYS
es[cape] - \
exit[_on_dberr] - OFF[REV END]
f[raction] - 2
n[ull] -
ou[tput] - ISQLOUT
ow[ner] -
pa[gewidth] - 254
pr[ompt] - isql=>
isql=> SET ECHO ON;
isql=>
As indicated in Table 2-2 below, most SET options control ISQL processing
related to specific commands. Note that except the SELECT statement, all
commands under "Related Command" are ISQL commands.
Table 2-2. SET Command Options
--------------------------------------------------------------------------------------------------
| | | | |
| Category | Related Command | SET Option | Effect |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Data loading; | INPUT | AUTOCOMMIT | Determines whether ISQL |
| application program | LOAD | | issues COMMIT WORK |
| support | INSTALL | | automatically. |
| | | | |
| | INPUT | AUTOSAVE | Determines how often |
| | LOAD | | automatic COMMIT WORK is |
| | | | performed.[REV BEG] |
| | | | |
| | LOAD | CONVERT | Determines whether data |
| | | | will be converted during |
| | | | the load.[REV END] |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Query results | SELECT | FRACTION | Determines how many |
| | | | decimal digits are |
| | | | displayed. |
| | | | |
| | | NULL | Determines the character |
| | | | displayed when a value |
| | | | is null. |
| | | | |
| | | OUTPUT | Determines the file to |
| | | | which the query result |
| | | | is sent. |
| | | | |
| | | PAGEWIDTH | Determines the maximum |
| | | | row length in the query |
| | | | result. |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Command files | START | CONTINUE | Determines whether |
| | | | processing is to be |
| | | | continued if an error is |
| | | | encountered. |
| | | | |
| | | ECHO | Determines whether lines |
| | | | in the file are |
| | | | displayed as they are |
| | | | read. |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Editing | EDIT | EDITOR | Determines the editor |
| | | | invoked. |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| ISQL prompt | | PROMPT | Determines the input |
| | | | prompt string. |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Special characters | | ESCAPE | Determines the escape |
| | | | character.[REV BEG] |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Batch processing | | ECHO_ALL | Determines whether user |
| | | | input is displayed. |
| | | | |
| | | EXIT_ON_DBERR | Determines whether ISQL |
| | | | terminates immediately |
| | | | when an error is |
| | | | encountered.[REV END] |
| | | | |
--------------------------------------------------------------------------------------------------