6. QUEL and EQUEL Statements : Create Statement—Create a Table : Examples
 
Share this page                  
Examples
The following examples provide details.
Example 1:
The following example shows the use of the create statement to create the "employee" table:
## create employee 
## (eno = i2,
## ename = c20,
## age = i1,
## job = i2,
## sal = money with null,
## dept = i2)
## with journaling
Example 2:
The following example illustrates the use of a host variable with the create statement to create a table whose definition is decided at runtime:
tablevar = "mytable"
descvar = "name = c20, phone = c11"
## create tablevar (descvar)