Embed data-definition statements
Data-definition statements, the SQL statements that create databases and modify the definitions of tables, are not usually put into programs. The reason is that they are rarely performed. A database is created once, but it is queried and updated many times.
The creation of a database and its tables is generally done interactively, using DB-Access. These tools can also be run from a file of statements, so that the creation of a database can be done with one operating-system command. The data-definition statements are documented in the HCL OneDB™ Guide to SQL: Syntax and the HCL OneDB Database Design and Implementation Guide.