HP 3000 Manuals HP 3000 Manuals
SET
The SET command defines a number of ISQL environment options.
Scope
ISQL only.
ISQL Syntax
SE[T] Option OptionValue
Parameters
Option OptionValue identifies the option and a value for it. The
available options and values are listed here:
AUTOC[OMMIT] ON
Initial setting is OFF.
If ON, a COMMIT WORK statement is automatically
performed: 1) when you are using the INPUT or
LOAD command and you enter the number of rows
defined in the AUTOSAVE option, 2) when you enter
END to terminate the INPUT command, or 3) after a
module has been installed with the INSTALL
command.
AUTOC[OMMIT] OFF If OFF, rows inserted with the INPUT command are
committed only when you enter COMMIT WORK. Rows
inserted with the LOAD command or modules
installed with the INSTALL command are committed
only when you enter COMMIT WORK.
[REV BEG]
AUTOL[OCK] ON
Initial setting is OFF.
If ON, ISQL automatically acquires an exclusive
lock upon the table when the LOAD command is
executed. Setting AUTOLOCK to ON improves
performance when large data files are loaded.
AUTOL[OCK] OFF The LOAD command does not automatically lock the
table.[REV END]
[REV BEG]
AUTOS[AVE]
NumberOfRows
Initial setting is 5.
If AUTOCOMMIT is ON, ISQL will continue to load
rows with the INPUT or LOAD command until the
load buffer is full, even if the NumberOfRows
specified has been exceeded. Once the load
buffer is full, a check is made to see if the
NumberOfRows value has been reached or exceeded.
If this is the case ISQL processes a COMMIT WORK
statement.
NumberOfRows can be from 0 through 2,147,483,647.
When using the LOAD command for large data files,
you should increase NumberOfRows above the
initial setting of 5. For the INPUT command,
NumberOfRows should not be greater than 300.[REV
END]
C[ONTINUE] ON
Initial setting is ON.
If ON, ISQL continues processing commands from a
command file after encountering an error.
C[ONTINUE] OFF If OFF, ISQL terminates command file processing
after encountering an error.
CONV[ERT] ASCII
If ASCII, the LOAD command converts the data in
an external file from IBM mainframe format to an
ALLBASE/SQL data type. Character data in the
external file is in ASCII format.
CONV[ERT] EBCDIC If EBCDIC, the LOAD command converts the data in
an external file from IBM mainframe format to an
ALLBASE/SQL data type. Character data in the
external file is in EBCDIC format.
CONV[ERT] OFF Initial setting is OFF. If OFF, the LOAD command
will not convert the data in an external file.
EC[HO] ON
If ON, commands and comments in command files are
displayed as they are read from the command file.
EC[HO] OFF
Initial setting is OFF.
If OFF, commands and comments read from command
files are not displayed.
ECHO_[ALL] ON
If ON, batch user input is echoed to the standard
list.
ECHO_[ALL] OFF Initial setting is OFF.
If OFF, batch user input is not echoed.
ED[ITOR]EditorName
Initial setting is EDITOR.PUB.SYS
The named editor is invoked when you execute the
EDIT command.
ES[CAPE]Character
Initial setting is a backslash (\).
Characters with special meaning to ISQL must be
preceded by the one-byte escape character when
used within an ISQL command.
EXIT[_ON_DBERR] ON
If ON, ISQL sets the system JCW to FATAL and
terminates immediately if an SQL error is
encountered. The system JCW is set to 0 if no
SQL errors are encountered.
EXIT[_ON_DBERR] OFF Initial setting is OFF.
If OFF, ISQL does not immediately terminate if an
SQL error is encountered. The system JCW is not
set.
[REV BEG]
EXIT_ON_DBWARN ON
If ON, ISQL terminates immediately if an SQL
warning is encountered.
EXIT_ON_DBWARN OFF Initial setting is OFF.
If OFF, ISQL does not immediately terminate if an
SQL warning is encountered.[REV END]
[REV BEG]
FL[AGGER]
[StandardName]
Initial setting is blank, indicating that SQL
statements are not checked for standards
compliance.
ISQL displays a warning for each SQL statement
that does not conform to the StandardName
specified. The StandardName option is not case
sensitive. To turn off the flagger, issue this
command without the StandardName option. See the
"Standards Flagging Support" appendix in the
ALLBASE/SQL Reference Manual for more information
on ALLBASE/SQL standards compliance.[REV END]
F[RACTION] Length
Initial setting is 2.
The length determines the number of digits
displayed to the right of the decimal point in
the output of the SELECT statement for a column
containing data of type DECIMAL, FLOAT, or REAL.
Length can be from 0 through 18.
[REV BEG]
LOAD_B[UFFER]
NumberOfBytes
Initial setting is 16,384.
The NumberOfBytes specifies the size of the
buffer ISQL uses with the LOAD and UNLOAD
commands.
LOAD_E[CHO] ON
Initial setting is ON.
If ON, ISQL reports the number of rows processed
by each BULK INSERT executed by a LOAD command or
each FETCH issued by an UNLOAD command. If
AUTOCOMMIT is ON, ISQL displays a message each
time a COMMIT WORK is automatically performed by
the LOAD command.
LOAD_E[CHO] OFF If OFF, ISQL displays status messages for the
LOAD and UNLOAD commands only after all rows have
been processed.
LOAD_E[CHO] AT_COMMIT If AT_COMMIT, ISQL only displays status messages
when a COMMIT WORK is issued by a LOAD
command.[REV END]
N[ULL] [Character]
Initial setting is blank.
This one-byte character is displayed when a null
value occurs in a column. The NULL character can
be any one-byte character, except a semicolon or
a comma. To use a single or double quotation
mark or the current SET ESCAPE character, precede
it with the current SET ESCAPE character.
OU[TPUT] FileName
Initial setting is ISQLOUT.
All SELECT results go to the named file. ISQL
creates the file when you execute the SELECT
statement. If it already exists, it is
overwritten. If the file is named ISQLOUT, it is
removed when the query result display is
terminated. Each line in the output file is as
wide as the PAGEWIDTH setting.
OW[NER] OwnerName
Initial setting is user's DBEUserID name.
This command temporarily resets the default owner
name. It does not change the ownership of
existing objects in the DBEnvironment nor does it
change any authorities in the DBEnvironment. The
new owner name must be 20 bytes or fewer in
length. Setting the owner name eliminates the
need to fully qualify table and view names in SQL
statements. To reset the owner name to the login
name, type SET OWNER with no owner name.
PA[GEWIDTH] PageWidth [REV BEG]
Initial setting is 254.[REV END]
The maximum number of bytes per row of data for
SELECT output is the PageWidth value. PageWidth
can be as large as 32767. Blanks pad the line to
the option value.
PR[OMPT] PromptString
Initial setting is isql=> .
The PromptString appears when ISQL is ready to
accept a command from the terminal. The
PromptString can be as long as 16 bytes. If the
string contains any blanks or commas, enclose the
string in single or double ASCII quotes.
Description
* The EXIT_ON_DBERR option has precedence over the CONTINUE option.
For example, if EXIT_ON_DBERR is ON and CONTINUE is ON, ISQL
terminates immediately if an SQL error is encountered.
* The SET command described in this section is defines only ISQL
environment options. It is unrelated to the SQL SET statements
documented in the ALLBASE/SQL Reference Manual.
* In prompting mode, ISQL displays the following options:
isql=> SET;
Valid set options are:[REV BEG]
autoc[ommit] autol[ock] autos[ave] cont[inue]
conv[ert] ec[ho] echo_[all] ed[itor]
es[cape] exit[_on_dberr] exit_on_dbwarn fl[agger]
f[raction] load_b[uffer] load_e[cho] n[ull]
ou[tput] ow[ner] pa[gewidth] pr[ompt][REV END]
Set option>
Example
isql=> LIST SET @;
[REV BEG]
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
n[ull] -
ou[tput] - ISQLOUT
ow[ner] - LINDA@HPSQL
load_b[uffer] - 16384
pa[gewidth] - 32767
pr[ompt] - isql=>[REV END]
isql=> SET EDITOR TDP.PUB.SYS;
isql=>