Verifying a Successful Package Build at the Target Host
For DB2 UDB (Windows and Linux) hosts:
1. Start the Control Center.
2. Select the Target system/instance/database.
3. Select Application Objects in the directory tree pane.
4. Double-click Packages.
5. Locate the package name in the right pane.
6. Click the Package name (PKG01).
7. Right-click on the Show Explainable Statements menu item.
8. In the Explainable Statements window, click on a statement number and right-click to select Show SQL Text.
The original dynamic SQL example statement above has been bound as:
Select EMPNO from db2admin.employee where empno > :H00001
9. For OS/400 hosts, to print the SQL information, at the command line, type:
PRTSQLINF
10. Press <F4>.
11. Enter the package name PKG01 for Object, the target Library name, and *SQLPKG for Object type.
Press <Enter>.
The output is spooled. Use the WRKSPLF command to locate the output created by the PRTSQLINF command, and then display the output via the WRKSPLF command