DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Mar 09, 2004 10:33 am Reply with quote    Back to top    

Group. I am trying to call a AS400 Stored procedure with two input and 3 output parameters.

_______________________________________________
datastage-users mailing list
datastage-users@oliver.com
http://www.oliver.com/mailman/listinfo/datastage-users

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
admin
Site Admin



Joined: 12 Jan 2003
Posts: 8720

Points: 10

Post Posted: Tue Mar 09, 2004 10:47 am Reply with quote    Back to top    

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

_________________
PLEASE READ
Do not contact admin unless you have technical support or account questions. Do not send email or Private Messages about discussion topics to ADMIN. Contact the webmaster concerning abusive or offensive posts.
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours