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.