To use the cxntest utility
Use cxntest to test connections to a target database and to issue commands when connected.
1.
From a command prompt on the Campaign server, run the cxntest utility.
2.
Enter the following information when prompted:
a.
The name of the connection library for your database.
Library files are located in the same directory as the cxntest utility. For example: libdb24d.so (for DB2® on Linux™) or db24d.dll (for DB2® on Windows™).
b.
The name of the data source.
For example, the Oracle SID.
c.
A database user ID.
d.
The password that is 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]
Does an array fetch on a list of tables, 500 at a time.Optionally, specify a search pattern, where the pattern matches SQL standards, such as % for zero or more characters. For example, bprint UA_% finds all Campaign tables that start with "UA_".
*
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. Optionally, specify a search pattern, where the pattern matches SQL standards, such as % for zero or more characters.
*
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.