Building CONNX for DB2 Sample Tables on Target Host via TCP/IP

These tables can be built during installation of the CONNX DB2 client, or later via a command prompt (MS-DOS). The following procedures encompass both methods. See DB2 Host Configuration for configuration information before attempting to install the sample database tables.

1. During installation, click Yes to install the sample database tables, or go to Start > All Programs > CONNX Sample Databases > Build DB2 Sample Data.

You may also start an MS-DOS command prompt. To do so, go to the CONNX installation directory > Utils. From the MS-DOS command prompt. start the CONNX sample tables application using start sampgen db2.

2. The first DB2 Sample Database Logon dialog box appears after the prompt, before the installation completes, or if you selected Build DB2 Sample Data in the program group. Enter the DB2 RDBNAME and the logon information.

The Build Packages check box remains unchecked, which indicates that the DB2 dynamic SQL packages have already been built in the NULLID schema. These packages must be built prior to executing the DB2 sample application.

3. Go to Settings and fill the required information.

All DB2 databases require three-part names for SQL objects, such as tables and views. A valid table name is as follows: Rdbname.schema.table.

If the Owner List field is left blank, CONNX creates the sample tables with the user ID as the schema/owner/library/collection name.

If the specified or default schema/owner/library/collection does not exist, the attempt to build the sample tables fails with a schema/owner/library/collection not found SQLState/SQLCode.