468,107 Members | 1,294 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

MF DB2 Stored Procedure Call from SSIS 2005

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
0 4936

Post your reply

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

Similar topics

9 posts views Thread by gelangov | last post: by
13 posts views Thread by JJ297 | last post: by
9 posts views Thread by JJ297 | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.