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

   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=>

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` `LOAD` `INSTALL`	`AUTOCOMMIT`	Determines whether ISQL issues COMMIT WORK automatically.
	`LOAD`	`AUTOLOCK`	Determines whether tables are locked when loaded.
	`INPUT` `LOAD`	`AUTOSAVE`	Determines how often automatic COMMIT WORK is performed.
	`LOAD`	`CONVERT`	Determines whether data will be converted during the load.
	`LOAD` `UNLOAD`	`LOAD_BUFFER`	Determines the size of the load/unload buffer.
	`LOAD` `UNLOAD`	`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.

Setting Command Options

Technical documentation

» Table of Contents

» Index