SYSIBM.DSNPROGAUTH table
The SYSIBM.DSNPROGAUTH table enables program authorization with or without program data integrity checking.
Column name | Data type | Description | Use |
---|---|---|---|
PROGNAME | VARCHAR(24)
NOT NULL |
Name of the application program that can run the plan. | G |
PLANNAME | VARCHAR(24)
NOT NULL |
Name of the application plan for the application program. | G |
PROGMDCVAL | CHAR(16)
NOT NULL FOR BIT DATA WITH DEFAULT X'000000000000000- 00000000000000000' |
Reserved. | G |
PROGMDCPAD | CHAR(1)
NOT NULL WITH DEFAULT |
Reserved. | G |
CREATOR | VARCHAR(128)
NOT NULL WITH DEFAULT CURRENT SQLID |
The authorization ID under which the row was inserted or most recently updated. | G |
ENABLED | CHAR(1)
NOT NULL WITH DEFAULT 'N' |
Whether program authorization is enabled:
|
|
CREATETS | TIMESTAMP
NOT NULL WITH DEFAULT |
The time at which the row was inserted or most recently updated. | G |
REMARKS | VARCHAR(762) | A user-specified character string. | G |