Using the cxntest utility
Use cxntest to test connections to a target database and to issue commands when connected.
Procedure
- From a command prompt on the Unica Campaign server, run the cxntest utility.
- Enter the following information when prompted:
The utility does not prompt for confirmation of your selections.
- 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 Unica Campaign tables that start with "UA_".
- describe
table
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.
- bprint[
pattern
]