C-LANG Statements › RUNCONTROLARGS Statement—Specify the Arguments for a PeopleSoft Run Control Table

RUNCONTROLARGS Statement—Specify the Arguments for a PeopleSoft Run Control Table

The RUNCONTROLARGS statement specifies the run control arguments for a run control table on the PeopleSoft system. You can use this statement with the RUNCONTROLTABLE 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:

RUNCONTROLARGS argument|'argument,argument...'

argument

Specifies a run control argument to add to the run control table.

Limits: Case-sensitive

Notes:

• If you specify a single argument containing spaces, enclose it in single quotation marks.
• You can specify multiple arguments. Separate each argument with a comma and enclose the entire list of arguments in single quotes.
• The entire value can be up to 4078 characters.
• If the number of values specified in the RUNCONTROLARGS statement is less than the number of columns in the corresponding run control table, the agent populates the remaining columns with default values. The default value for strings is a space. The default value for all other data types is null.
• To indicate default values will be used, you can optionally add a comma at the end of the statement, for example:

  RUNCONTROLARGS 'BI_WF_0001,0,O,N,0,N,'
  

• If an argument cannot be updated with a default value, the job fails with an exception. For example, the job can fail if the database does not allow a null value within the table.

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

In this example, the RUNCONTROLARGS statement specifies the run control arguments for the PS_AEREQUESTTBL run control table . 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: