SQL Command Utility
The SQL Command Utility is a powerful export and global update utility that enables you to run SQL commands and scripts against Cobra tables.
SQL is an ANSI standard computer language for accessing and manipulating databases.
For example, this SQL command returns all of the data in the CAWP table:
SELECT * FROM CAWP
This statement would return all of the data found in the CAWP table.
- CSV
- XLS
There are several sample scripts shipped with Cobra, for example, BDNLeg.SQL. These scripts can be found in the Cobra\Samples\Scripts folder. Most of the scripts found in this folder must be modified to work with your data. For example, many scripts contain the following:
WHERE PROGRAM = 'DEMOADV'
- DeleteActuals.sql: Use this script to delete the actual costs in the current period.
- DropTables.sql: Use this script to drop the tables in an Oracle implementation.
- Display Orphaned Tphase Records.sql: Use this script to select orphaned T-phase records in the T-phase table. This is useful in determining the magnitude of the data error.
You can also use the SQL Command Utility as a global update command. It is very important, however, that you make a backup of your project before executing any update or delete statements in the utility. Most standard SQL commands work using this utility.
The SQL Command Utility provides direct access to the database. Only subject matter experts should be granted access to this menu item.
- Related Topics:
- SQL Command Utility Dialog Box
Use this dialog box to run SQL commands and scripts against Cobra tables. - SQL Command Utility Supported Parameters
This table lists the supported parameters for the SQL Command Utility. - SQL Language Extended Support
You can use SQL scripts to perform actions such as getting the USER ID and the program name. - Procedures
Use the procedures to run the SQL Command Utility.