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=...

Parameters

• PS_SET_BINDVAR
  Replaces the value of a bind variable in a process definition
• NAME=
  Name of the bind variable that should be replaced
  Format: script literal
• MODE=
  Type of value replacement
  Format: script literal
  Allowed values:
  • V
    The value is preset with the VALUE= parameter
  • D
    The value is replaced by using a Run Control ID with the RUNCONTROLID parameter.
• VALUE=
  Value that should be used for the replacement
  Format: script literal
• RUNCONTROLID=
  Defines a Run Control ID
  Format: script literal
  

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'

See also: