SAP Function ST04_DB4_GET_PKG_INFO - iSeries: Get Information about SQL Packages

Parameter Reference Type Length Default Optional Text
PACKAGE_LIBS_ONLY QQC11 C 1 'Y' X QQC11: Used for different purposes depending on QQRID
PKGLIB DB4SQLPKG-PKGLIB C 10 X iSeries: Package/Program Library (Database Monitor)
PKGNAM DB4SQLPKG-PKGNAM C 10 X iSeries: Package/Program Name (Database Monitor)
STMTNAM DB4SQLPKG-STMTNAM C 18 X iSeries: Statement Name (Database Monitor)

Parameter Reference Length Optional Text
PKGLIB_TAB DB4PKGLIB 20 X iSeries: Libraries Containing SQL Packages
PKG_CONTENT_TAB DB4PKGTXT 200 X iSeries: Content of one SQL Package
PKG_TAB DB4SQLPKG 104 X iSeries: SQL Packages

Exception Text
PACKAGE_NOT_FOUND
STATEMENT_NOT_FOUND
WRONG_ORDER_SPECIFIED