C-LANG Statements › RUNCONTROLTABLE Statement—Specify the Table that Contains the PeopleSoft Run Parameters

RUNCONTROLTABLE Statement—Specify the Table that Contains the PeopleSoft Run Parameters

The RUNCONTROLTABLE statement specifies the name of the table that contains the run control parameters for a PeopleSoft process. You can use this statement with the RUNCONTROLARGS statement to add parameters to the run control table.

Supported Job Type

This statement is optional for the PeopleSoft job type.

Syntax

This statement has the following format:

RUNCONTROLTABLE control_table

control_table

Specifies the name of the table that contains the run parameters for a given PeopleSoft process.

Limits: Up to 100 characters; case-sensitive

Example: PS_AEREQUESTTBL

Note: Enclose values that contain delimiters (such as spaces) in double quotation marks.

Example: Add a Row of Process Parameters to a Run Control Table

In this example, the RUNCONTROLTABLE statement specifies the name of the run control table that contains the run control parameters for the XYZ process. The job inserts a new row in the PS_AEREQUESTTBL run control table with data from the run control arguments.

AGENT PSAGENT
PROCESSNAME XYZ
PROCESSTYPE 'Application Engine'
PSOPRID VP1
RUNCONTROLID test
RUNCONTROLTABLE PS_AEREQUESTTBL
RUNCONTROLARGS 'BI_WF_0001,0,O,N,0,N,,b\,sysdate'

The columns in the PS_AEREQUESTTBL run control table correspond to the run control arguments as follows: