The maximum size of c-treeACE SQL statements has been greatly expanded. Statements can now dynamically grow up to 32MB, providing for the most complex SQL statements. (Prior versions imposed a restrictive 35,000-character limit on SQL statements.) Statements larger than this are refused by the server.
Note: The client APIs do not impose any limitation on the maximum statement size. However, some tools, such as ISQL, dbload, dbdump, and dbschema, still impose a statement-size limitation of 35,000 characters.