Cobra 8.3 Help System

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

SQL Command Process

Use the SQL Command API process to automate SQL scripts, which is helpful in exporting data or running SQL scripts on data.

Process Settings

Below are the settings you must define for the SQL Command API process:

Setting Description Sample Value
ProcessID This ID informs Cobra to run the SQL Command process. SQLCommand
SQLCommand This setting refers to the SQL command that runs during the API process. It can either be a one-line SQL command or a file containing a SQL script.

If you specify a SQL script file that contains the statements you want to run, Cobra retrieves the value in this field and checks if it exists as a file. If it does, Cobra loads the contents and runs the file; otherwise, Cobra runs the value directly as a SQL statement.

This setting is required.

C:\ProjectFiles\Deltek\Cobra\sqlexample.sql
SaveAsFile This setting refers to the full path and filename of the data exported after the command runs.

This setting is needed only when the SQL command is a Select command.

If no extension is used, the default is .csv.

If you do not specify a filename, data is saved in the file sql.csv in the Cobra directory.

This setting is optional. By default, this setting is set to not save.

C:\ProjectFiles\Deltek\Cobra\

System\sqlexample.csv

Sample Script

Below is a sample script file for the SQL Command API process:

[Process020]

ProcessID=SQLCommand

SQLCommand=C:\ProjectFiles\Deltek\Cobra\sqlexample.sql

SaveAsFile=C:\ProjectFiles\Deltek\Cobra\System\sqlexample.csv