Filter
Top Products
2.13 Generating a Database
A database is generated by the entry of data in the base tables. Data is entered after the storage destination database
spaces are created, and the definition of logical structures and storage structures for base tables and indexes is
completed.
Database generation methods
A database can be generated in the following two ways:
· By using a data file and the rdbsloader command (DSI initialization unnecessary)
· By creating an application program for database generation and using the INSERT statement (DSI initialization
required)
Figure: Database generation methods provides an overview of the two database generation methods: using the
rdbsloader command and using the INSERT statement of an application program.
[Figure: Database generation methods]
Generating a database by using the INSERT statement
An example of generating a database by using the INSERT statement follows.
For details on the INSERT statement, refer to the "SQL Beginner's Guide."
86