Creating the DB2 tables

After the database and the table space are created, SQL statements that define the tables are executed. Figure 1 contains an example of the SQL statements that are required to create a table for the Group Basic Data record of the database unload utility.

Member RACDBUTB in SYS1.SAMPLIB contains examples that create separate tables for each record type that is produced by the database unload utility. The user must supply the user ID (userid).

Figure 1. Sample SQL utility statements: Creating a table

CREATE TABLE userid.GROUP_BD (     
     GPBD_NAME          CHAR(8)   NOT NULL, 
     GPBD_SUPGRP_ID     CHAR(8),            
     GPBD_CREATE_DATE   DATE,               
     GPBD_OWNER_ID      CHAR(8)   NOT NULL, 
     GPBD_UACC          CHAR(8)   NOT NULL, 
     GPBD_NOTERMUACC    CHAR(1)   NOT NULL, 
     GPBD_INSTALL_DATA  CHAR(254),          
     GPBD_MODEL         CHAR(44)            
     )                                      
     IN databasename.tablespacename 
     ;