Group.. I am trying to call a AS400 Stored procedure which has two input and 3 output parameters. I understand Datastage doesn't consider output parameters and they are ignored. I am calling the procedure with two input parameters using ODBC stage/stored proc. When I executed the procdure encountered following error.
---------------------------------------------------------------------------------------------------------------------------
statement was:{call WEPGMPD.TS$GETML('SALKS', 'WPRCO')}
SQLSTATE=HY000, DBMS.CODE=-440
[DataStage][SQL Client][ODBC][DataDirect][ODBC DB2 Wire Protocol driver][DB2]No function or procedure was found with the specified name (WEPGMPD.TS$GETML) and compatible arguments.
----------------------------------------------------------------------------------------------------------------------------
The procedure is failing because it expects 3 output parameters. Do I require to pass any output parameters. We used to pass '?' as output parameter in DB2 on Unix, and is there any workaround in AS400..
Following are the input and output parameters.
INPUT - FromCtySt, ToCtySt
OUTPUT - RtnMiles, RtnMsgId, RtnMsgDes
Thanks..
Siva
_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users