Creating the Database

Now you are ready to create the data model as tables in a database. You do this with the CREATE DATABASE, CREATE TABLE, and CREATE INDEX statements. The syntax for these statements is described in the IBM Informix: Guide to SQL Syntax. This section discusses how to use the CREATE DATABASE and CREATE TABLE statements to implement a data model.

Remember that the telephone directory data model is used for illustrative purposes only. For the sake of the example, it is translated into SQL statements.

You might have to create the same database model more than once. You can store the statements that create the model and later re-execute those statements. For more information, see Using Command Scripts.

When the tables exist, you must populate them with rows of data. You can do this manually, with a utility program, or with custom programming.