Notes
Default values: The default values for
the options depend on the language, object type, and the options in effect
at create time:
- When an SQL procedure, SQL function, or SQL trigger is created, the default
values for the options are those in effect at the time the object is created.
For example, if an SQL procedure is created and the current COMMIT option
is *CS, *CS is the default COMMIT option. Each option is then updated as it
is encountered within the SET OPTION statement.
- For application programs other than REXX, the default values for the options
are specified on the CRTSQLxxx command. Each option is then updated as it
is encountered within a SET OPTION statement. All SET OPTION statements must
precede any other embedded SQL statements.
- At the start of a REXX procedure the options are set to their default
value. The default value for each option is the first value listed in the
syntax diagram. When an option is changed by a SET OPTION statement, the new
value will stay in effect until the option is changed again or the REXX procedure
ends.
Syntax alternatives: The following keywords are synonyms
supported for compatibility to prior releases. These keywords are non-standard
and should not be used:
- *UR can be used as a synonym for *CHG.
- *NC can be used as a synonym for *NONE.
- *RS can be used as a synonym for *ALL.
(C) Copyright IBM Corporation 1992, 2006. All Rights Reserved.