Exec

Description

Runs a public query in PeopleSoft Query and downloads the results. To run a private query, use the Exec_Private action.

Note:

Context sensitive help is available by double-clicking in the Value column to display and enter the query parameters.

Parameters

Parameter	Description
outFile=value;	The query output file.
outFolder=value ;	The folder where the result will be saved. If this parameter is missing, the system will use the value in the Local Options dialog box.
outFormat=value;	The file format that will be used to download the result file. If this parameter is missing, the system will use the value in the Local Options dialog box.
param=value;	The list of comma delimited values for all the query parameters.
0rows=value;	If the query returns zero rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.
Nrows=value;	If the query returns one or more rows, add a log entry of type value. Valid values are Pass, Fail, or Warning.