To use the cxntest utility
1.
From a command prompt on the Campaign server, run the cxntest utility.
2.
The cxntest utility is prompt-driven. You must enter the following information at the prompts:
a.
The name of the connection library for your database
b.
The name of the data source
c.
A database user ID
d.
The password associated with the database user ID
The utility does not prompt for confirmation of your selections.
3.
If the connection is successful, you can enter the following commands at the prompt:
*
bprint[pattern]
*
Performs an array fetch on a list of tables, 500 at a time. Can optionally specify a search pattern.
*
describetable
*
Describes the specified table. Returns each column name and its corresponding data type, storage length, precision, and scale.
*
exit
*
Terminates the database connection and exits.
*
help
*
Displays a list of supported commands.
*
print [pattern]
*
Returns a list of tables. Can optionally specify a search pattern.
*
quit
*
Terminates the database connection and exits.
*
SQL_command
*
Executes any valid SQL command or series of SQL commands.
Copyright IBM Corporation 2012. All Rights Reserved.