To define static SQL statements for the static DB2 package

Click the Add button in the CONNX Data Dictionary Manager window.

The Enter the Name of the New Table or View dialog box appears. Type a user-defined character string in the SQL Object Name text box.

$image\db2pkg05.jpg$

Select DB2 Static SQL in the Object Type list box.

Select the package name in the Database list box.

Click the OK button.

The Static SQL Properties tab is selected in the lower pane of the CONNX Data Dictionary Manager window. Type a dynamic SQL statement in the CONNX SQL Statement text box.

$image\db2pkg06.jpg$

Click the Verify SQL button to view the results of the DB2 SQL statement in the lower DB2 SQL Statement pane.

$image\db2pkg07.jpg$

Select the Static SQL Columns tab, which displays the attributes of the result column(s) and the input parameter(s) of the static SQL statement.

$image\db2pkg08.jpg$

The first static SQL statement in package PKG01 is now defined. To bind another static SQL statement, return to the main CDD window and click the Add button. In keeping with the naming convention of step 2, define a user-defined SQL Object Name = PKG0102, an object type = DB2 Static SQL, and select package PKG01 from the list box.

$image\db2pkg09.jpg$

Enter the dynamic SQL UPDATE statement as it appears in the CONNX SQL Statement list box.

Click the Verify SQL button. The DB2 SQL statement appears in the lower window.

$image\db2pkg11.jpg$

Return to the main CDD window and click the Add button. In keeping with the naming convention of step 2, define a user-defined SQL Object Name = PKG0103, an object type = DB2 Static SQL, and select package PKG01 from the list box.

Enter the dynamic SQL DELETE statement as it appears in the CONNX SQL Statement list box.

Click the Verify SQL button. The DB2 SQL statement appears in the lower window.

$image\db2pkg15.jpg$

Select the Static SQL Columns tab, which displays the attributes of the result column(s) and the input parameter(s) of the static SQL statement (not shown).

Return to the main CDD window and click the Add button. In keeping with the naming convention of step 2, define a user-defined SQL Object Name = PKG0104, an object type = DB2 Static SQL, and select package PKG01 from the list box.

$image\db2pkg17.jpg$

Enter the dynamic SQL INSERT statement as it appears in the CONNX SQL Statement list box.

Click the Verify SQL button. The DB2 SQL statement appears in the lower window.

$image\db2pkg19.jpg$

Select the Static SQL Columns tab, which displays the attributes of the result column(s) and the input parameter(s) of the static SQL statement.

Return to the main window and click the PKG01 icon. Then click the Rebuild Package button.

If you are not currently logged on to the target host, the CONNX DB2 Database Logon dialog box appears.

CONNX logs on to the target host and issues Static SQL Binds into package PKG01 for the four statements described in the preceding steps.

$image\db2pkg23.jpg$