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