![TEMP_EXTRACT_SIZEn extract file size limits [CR 424817]](arrow-left.gif){kind=icon}
![ASIQTIMEOUT environment variable omitted [CR 418745]](arrow-right.gif){kind=icon}
To turn off the IDENTITY_INSERT database option, you must set it to an empty string, not a blank space. This was incorrectly documented in Chapter 2, “Database Options,” on page 26 (Table 2-1) and page 73, and in Chapter 6, “SQL Statements,” on page 492.
The following is incorrect:
SET TEMPORARY OPTION IDENTITY_INSERT = ' '
The correct syntax is:
SET TEMPORARY OPTION IDENTITY_INSERT = ''
The following changes apply to Chapter 2, “Database Options.”
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” on page 17.
The following note was omitted from the Example section.
To illustrate the effect of user level options on temporary options (see preceding note), 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.
