Hi,
We have requirement to call a stored procedure on iSeries/AS400 system.
We are connecting target system via ODBC Stage. The drivers we use to connect is VMdb200.so in .odbc.ini file
Issue:
We are trying to call a remote store procedure with first 3 as input column and last 2 column as "inout" parameter.
I tried to call the stored proc as below.
1) CALL dbschema.SP('a','b','c',?,?); - Error
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value
2) CALL dbschema.SP('a','b','c',' ',' '); - Error
SQLSTATE=S1000, DBMS.CODE=-469
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]Unknown error: SQLCODE -469
3) {CALL dbschema.SP('a','b','c',?,?)}; - Error
SQLSTATE=S1009, DBMS.CODE=0
[DataStage][SQL Client][ODBC][DataDirect][ODBC lib] Invalid argument value
4) {CALL dbschema.SP('a','b','c',' ',' ');} - Error
SQLSTATE=S1000, DBMS.CODE=-469
[DataStage][SQL Client][ODBC][IBM(DataDirect OEM)][ODBC DB2 Wire Protocol driver][UDB DB2 for iSeries and AS/400]Unknown error: SQLCODE -469
------------------------------
Then I asked the developer for AS400 to drop the inout parameters since I read somewhere ODBC Stage is not capable of handling inout OR Out parameters.
The procedure worked fine with only 3 input parameters.
Do we really have a limitation to use inout or Out parameter with ODBC stage?
Note: I'm not able to use store procedure stage since it is not able to connect to target db.
Call Stored Procedure on iSeries/AS400 System in ODBC Stage
Moderators: chulett, rschirm, roy
Call Stored Procedure on iSeries/AS400 System in ODBC Stage
-----------------
Thanks
Thanks