PS_SET_BINDVAR

Replaces the value of a bind variable in a process definition. For more information, see Using Bind Variables.

Interface: PROCESSREQUEST_SBB
PeopleSoft Version: 8+

Syntax

PS_SET_BINDVAR

NAME=...
,MODE='V'
,VALUE=...

PS_SET_BINDVAR

NAME=...
,MODE='D'

,RUNCONTROLID=...

Syntax	Description/Format
NAME=	Name of the bind variable that should be replaced. Format: script literal
MODE=	Type of replacement. Format: script literal Allowed values: "V" and "D" "V" - The value is predetermined with the parameter "VALUE=". "D" - Replacement is made using a Run Control ID with the parameter "RUNCONTROLID".
VALUE=	Value that should be used for the replacement. Format: script literal
RUNCONTROLID=	Specification of a Run Control ID. Format: script literal

To use this script element, you must follow the instructions in the "Configuration for using bind variables" section in the agent's new installation description. This section describes how you can create process types. Afterward, you assign the process types to the Process Scheduler Server and then you restart the Process Scheduler Server in order to assume these modifications.

Examples

The following two examples show how a predetermined value and a Run Control ID can be used in order to replace bind variables:

PS_SET_BINDVAR NAME=':RUN_CNTL_HR.COURSE',VALUE='K014',MODE='V'
PS_RUN_PROCESS PROCESSNAME='TRN023--',PROCESSTYPE='Crystal',RUNCONTROLID='ang',RUNLOCATION='PSNT'

PS_MODIFY_RUNCONTROL RUNCONTROLID='ang',RECORDNAME='RUN_CNTL_HR',FIELDNAME='COURSE',FIELDVALUE='K014'
PS_SET_BINDVAR NAME=':RUN_CNTL_HR.COURSE',VALUE='',MODE='D',RUNCONTROLID='ang'
PS_RUN_PROCESS PROCESSNAME='TRN023--',PROCESSTYPE='Crystal',RUNCONTROLID='ang',RUNLOCATION='PSNT'