Sample generated SQL

This example shows the SQL that can be generated to create required database objects; this SQL is proposed and it can be modified

You can edit the SQL. For example:

CREATE NODEGROUP RDBING1 ON NODE (0);

CREATE NODEGROUP RDBING2 ON NODE (0);

CREATE REGULAR TABLESPACE RDBITSSC
    IN NODEGROUP RDBING1
    MANAGED BY SYSTEM USING('RDBITSSC');

CREATE TABLE RDBI.AUTHID_TABLE
(
    PRIMARY_ID CHAR(8) NOT NULL,
    SECONDARY_ID CHAR(8) NOT NULL
)
    IN RDBITSSC
    PARTITIONING KEY (SECONDARY_ID) USING HASHING
    ;
COMMENT ON TABLE RDBI.AUTHID_TABLE
    IS 'Secondary authorization ID table FOR RDBI';