Alphabetical list of options
200
keywords_4_0_d, keywords_4_0_c, keywords_4_0_b,
keywords_4_0_a, keywords_4_0, keywords_5_0_01,
keywords_5_0
The following statement prevents TRUNCATE and SYNCHRONIZE from
being recognized as keywords:
SET OPTION NON_KEYWORDS = ’TRUNCATE, SYNCHRONIZE’
The following statement prevents all keywords introduced since release 4.0d
from being recognized as keywords:
SET OPTION NON_KEYWORDS = ’keywords_4_0_d’
Each new setting of this option replaces the previous setting. The following
statement clears all previous settings.
SET OPTION NON_KEYWORDS =
A side-effect of this options is that SQL statements that use a turned off
keyword cannot be used: they produce a syntax error.
NULLS option [ISQL]
Specifies how NULL values in the database are displayed.
String
(NULL)
Set this according to your preference.
ON_ERROR option [ISQL]
Controls what happens if an error is encountered while reading statements
from a command file.
String. See below for allowed values.
PROMPT
Controls what happens if an error is encountered while reading statements
from a command file, as follows:
♦
STOP Interactive SQL stops reading statements from the file and
returns to the statement window for input.
♦
PROMPT Interactive SQL prompts the user to see if the user wishes to
continue.
Function
Allowed values
Default
Description
Function
Allowed values
Default
Description
To Next Page
Loading...