DB2 in xMII

[Former Member]

Hi,

I am using xMII to connect to DB2 database using "IDBC connector" and Driver as "com.ibm.db2.jcc.DB2Driver"

While executing procedure in xMII with "Fixed Query with Output" Mode, am not able to return any values.

I am calling like:

"CALL process([Param.1],[Param.2]),with param as interger values,which gives error as "com.ibm.db2.jcc.a.SqlException: Invalid argument: parameter index 1 is out of range."

It is working when i executed it in Toad for DB2.

Please help me to find a solution to this.

Thanks in Advance,

Vivek Kumar.K

[jcgood25]

FixedQueryWithOutput mode is only for Oracle.

FixedQuery mode expects a resultset.

If you do not expect results from your procedure then use Command mode.

Please check http://help.sap.com for more info.