Create a DB2 z/OS Table Partition › Generate Code

Generate Code

Generation is used to generate and install the source code for a database and an application. For a database, the generated code is Data Definition Language (DDL). For an application, the generated code is source code in a high-level programming language. The language depends on the options available for your configuration of CA Gen. We want to generate DDL statements for the table for which we created the table partition.

Follow these steps:

1. Click Tool, Construction, Generation.
2. Click Options, Generation Defaults.

   The Generation Defaults dialog opens.

3. Verify the DB2 z/OS Target Environment parameters and click OK, Save, or Cancel as appropriate.
4. Click Diagram, Open, DDL.

   The DDL Generation dialog opens.

5. Select the tables and click Generate, DLL, Selected.

   DLL for the table is generated. The DDL statements contain the PARTITION BY clause with the details you specified in the CA Gen DB2 z/OS Table Partitioning Plug-in.

The following are examples of generated DDL using the Employee table in the Sample model.

Example: Using a 4G Size Table Partition:

  CREATE TABLE  "EMPLOYEE"  
 ("NUMBER"      INTEGER            NOT NULL,   
  "NAME0"       CHAR(30)           NOT NULL,   
                                …
  PRIMARY KEY ("NUMBER") )
    IN "GENDB"."T0000092"
    PARTITION BY SIZE   EVERY 4G
;

  COMMIT ;

Example: Using a Range Table Partition on Employee Number:

    CREATE TABLE  "EMPLOYEE"  
    ("NUMBER"    INTEGER              NOT NULL,   
     "NAME0"     CHAR(30)             NOT NULL,   
                …
    PRIMARY KEY ("NUMBER"))
    IN "GENDB"."T0000092"
    PARTITION BY RANGE (NUMBER  ASC)
      (PARTITION 1               ENDING AT (10000),
       PARTITION 2               ENDING AT (20000),
       PARTITION 3               ENDING AT (30000),
       PARTITION 4               ENDING AT (40000),
       PARTITION 5               ENDING AT (50000),
       PARTITION 6               ENDING AT (60000),
       PARTITION 7               ENDING AT (70000),
       PARTITION 8               ENDING AT (80000),
       PARTITION 9               ENDING AT (90000),
       PARTITION 10             ENDING AT (MAXVALUE));

  COMMIT ;

Example: Using a Range Table Partition on Employee Number and Status:

   CREATE TABLE  "EMPLOYEE"  
    ("NUMBER"                                    INTEGER              NOT NULL,   
     "NAME0"                                     CHAR(30)             NOT NULL,   
     "FULL_TIME_STATUS"                          CHAR(2)               NOT NULL,   
                …
    PRIMARY KEY ("NUMBER" ))
    IN "GENDB"."T0000092"
    PARTITION BY RANGE (NUMBER ASC, FULL_TIME_STATUS DESC)
      (PARTITION 1               ENDING AT (10000, 'Y'),
       PARTITION 2               ENDING AT (20000, 'Y'),
       PARTITION 3               ENDING AT (30000, 'Y'),
       PARTITION 4               ENDING AT (40000, 'Y'),
       PARTITION 5               ENDING AT (50000, 'Y'),
       PARTITION 6               ENDING AT (60000, 'Y'),
       PARTITION 7               ENDING AT (70000, 'Y'),
       PARTITION 8               ENDING AT (80000, 'Y'),
       PARTITION 9               ENDING AT (90000, 'Y'),
       PARTITION 10             ENDING AT (MAXVALUE, 'Y'),
       PARTITION 11             ENDING AT (MAXVALUE, 'N'));

  COMMIT ;