A-MSSQL-ADD-TIMESTAMP

Using a timestamp column is the only way to absolutely ensure modifications made to a row are not overwriting someone else's changes. When it's reading a table that is open for I/O, the Acu4GL for Microsoft SQL Server product uses BROWSE MODE if a timestamp column exists. When the Acu4GL product is creating a table, if the value of A-MSSQL-ADD-TIMESTAMP is TRUE, then a timestamp column is included in the table. (Note that your COBOL FD should not include the timestamp column.) While the default value is "Off", this configuration variable can also take values of "Yes," "No," "True," "False," or "On."

Note: Microsoft discourages the use of BROWSE MODE on Select statements due to performance reasons. Therefore, unless it is absolutely necessary, Acucorp discourages the variable being set to "On."

Example

A-MSSQL-ADD-TIMESTAMP  1

Note: If you do not use this option, be prepared for REWRITE statements to fail with an error stating that someone else has modified the row. Because of the AcuLocks tables, this can only happen from non-ACUCOBOL-GT applications.