c-tree HUGE file Support with c-treeSQL

The c-treeSQL Server by default does not create HUGE files, allowing as much backward compatibility as possible with existing applications. However, HUGE files can be enabled at table creation time. Use the following extended syntax when specifying a c-treeSQL CREATE TABLE command:

CREATE TABLE my_big_table(name CHAR(20), age INT) STORAGE_ATTRIBUTES 'HUGE'

The STORAGE_ATTRIBUTES syntax allows you to specify the specific c-tree storage attribute of HUGE. Note that the parameter HUGE must be surrounded by single quotes when using this c-treeSQL syntax.

When designing c-tree Plus applications for later use with c-treeSQL, HUGE attributes are retained during the import process. When building your tables with ISAM, this requires extended header support by defining an XCREblk and OR'ing ctFILEPOS8 into the file mode parameter. With the easy-to-use c-treeDB API, simply OR CTCREATE_HUGEFILE into the file mode parameter.