ECN-GL558 Column type GUID now supported for Microsoft SQL Server

Incidents: 2886841

RPI Number: 1108310

Product: Acu4GL

Module: MSSQL

Machines Affected: Windows

Known Versions Affected: All

DESCRIPTION:

Acu4GL for SQL Server now supports columns of type GUID for existing SQL tables.

A new configuration variable, A_MSSQL_IGNORE_GUID_COLUMNS, determines the behavior when handling existing tables that contain a column of this type. Acu4GL cannot create a new column of this type.

When A_MSSQL_IGNORE_GUID_COLUMNS is set to its default setting of FALSE, you must use COBOL data items that are at least 36 characters in size for GUID columns, otherwise an error is returned when the row is read. When writing or rewriting a row when the GUID data item is too small, SQL Server may produce an error. If you have a GUID that is larger that 36 characters, Acu4GL will only read the first 36 characters; the rest are padded with spaces.

Note: Older ODBC drivers may not be able to handle GUID column types, in which case, the results of those operations are undefined.

If you set A_MSSQL_IGNORE_GUID_COLUMNS to TRUE, columns of type GUID are ignored for any SELECT, UPDATE, or INSERT statements sent to the server. You do not need to specify a COBOL data item for these columns when reading or writing a row.