ctpath - Change Internal Database Paths

Changes the internal SQL dictionary paths of database locations.

Syntax

ctpath -s server -u user -p password -d database from-path-prefix to-path-prefix

Description

• When ctpath is executed without command line arguments, you get the full GUI version. ctpath GUI (without command line arguments) always return 0.
• When ctpath is executed with command line arguments, it runs silently and all error messages are written in a log file CTPATH.LOG stored in the same directory as the ctpath file.Error messages are appended to CTPATH.LOG file with a date and time stamp to each error message.
• ctpath with command line arguments returns 0 when the execution detected no errors, or a value different than 0 when errors were detected and the error messages are written to CTPATH.LOG.
• If you omit the -d database switch, all databases in the session will be scanned.
• Command line switches should start with a '-' or '/' character. Command line switches accept both lowercase and uppercase characters, e.g. -s or -S are the same.
• Command line switches may have optional spaces between the switch and the argument. Example: -s FAIRCOMS or -sFAIRCOMS are the same.
• Command line switches maybe entered in any order, but the from-path-prefix must appear before the to-path-prefix.