Configuring the Agent Plug-in › Unquote Bind Variables

Unquote Bind Variables

You can override the default agent plug-in behavior of quoting resolved bind variables. For most Process Types, bind variables should be quoted. One known exception is the Process Type of Informatica. To unquote bind variables, configure the following parameter on the agent:

ps.unquoteBindVar.Process_Type

Sets how the agent plug-in handles quotation marks for bind variables for a specified Process Type, as follows:

custom

Lets you specify the Process Names for the bind variables that should be unquoted.

false

Sets bind variables in quotation marks for a specified Process Type.

true

Does not set bind variables in quotation marks for a specified Process Type. For example, if you specify ps.unquoteBindVar.Informatica, the resolved bind variables are not quoted for the Informatica process type.

Default: false

Process_Type

Specifies the name of the process. If there is a space in the Process Type, use an underscore instead of a space.

Examples: ps.unquoteBindVar.Informatica, ps.unquoteBindVar.Application_Engine

Example: Unquote Bind Variables for a Process

The following example unquotes bind variables only for the Process Name OMC3220-:

ps.unquoteBindVar.Crystal=custom
ps.unquoteBindVar.Crystal.OMC3220-=true

Restricting Access to the PeopleSoft Database

You can restrict access to the PeopleSoft database by granting privileges to the user ID the agent plug-in uses to connect to the database. Grant UPDATE, INSERT, and SELECT privileges to this user and specify the user ID in the ps.db.accessId parameter.

The agent plug-in requires UPDATE and INSERT access to the following PeopleSoft database tables:

• PS_CDM_AUTH
• PS_PRCSRQSTDIST
• PS_CDM_LIST
• PSPRCSRQSTTEXT
• PSPRCSPARMS
• PSPRCSQUE
• PSPRCSRQST
• PS_PRCSSYSTEM
• PS_PRCSRUNCNTL
• PS_PRCSSEQUENCE (in PeopleTools 8.4 and higher)
• PS_PRCSSYSTEM (in PeopleTools lower than 8.4)

The agent plug-in requires SELECT access to Process Scheduler database tables. We recommend that you allow SELECT access to all tables prefixed by PS or PS_.

Default Values for PeopleSoft Jobs

You can set default values for PeopleSoft jobs by configuring the corresponding parameters in the agentparm.txt file. Setting defaults can save time and can prevent job definition errors for details that are common to all your jobs. Specify these details in a job definition only when you want to override the default parameters.

You can set default values for the following PeopleSoft job details:

• run control ID
• operator ID and password
• output destination format for a PeopleSoft report
• output destination type for a PeopleSoft report

To set default values for PeopleSoft jobs, configure any of the following parameters on the agent:

• ps.default.runCntlId
• ps.default.oprId
• ps.default.oprPassword
• ps.default.outDestFormat
• ps.default.outDestType

Notes:

• Remove the comment syntax (#) from the parameter.
• Encrypt the password that you set for the ps.default.oprPassword parameter.