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:
[REV BEG]
isql=> LIST SET @;
autoc[ommit] - OFF
autol[ock] - OFF
autos[ave] - 5
c[ontinue] - ON
conv[ert] - OFF
ec[ho] - OFF
echo_[all] - OFF
ed[itor] - EDITOR.PUB.SYS
es[cape] - \
exit[_on_dberr] - OFF
exit_on_dbwarn - OFF
fl[agger] -
f[raction] - 2
load_b[uffer] - 16384
load_e[cho] - ON
n[ull] -
ou[tput] - ISQLOUT
ow[ner] -
pa[gewidth] - 32767
pr[ompt] - isql=>
isql=> SET ECHO ON;
isql=>
[REV END]
As indicated in Table 2-2, 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.[REV BEG] |
| | | | |
| | LOAD | AUTOLOCK | Determines whether |
| | | | tables are locked when |
| | | | loaded.[REV END] |
| | | | |
| | INPUT | AUTOSAVE | Determines how often |
| | LOAD | | automatic COMMIT WORK is |
| | | | performed. |
| | | | |
| | LOAD | CONVERT | Determines whether data |
| | | | will be converted during |
| | | | the load.[REV BEG] |
| | | | |
| | LOAD | LOAD_BUFFER | Determines the size of |
| | UNLOAD | | the load/unload buffer. |
| | | | |
| | LOAD | LOAD_ECHO | Determines when status |
| | UNLOAD | | messages are |
| | | | displayed.[REV END] |
| | | | |
--------------------------------------------------------------------------------------------------
Table 2-2. SET Command Options (cont.)
--------------------------------------------------------------------------------------------------
| | | | |
| Category | Related Command | SET Option | Effect |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| 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. |
| | | | |
--------------------------------------------------------------------------------------------------
| | | | |
| Batch processing | | ECHO_ALL | Determines whether user |
| | | | input is displayed. |
| | | | |
| | | EXIT_ON_DBERR | Determines whether ISQL |
| | | | terminates immediately |
| | | | when an error is |
| | | | encountered.[REV BEG] |
| | | | |
| | | EXIT_ON_DBWARN | Determines whether ISQL |
| | | | terminates immediately |
| | | | when a warning is |
| | | | encountered.[REV END] |
| | | | |
--------------------------------------------------------------------------------------------------