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!
DB2 stored proc call from stored proc stage
Moderators: chulett, rschirm, roy
DB2 stored proc call from stored proc stage
Can we call a cobol stored procedures from datastage 11.x(Parallel job) stored proc stage?
Thanks!
Thanks!
Okay, should have realized this was more of your other topic:
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?
Let's just put them both together here.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?
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?
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers