Welcome Serena Central users! CLICK HERE
The migration of the Serena Central community is currently underway. Be sure to read THIS MESSAGE to get your new login set up to access your account.
SadriB Absent Member.
Absent Member.
738 views

GUID - unknown data type for ACU4GL

We would like to introduce "replication" process to our databases built in MSSQL version of 2008 R2.  We use ACU4GL to handle our I/O operation. Our ACUCOBOL run time varies but minimum 9.2.0 + ECN-GL524.

The first step of the replication implementation is to add “Globally Unique Identifier – GUID” to each table. GUID column has its own datatype and cannot be changed to another datatype. These GUID columns are not referenced by COBOL (ie. FDs don’t have them hence XFDs don’t have them either). We expect that COBOL/ACU4GL will disregard them like A4GLIDENITY column.

However, we get an error “unknown datatype for column xx: GUID (-11)” and program abends with 9D, 23 (where xx is the column number of GUID column added).

I was wondering anyone in Micro Focus community had similar issue with GUID datatype and how you have overcome this issue?

Tags (1)
0 Likes
1 Reply
DougP Outstanding Contributor.
Outstanding Contributor.

RE: GUID - unknown data type for ACU4GL

This functionality has been added and will be included in a future release. Additionally, there is a patch which adds this functionality into version 10.1.0. If you are running 10.1.0, raise a support incident and request the patch. If you are on a version prior to 10.1.0 you will need to upgrade and then request the patch.
In the meantime the workaround is to create a view which excludes the GUID column, then configure your application to run against that view rather than the underlying table.

0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.