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", this configuration variable can also take values of "Yes," "No," "True," "False," or "On."


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.