By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,617 Members | 1,166 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,617 IT Pros & Developers. It's quick & easy.

MF DB2 Stored Procedure Call from SSIS 2005

P: 2
I am trying to call a mainframe cobol DB2 Stored Procedure from an SSIS 2005 SQL Task in BIDS. I believe that privileges and the number of parameters (6) are fine. I've tried casting and still have no luck. The error is SQL0440N. I am running with DB2 Client 8.2.4. The sql call in BIDS looks like...

call ODW.ODWCY002 ('TN',cast '43','04/20/2006',0,' ',' ')

the linkage section in the cobol sp looks like...

01 LK01-ODW-ST-CD PIC X(02).
01 LK01-ODW-ST-CD-NBR PIC X(02).
01 LK01-ODW-PROCD-DT PIC X(10).
*********************************************
RETURN VARIABLES TO CALLING ROUTINE
*********************************************
01 LK01-ODW-SQLCODE PIC S9(09).
01 LK01-ODW-ABORT-PARA PIC X(04).
01 LK01-ODW-ABORT-TEXT PIC X(04).


does anyone have a clue?

5/24/6 i am getting the same problem when running...
a) vb.net, oledb connection under ssis script task
b) vb.net, DB2 connection under ssis script task
c) vb.net, no ssis, console app, vs 2005, db2 connection
d) c#, no ssis, console app, db2 connection
May 19 '06 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.