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 |