DB2 graphic  QMF Version 8

Sample Generated SQL

The following 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';


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004