CREATE TABLE

The statement "CREATE TABLE" is distend for creation
a permanent and temporary Base Table.
The following statement creates a global temporary table
whose rows will be preserved between transactions. The primary
key is based on the "ID_NAMS" domain; the other columns are
based on standard data types:

     CREATE GLOBAL TEMPORARY TABLE Fluctuation 
     ( item_num       id_nums, 
       item_name      CHAR NOT NULL, 
       start_price      DEC, 
       max_price        DEC, 
       min_price        DEC,    
 	      avg_price        DEC,  
       end_price        DEC  
       ON COMMIT PRESERVE ROWS );

The next illustration shows the table called "FLUCTUATIONS"
was created by the statement "CREATE TABLE"

FLUCTUATIONS.

You can see another example of creating a table.

Back to SQL statements.

CREATE TABLE

CREATE GLOBAL TEMPORARY TABLE Fluctuation ( item_num id_nums, item_name CHAR NOT NULL, start_price DEC, max_price DEC, min_price DEC, avg_price DEC, end_price DEC ON COMMIT PRESERVE ROWS );