ContentsIndexPreviousNext

A_SYB_ADD_IDENTITY

When it is set at the default of TRUE, A_SYB_ADD_IDENTITY adds an extra column to any table created by the Acu4GL for Sybase product. The extra column will have the identity property, and will be included on all indexes that are not unique. Otherwise, when A_SYB_ADD_IDENTITY is set at "False", an extra column is not added. While the default value is "Off" (false, no), this configuration variable can also take values of "On" (true, yes).


Note: The COBOL FD should not include the identity column.

Example

     A_SYB_ADD_IDENTITY TRUE

On keys that allow duplicates, this variable has been found to vastly improve performance. Note that the default value is "True" for a file that allows duplicates, and is "False" for a file with no duplicate keys.