The schema file contains the SQL statements that you need to re-create the exported database. You can edit the schema file to modify the schema of the database.
The schema file supports all Dynamic Server 10.0, 9.40, 9.30, and 9.2x data types.
If you use the -ss option, the schema file contains server-specific information, such as initial- and next-extent sizes, fragmentation information, lock mode, the dbspace where each table resides, the blobspace where each simple-large-object column resides, and the dbspace for smart large objects. The following information is not retained:
For information about logging modes, see the IBM Informix: Guide to SQL Reference.
The statements in the schema file that create tables, views, indexes, partition-fragmented tables and indexes, roles, and grant privileges do so with the name of the user who originally created the database. In this way, the original owner retains DBA privileges for the database and is the owner of all the tables, indexes, and views. In addition, the person who executes the dbimport command also has DBA privileges for the database.
The schema file that dbexport creates contains comments, enclosed in braces, with information about the number of rows, columns, and indexes in tables, and information about the unload files. The dbimport utility uses the information in these comments to load the database.