PS_SET_BINDVAR

Use the PS_SET_BINDVAR script element to replace the value of a bind variable in a process definition.

To be able to use PS_SET_BINDVAR, you must configure your PS agent for bind variables and create process types. Then you can assign these process types to the Process Scheduler Server. Restart the Process Scheduler server to assume the changes. For more information, see Using Bind Variables.

Interface: PROCESSREQUEST_SBB

PeopleSoft Version: 8+

Syntax

PS_SET_BINDVAR NAME=... ,MODE=... ,VALUE=... [,RUNCONTROLID=...]

Parameters

Parameter	Description	Format	Allowed Values	Default Value
NAME=	Name of the bind variable that should be replaced.	script literal	n.a.	n.a.
MODE=	Type of value replacement.	script literal	V (The value is preset with the VALUE= parameter) D (The value is replaced by using a Run Control ID with the RUNCONTROLID parameter)	n.a.
VALUE=	Value that should be used for the replacement.	script literal	n.a.	n.a.
RUNCONTROLID=	Defines a Run Control ID.	script literal	n.a.	n.a.

Examples

The following two examples show how a predetermined value and a Run Control ID can be used 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'