Unable to pass args to DB2 stored procedure

book

Article ID: 224923

calendar_today

Updated On:

Products

CA Workload Automation ESP Edition

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. 

Cause

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

Environment

Release : 11.4

Component : CA ESP WORKLOAD AUTOMATION

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/11-4/reference/statements/args-statement-specify-a-parameter-passed-to-a-stored-procedure-database-jobs.html