A_MSSQL_ADD_IDENTITY

When it is set at the default of "On", A_MSSQL_ADD_IDENTITY adds an extra column to any table created by the Acu4GL for Microsoft SQL Server product. The extra column will have the identity property, and will be included on all indexes that are not unique. Otherwise, when A_MSSQL_ADD_IDENTITY is set at "False", an extra column is not added.

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

Example

     A_MSSQL_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.

While the default value is "On" (true, yes), this configuration variable can also take values of "Off" (false, no).