The new Identity Update feature reduces application downtime by allowing identity gaps to be fixed easily and quickly in a time-sensitive, high availability environment. The Identity Update option, which is known as “identity columns” and is used by Adaptive Server, automatically generates consecutive numeric values upon insertion of new rows, with minimal impact on performance.This new feature eliminates the identity gaps that can occur following a rough server shutdown ("shutdown with nowait") or a crash of the server process. Identity Update allows you to quickly update the “high,” out-of-range identity column values by writing a single SQL update statement that specifies the required range of rows and replaces them with correct values.You can activate the Identity Update option by calling ct_options with correct arguments and in the correct context, or by using the following syntax:
set option <option> <table_name> on/off
For the definition and use of the new Client-Library options, refer to the Open Client Client-Library/C Reference Manual.
