Creating Tables With ESQL — create.sqb

The create program creates a table and loads data into it from the text or line sequential “customer” file. The table that is created provides the source data for the other sample programs, so be sure to compile create.sqb and run create.acu before working with the other programs.

This program demonstrates the following ESQL and SQL concepts:

• The WHENEVER statement
• Use of DDL (Data Definition Language) to create tables
• The INSERT statement

When you run the create program, you see the following on your screen: