![Correction to ASA NUMERIC data type default precision [CR 461147]](arrow-left.gif){kind=icon}
![Using correct syntax when creating stored procedures [CR 456307]](arrow-right.gif){kind=icon}
In Table 2-1, the VALUES column for the option IDENTITY_INSERT contains an error. The value string is followed by a single quotation mark where none should appear.
The following changes apply to Chapter 2, “Database Options.”
In the section “IDENTITY_INSERT option,” the final example should read:
To turn the option off, specify the equals sign and an empty string:
SET TEMPORARY OPTION IDENTITY_INSERT = "
The following note was omitted from the Scope section.
If you set a user level option for the current option,
the corresponding temporary option is also set. For details, see “Scope
and duration of database options” in Chapter 2, “Database
Options.”
The following note was omitted from the Example section.
To illustrate the effect of user level options on temporary options (see note above), if you are connected to the database as DBA, and issue:
SET OPTION IDENTITY_INSERT = 'customer'
the value for the option is set to customer for the user DBA and temporary for the current connection. Other users who subsequently connect to the database as DBA find their option value for IDENTITY_INSERT is customer also.
