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.  Stored proc returning 2 values with DBLOOKUP

    Posted 01/31/05 09:34 PM

    Originally posted by: SystemAdmin


    Is it possible for a stored procedure to return multiple values when using a DBLOOKUP?
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Stored proc returning 2 values with DBLOOKUP

    Posted 02/01/05 12:24 AM

    Originally posted by: SystemAdmin


    Yes it is.
    = dblookup( call MyProc ( inputarg1, ?, ?)

    This would return 2 values delimted by | character. Use WORD function then to split them.

    More detail in the Database Interface Designer manual 1008.pdf in the chapter on stored procs, it gives a break down of the syntax.

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


Related Content