Release Overview
Version 6.0

Acu4GL

Enhancements for Acu4GL and a new utility are available in Version 6.0.

XFD files and non-unique column names

XFD files are now generated by the compiler regardless of the uniqueness of column names. In releases earlier than Version 6.0, the XFD file for the affected table was not created if column names were not unique to 30 characters. This is now a warning, not an error. Note that this change was put in place primarily to support AcuXML; it is possible that if column names are not unique to 30 characters, the resulting XFD file might not successfully access a database. Therefore, you should continue to try to keep column names unique within the first 30 characters.

acu4glfd - Creating FDs and SELECTs

acu4glfd is a Windows-based utility that can help you analyze tables and create File Descriptors and SELECT statements. The utility uses ODBC technology to retrieve table information to list the fields in the table. When possible, the utility also determines a unique index and uses that index as the primary key.

Upon request, acu4glfd generates two kinds of output:

• a file descriptor (FD), listing the names of the columns in a table and their associated data types
• a SELECT statement for the file

You can COPY the FD and SELECT statement into your COBOL program, although you may need to make some changes.

The acu4glfd utility is intended to help you jump start preparing your table for use with a COBOL program. The program determines the names of the columns, attempts to determine the appropriate ACUCOBOL-GT data type for the column, and attempts to determine the primary key. For additional information, see section 6.2 of the Acu4GL User's Guide.

© 1988-2003 Acucorp, Inc. All rights reserved.