Unable to pass args to DB2 stored procedure

Products

• ESP Workload Automation

Issue/Introduction

Using the DB plugin on a Windows agent to access a DB2 database.  Having issues trying to run a stored procedure that requires two arguments. 

Environment

Release : 12.0

Component : WORKLOAD AUTOMATION ESP

Cause

The ARGS was missing the correct field/parm name. The correct field name for the parameter is needed for each ARGS.

Resolution

To specify multiple parameters to pass to a stored procedure, define a separate 
ARGS statement for each parameter.

Additional Information

Attached documentation link.

https://techdocs.broadcom.com/us/en/ca-mainframe-software/automation/ca-workload-automation-esp-edition/12-0/reference/statements/args-statement-specify-a-parameter-passed-to-a-stored-procedure-database-jobs.html