SQL Command Utility Supported Parameters

This table lists the supported parameters for the SQL Command Utility.

Parameter	Description
%cam	This parameter returns the current Control Account Manager (CAM). If the project is open, this parameter returns the CAM for the currently selected control account or work package in the Spreadsheet pane of the Project view.
%c	This parameter returns the current code of the code file and current CA/WP code of the project file. If the code file is open and that is the current selected view, this parameter returns the currently selected code in the Codes grid of the Code view. If the project is open and that is the current selected view, this parameter returns the code at the specified CA/WP code assignment location for the currently selected control account or work package in the Spreadsheet pane of the Project view. To specify a code assignment location, include the code assignment number in the parameter. Example: %c:1, %c:2
%cawpid	This parameter returns the current CA/WP ID. If the project is open, this parameter returns the CA/WP ID for the currently selected control account or work package in the Spreadsheet pane of the Project view.
%ca	This parameter returns the current Control Account. If the project is open, this parameter returns the currently selected control account in the Spreadsheet pane of the Project view.
%F	This parameter returns the current file.
%FT	This parameter returns the current file type.
%P	This parameter returns the current project. If the project is open or you are currently in the Explorer view and the Projects pane is displayed, this parameter returns the currently selected project.
%REP	This parameter returns the current report. If you are in the Explorer view and the All Reports or Personal Reports pane is displayed, this parameter returns the currently selected report.
%r	This parameter returns the current resource file. If the resource file is open, this parameter returns the currently selected resource file in the Resource grid of the Resource view.
%ra	This parameter returns the current resource assignment. If the project is open, this parameter returns the currently selected resource assignment in the Spreadsheet pane of the Project view.
%U	This parameter returns the current user ID.
%wp	This parameter returns the current work package. If the project is open, this parameter returns the currently selected work package in the Spreadsheet pane of the Project view.
?	This parameter returns a dynamic prompt. Dynamic prompts may contain a string or a sentence after the keyword. Example: ?project, ?"Please enter a Project", ?'Please enter a Project'
%?	This parameter returns a dynamic prompt . Dynamic prompts may contain a string or a sentence after the keyword. Example: %?project, %?"Please enter a Project", %?'Please enter a Project'
<RDBKEYNAME>	This parameter returns the Ideablade data source.
<LOGDIR>	This parameter returns the log directory.
<MYDOCDIR>	This parameter returns the My Documents directory.
THIS.cSaveFile	Use this parameter to specify the path and filename of the target file you want to generate. You may include the CSV file extension in this parameter or in the THIS.cSaveFormat parameter. Note: When the file is generated using this parameter, it will have a preceding space in the filename. For example, entering “Demo Advanced” when prompted would generate a file named “ Demo Advanced.csv”.
THIS.cSaveFormat	Use this parameter to specify the CSV file extension of the target file (if you did not specify it in the THIS.cSaveFile parameter).
THIS.lShowResults	Use this parameter to specify whether you want to display the results of your query in the results window in Cobra. You may use one of the following values: F or False: Use this value to disable the display of results. T or True: Use this value to enable the display of results.
=THIS.WRITE()	Use this parameter to write the query results in the target file.