IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.


#Sterling
#Supplychain
 View Only

  • 1.  DB2 Stored Procedure Call retuning cursor

    Posted 09/06/07 04:41 PM

    Originally posted by: SystemAdmin


    Hi

    I am a newbie to WebSphere Transformation Extender.
    I am having trouble using DBQUERY function to call a DB2 stored procedure which takes a bunch of input paramters and returns a cursor/resultset as output in a Map rule.

    I do not find a way of handling cursor/resultset in WTX.

    Following is my rule:

    DBQUERY( "CALL IRMSP367('25', 123456789, 'ABC', 'XYZ', ?,?)", "-DBTYPE DB2 -CONNECT DTXX -USER XXXXXX -PASSWORD xxxxxx -TRACE " )

    I can only capture 2 out parameters from the above call. But I am really interested in the cursor which has multiple columns and rows.

    Can some one please shed some light on how to do this?
    I appreciate your help

    Thanks
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: DB2 Stored Procedure Call retuning cursor

    Posted 09/07/07 03:16 PM

    Originally posted by: SystemAdmin


    Hi,

    I am still having this issue.
    Any one has ideas?

    Thx
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: DB2 Stored Procedure Call retuning cursor

    Posted 09/10/07 10:08 AM

    Originally posted by: janhess


    You can only get the values the procedure returns.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 4.  Re: DB2 Stored Procedure Call retuning cursor

    Posted 09/10/07 10:12 AM

    Originally posted by: janhess


    Ignore last reply. Your problem is that dbquery just returns a string with the values separated by a delimiter. You can call another map passing the parameters to run the procedure in the input card. If you gave generated the type tree from the procedure, you use this in the input card. That will give you access to all the returned values. Procedss this in the run map.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 5.  Re: DB2 Stored Procedure Call retuning cursor

    Posted 07/02/10 08:33 AM

    Originally posted by: debi


    Can you provide more details on how to get the result set from the DB2 stored proc? I've tried in an output card using DBQuery (just like the original post), using GET. I also tried calling the stored proc from the input card as suggested. No matter what I do, I can only get the output parameters, but the data I need is in the result set. I'm not very familiar with DB2 stored procedures so I don't know if it actually returns the result set?

    I'm using WTX 8.2.0.4. Thanks.
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender


Related Content