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.
AUTOS[AVE] Initial setting is 5.
NumberOfRows
If AUTOCOMMIT is ON, ISQL will continue to load
rows with the INPUT or LOAD command until the 16K
tuple buffer is filled, even if the NumberOfRows
specified has been exceeded. Once the 16K tuple
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. For more information on the 16K tuple
buffer, refer to the "Concurrency Control through
Locks and Isolation Levels" chapter in the
ALLBASE/SQL Reference Manual.
If AUTOCOMMIT is OFF, this option has no effect.
NumberOfRows can be from 0 through 32,767. When
using the LOAD command for large data files, you
are recommended to increase NumberOfRows above
the initial setting of 5. For the INPUT command,
NumberOfRows should not be greater than 300.
[REV BEG]
C[ONTINUE] ON [REV END]
Initial setting is ON.
If ON, ISQL continues processing commands from a
command file after encountering an error.
[REV BEG]
C[ONTINUE] OFF [REV END]
If OFF, ISQL terminates command file processing
after encountering an error.
[REV BEG]
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.[REV END]
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.
[REV BEG]
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.[REV END]
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.
[REV BEG]
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 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.
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. The file named in the OUTPUT option
can hold 19,995 selected rows of data. If more
than 19,995 rows qualify for the SELECT
statement, a message is added to the end of the
file stating that the data is not complete. 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
Initial setting is 254.
The maximum number of bytes per row of data for
SELECT output is the PageWidth value. PageWidth
can be as large as 254. 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
[REV BEG]
* 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.[REV END]
* In prompting mode, ISQL displays the following options:
isql=> SET;
Valid set options are:[REV BEG]
autoc[ommit] autos[ave] cont[inue] conv[ert]
ec[ho] echo_[all] ed[itor] es[cape]
exit[_on_dberr] f[raction] n[ull] ou[tput]
ow[ner] pa[gewidth] pr[ompt][REV END]
Set option>
Example
isql=> LIST SET @;
autoc[ommit] - OFF
autos[ave] - 5[REV BEG]
c[ontinue] - ON
conv[ert] - OFF
ec[ho] - OFF
echo_[all] - OFF[REV END]
ed[itor] - EDITOR.PUB.SYS
es[cape] - \[REV BEG]
exit[_on_dberr] - OFF[REV END]
f[raction] - 2
n[ull] -
ou[tput] - ISQLOUT
ow[ner] - LINDA@HPSQL
pa[gewidth] - 254
pr[ompt] - isql=>
[REV BEG]
isql=> SET EDITOR TDP.PUB.SYS;
isql=>[REV END]