Limits and Restrictions

AcuSQL does not currently support any large object data types (LOBs). If your existing applications include LOBs, contact our Technical Services department for help evaluating the steps you need to take in order to use AcuSQL.

In addition, AcuSQL does not currently support compound SQL statements. For this reason, statements of the form:

EXEC SQL
     DROP TABLE table-name1
     DROP TABLE table-name2
END-EXEC

should be broken into single statements of the form:

EXEC SQL
     DROP TABLE table-name1
END-EXEC
EXEC SQL
     DROP TABLE table-name2
END-EXEC

Likewise, DCLGEN generated code must be split into data and procedure section files, and FILLER cannot be used as a group item.

Aside from these restrictions, you need to be aware that different databases react differently to SQL commands. For instance, during transaction management, Access performs an SQL COMMIT after a DROP TABLE, but DB2 does not. In order to discover the limits and restrictions of your database, talk with a knowledgeable database administrator.