DB2 stored proc call from stored proc stage

Seya · Post by **Seya** » Thu Feb 02, 2017 10:21 pm

When I am trying to run the job which is a stored proc stage trying to call a DB2 stored procedure I am getting the below error
[IBM][CLI Driver] CLI0124E Invalid argument value. SQLSTATE=HY009'

Any solution to this issue?

Thanks!

chulett · Post by **chulett** » Fri Feb 03, 2017 8:15 am

Pass in a valid value? There's not enough information posted for anyone to help, unfortunately. Any chance you are leaving an argument empty?

Seya · Post by **Seya** » Sun Feb 05, 2017 9:43 pm

Can we call a cobol stored procedures from datastage 11.x(Parallel job) stored proc stage?

Thanks!

chulett · Post by **chulett** » Mon Feb 06, 2017 8:29 am

Okay, should have realized this was more of your other topic:

Seya wrote:Is it possible to call a cobol stored procedure in db2 mainframe (z/os) from datastage?

Also, I would appreciate if one can share the differences between a cobol stored procedure and db2 mainframe stored procedure?

Let's just put them both together here.

Me, I have no DB2 and thus no idea but strongly lean towards "no" and would suspect you would need the "mainframe" version of DataStage to that. Hopefully someone knows for certain.

And isn't a "COBOL stored procedure" just a DB2 stored procedure that calls a COBOL module?