8. SQL Statements : REGISTER TABLE : REGISTER TABLE Example
 
Share this page                  
REGISTER TABLE Example
Register a security audit log with various attributes:
REGISTER TABLE aud1 (
    audittime          DATE NOT NULL,
    user_name          CHAR(32) NOT NULL,
    real_name          CHAR(32) NOT NULL,
    userprivileges     CHAR(32) NOT NULL,
    objprivileges      CHAR(32) NOT NULL,
    database           CHAR(32) NOT NULL,
    auditstatus        CHAR(1) NOT NULL,
    auditevent         CHAR(24) NOT NULL,
    objecttype         CHAR(24) NOT NULL,
    objectname         CHAR(32) NOT NULL,
    objectowner        CHAR(32) NOT NULL,
    description        CHAR(80) NOT NULL,
    detailinfo         VARCHAR(256) NOT NULL,
    detailnum          INTEGER4 NOT NULL,
    sessionid          CHAR(16) NOT NULL,
    querytext_sequence INTEGER4 NOT NULL
) AS IMPORT FROM 'myfile'
WITH DBMS=SXA,
ROWS=2000;