Database Integrity Utilities

ctsqlutl - c-treeSQL Maintenance Utility

Operational Model:

• Client

The FairCom DB SQL Maintenance Utility, ctsqlutl, is a general-purpose program to perform maintenance on the FairCom DB SQL Server.

The "rename column" (-rencol ) command allows you to change the name of a column. When the ctsqlutl utility is launched with the -rencol command, the program browses through the internal FairCom DB SQL dictionaries and updates the records with the new column name.

Syntax

The ctsqlutl utility syntax is as follows:

ctsqlutl [options] -rencol table_name column newcolumn

• table_name: Name of the table
• column: Current name of the column you are going to rename
• newcolumn: Name of the column after renaming

Options

• -o owner_name: Owner of table
• -d database_name: Database name (default: ctreeSQL)
• -s server_name: c-treeSQL Server name (default: FAIRCOMS)
• -u userid: userid for logging onto the c-treeSQL Server
• -a password: Password for authentication
• -h: Display usage help