prefix field length limited to 10 should be increased

IBM will use this Idea as input to planning, but no commitment is made or implied. This Idea will be updated in the future if IBM implements it. IBM will use votes and comments from others in the community to help prioritize this Idea.

Note that the restriction is not a limit on the length of the PREFIX. It is a limit on the length of the prefixed field name. After applying the prefix, the new name cannot be longer than 14 characters.

This restriction does not apply when the ALIAS keyword is specified for the file.

This restriction does not apply to externally-described data structures.

- IBM Power Systems Development

Here is the SQL for the files.

CREATE OR REPLACE TABLE PADTA.Authentication_Header

FOR SYSTEM NAME AUTHDR00

(HEADER_ID FOR BATCHID DECIMAL(11, 0) NOT NULL

GENERATED ALWAYS AS IDENTITY

(START WITH 1, INCREMENT BY 1) ,

CUSTOMER_ID FOR AUTCID CHAR(8) NOT NULL DEFAULT '',

AUTHENTICATION_BATCH_ID FOR APIBATID INTEGER NOT NULL DEFAULT 0 ,

DATALOAD_USER FOR DLUSER CHAR(10) NOT NULL DEFAULT '' ,

DATALOAD_DATE FOR DLDATE DATE NOT NULL

DEFAULT CURRENT DATE ,

DATALOAD_TIME FOR DLTIME TIME NOT NULL

DEFAULT CURRENT TIME ,

AUTHENTICATION_COUNT FOR TOTCOUNT INTEGER NOT NULL DEFAULT 0 ,

SUCCESS_COUNT FOR SUCCESS INTEGER NOT NULL DEFAULT 0 ,

FAIL_COUNT FOR FAIL INTEGER NOT NULL DEFAULT 0 ,

PENDING_COUNT FOR PENDING INTEGER NOT NULL Default 0 ,

API_RETURN_CODE FOR RTNCODE INTEGER NOT NULL DEFAULT 0 ,

STATUS_TEXT FOR STATUS CHAR(20) NOT NULL DEFAULT '' ,

ADD_PROGRAM FOR ADDPGM CHAR(10) NOT NULL Default '' ,

LAST_CHANGE_USER FOR LSTCUSR VARCHAR(128) NOT NULL

GENERATED ALWAYS

AS (SESSION_USER) ,

LAST_CHANGE_PROGRAM FOR LSTCPGM VARCHAR(20) NOT NULL

Default ' ' ,

LAST_CHANGE_DATE FOR LSTCHGDAT NOT NULL

GENERATED ALWAYS

FOR EACH ROW ON UPDATE

AS ROW CHANGE TIMESTAMP ,

PRIMARY KEY(BATCHID)

)

RCDFMT RAUTHDR

;

CREATE OR REPLACE TABLE PADTA.Authentication_Status FOR SYSTEM NAME AUTSTS00

(AUTHENTICATION_ID FOR AUTID DECIMAL(11, 0) NOT NULL

GENERATED ALWAYS AS IDENTITY

(START WITH 3, INCREMENT BY 1) ,

MTM_AUT_WEB_USER_ID FOR AUTWEBID CHAR(50) NOT NULL DEFAULT '' ,

MTM_AUT_PASSWORD FOR AUTPWD CHAR(50) NOT NULL DEFAULT '' ,

MTM_AUT_EMAIL FOR AUTEMAIL CHAR(80) NOT NULL DEFAULT '' ,

MTM_AUT_FIRST_NAME For AUTFNAME CHAR(30) NOT NULL DEFAULT '' ,

MTM_AUT_LAST_NAME For AUTLNAME CHAR(40) NOT NULL DEFAULT '' ,

MTM_AUT_EMPLOYEE_UUID For AUTUUID CHAR(36) NOT NULL DEFAULT '' ,

MTM_AUT_EMPLOYEE_ID For AUTEMPID CHAR(10) NOT NULL DEFAULT '' ,

MTM_AUT_CUSTOMER_ID For AUTCID CHAR(8) NOT NULL DEFAULT '' ,

MTM_AUT_SERVICE_ORDER For AUTSRVORD CHAR(8) NOT NULL DEFAULT '' ,

MTM_AUT_RECIPIENT_ID For AutRcp Char(10) NOT NULL DEFAULT '' ,

MTM_AUT_RECIPIENT_ALT For AutRCPA Char(50) NOT NULL DEFAULT '' ,

MTM_AUT_ACCOUNT_TYPE For AUTACTTYP CHAR(30) NOT NULL DEFAULT '' ,

MTM_AUT_BATCH_USER FOR AUTBUSER CHAR(10) NOT NULL DEFAULT '' ,

MTM_AUT_BATCH_DATE FOR AUTBDATE Date NOT NULL

DEFAULT CURRENT_DATE ,

MTM_AUT_BATCH_TIME FOR AUTBTIME TIME NOT NULL

DEFAULT CURRENT_TIME ,

-- Batch user || Batch date || Batch time = PAS Batch ID

MTM_AUT_STATUS FOR AUTSTATUS CHAR(1) NOT NULL DEFAULT '' ,

MTM_AUT_RETRY FOR AUTRETRY DECIMAL(3, 0) NOT NULL DEFAULT 0 ,

API_DATETIME_PROCESSED FOR AUTPRCDT TIMESTAMP NOT NULL

DEFAULT '1900-01-01-00.00.00.000000' ,

API_ERROR_MESSAGE FOR AUTERROR CHAR(60) NOT NULL DEFAULT '' ,

ADD_TIMESTAMP FOR ADDDATE TIMESTAMP NOT NULL

DEFAULT CURRENT_TIMESTAMP ,

ADD_USER FOR ADDUSER CHAR(10) NOT NULL Default ' ' ,

ADD_PROGRAM FOR ADDPGM CHAR(10) NOT NULL Default ' ' ,

LAST_CHANGE_USER FOR LSTCUSR VARCHAR(128) NOT NULL

GENERATED ALWAYS

AS (SESSION_USER) ,

LAST_CHANGE_PROGRAM FOR LSTCPGM VARCHAR(20) NOT NULL

Default ' ' ,

LAST_CHANGE_DATE FOR LSTCHGDAT NOT NULL

GENERATED ALWAYS

FOR EACH ROW ON UPDATE

AS ROW CHANGE TIMESTAMP ,

PRIMARY KEY(AUTID)

)

RCDFMT RAUTSTS

;