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
autol[ock] - OFF
autos[ave] - 5
c[ontinue] - ON
conv[ert] - OFF
ec[ho] - OFF
echo_[all] - OFF
ed[itor] - /usr/bin/vi
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=>
|
The @ is an ISQL wild-card character meaning all. If your
system line-kill character is set to @, precede the @ with the
current HP-UX escape character. For example:
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; application program support | INPUT LOADINSTALL | AUTOCOMMIT | Determines whether ISQL issues COMMIT WORK automatically. |
| LOAD | AUTOLOCK | Determines whether tables are locked when loaded. |
| INPUTLOAD | AUTOSAVE | Determines how often automatic COMMIT WORK
is performed. |
| LOAD | CONVERT | Determines whether data will be converted
during the load. |
| LOADUNLOAD | LOAD_BUFFER | Determines the size of the load/unload buffer. |
| LOADUNLOAD | LOAD_ECHO | Determines when status messages are displayed. |
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. |
| | EXIT_ON_DBWARN | Determines whether ISQL terminates
immediately when a warning is encountered.
|