The GENERATE PACKAGE command also updates three DB2 plan tables. The rows in these tables record all programs participating in the package and any changes by the ASSIGN AUTHID command. You can query these tables using SQL (in the same way that you query other tables) to answer questions such as, “Which package does program x participate in?”
"SYSADR Table Declarations for DB2" appendix illustrates the layout of these tables, named SYSADR.APTAB, SYSADR.APRES, and SYSADR.APAUT, respectively.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|