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 2015. All Rights Reserved.