Package Identification

This section shows examples of package identification.

If a package is explained by the EXPLAIN PACKAGE command, the object identification section of the report shows the following for each SQL statement:
  • Full package name
  • Statement number
  • Statement text
  • Statement-related information

For details on how to specify EXPLAIN PACKAGE commands refer to the Report Command Reference.

Explain Identification - Package

Here is an example of a package identification.
PACKAGE LOCATION  :PMODA11
PACKAGE COLLECTION:KO2EX520
PACKAGE ID        :DGO@TPG3
PACKAGE VERSION ID:OMPE_FINAL
STATEMENT NUMBER  : 1011071
SQL STATEMENT READ FROM SYSIBM.SYSPACKSTMT:

 DECLARE C_DGOYTPG_71 CURSOR WITH HOLD FOR
 SELECT LOCATION, COLLID, NAME, CONTOKEN, OWNER, CREATOR, TIMESTAMP, BINDTIME,
 QUALIFIER, PKSIZE, AVGSIZE, SYSENTRIES, VALID, OPERATIVE, VALIDATE,
 ISOLATION, RELEASE, EXPLAIN, QUOTE, COMMA, HOSTLANG, CHARSET, MIXED, DEC31,
 DEFERPREP, SQLERROR, REMOTE, PCTIMESTAMP, IBMREQD, VERSION, PDSNAME, DEGREE,
 GROUP_MEMBER, DYNAMICRULES, REOPTVAR, DEFERPREPARE, KEEPDYNAMIC, PATHSCHEMAS,
 TYPE, DBPROTOCOL, FUNCTIONTS, OPTHINT, ENCODING_CCSID, IMMEDWRITE, RELBOUND,
 CATENCODE, REMARKS
 FROM DGO_SYSPACKAGE
 WHERE LOCATION LIKE :HV_LOC71_LOCATION AND COLLID LIKE :HV_LOC71_COLLID AND
 NAME LIKE :HV_LOC71_NAME AND VERSION LIKE :HV_LOC71_VERSION
 ORDER BY LOCATION, COLLID, NAME, PCTIMESTAMP DESC QUERYNO 001011071

STATUS   : COMPILED-BOUND USING DEFAULTS FOR INPUT VARIABLES
ISOLATION: UNCOMMITTED READ / FROM SYSPACKAGE