| Generating applications with the default template / Modeling the database | |
The Application Generator manages the database SERIAL columns by using a single table named seqreg in the meta-schema (4dbx). However, the native SERIAL management is used for Informix® databases.
The seqreg table contains two columns; one with the name of the table having a SERIAL column and one with the last SERIAL column value for that table. If the database schema does not contain SERIAL columns, the seqreg table is not required in the schema. The seqreg table is required in the schema except for Informix databases where the native SERIAL management is used.
You may initialize the seqreg table with the appropriate records otherwise SERIAL columns will start at number 1.
For further information on how the seqreg table is used, see the BDL User Guide, "Solution 2: Generate serial numbers from your own sequence table".