IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

Calling OS/390 DB2 stored proc, expecting resultset

  • 1.  Calling OS/390 DB2 stored proc, expecting resultset

    Posted Thu September 12, 2002 11:20 AM

    Has anybody been able to call a DB2 stored procedure on OS/390 with the JDBC adapter and received a resultset back? We have successfully called stored procs but so far those have just had input and output parameters (Call tab). I defined my desired fields in the Results tab but received an error when I tested it.

    (059) Could not process request document of type “A”
    (108) Could not invoke script “DB2WM02PJDBCAdapterComponent2”
    (108) Could not invoke script “StoredProcedureCallOperation”
    (316) Could not execute SQL statement “{call RID01S.RDCSGLI_RPT_SALES (?, ?, ?, ?) }”.
    (22005/-99999) [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver] CLI0112E Error in assignment. SQLSTATE=22005
    at java.lang.Throwable.fillInStackTrace(Native Method)
    at java.lang.Throwable.fillInStackTrace(Compiled Code)
    at java.lang.Throwable.(Compiled Code)
    at java.lang.Exception.(Compiled Code)
    at java.sql.SQLException.(SQLException.java:43)
    at COM.ibm.db2.jdbc.DB2Exception.(DB2Exception.java:72)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(Compiled Code)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_SQLException(SQLExceptionGenerator.java:206)
    at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_return_code(SQLExceptionGenerator.java:445)


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General