SYSADR Table Declarations for DB2 › SYSADR.APAUT Table

SYSADR.APAUT Table

The SYSADR.APAUT table contains the DB2 table authorization IDs that were replaced by the assigned authorization IDs during the generation process. There is an entry for each assigned ID in the plan.

EXEC SQL     DECLARE SYSADR.APAUT TABLE
          (APNAME       CHAR(7)      NOT NULL,
          PGMAUTH       CHAR(8)      NOT NULL,
          PLANAUTH      CHAR(8)      NOT NULL) 

The SYSADR.APAUT table has the following columns:

• APNAME-Application plan name
• PGMAUTH-Authorization ID as it appears in the program
• PLANAUTH-New authorization ID superseding the program authorization ID