RDBI.ADMIN_TABLE

These SQL statements create the RDBI.ADMIN_TABLE table for iSeries support.

QMF long name catalog support:

CREATE TABLE "RDBI"."ADMIN_TABLE"
(
  "AUTHID" VARCHAR(128) NOT NULL
)
;
COMMENT ON TABLE "RDBI"."ADMIN_TABLE"
 IS 'Administrator authorization ID table for RDBI';
COMMENT ON COLUMN "RDBI"."ADMIN_TABLE"."AUTHID"
 IS 'Authorization ID (user ID)';

QMF short name catalog support: The only difference is that VARCHAR(128) changes to VARCHAR(8):

CREATE TABLE "RDBI"."ADMIN_TABLE"
(
  "AUTHID" VARCHAR(8) NOT NULL
)
;
COMMENT ON TABLE "RDBI"."ADMIN_TABLE"
 IS 'Administrator authorization ID table for RDBI';
COMMENT ON COLUMN "RDBI"."ADMIN_TABLE"."AUTHID"
 IS 'Authorization ID (user ID)';

Note: This table must be populated by the iSeries system or database administrator.