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;