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.  Difference between DBQuery & DBLookup

    Posted 05/11/07 05:32 PM

    Originally posted by: SystemAdmin


    What is the difference between DBQuery & DBLookup ? Why would we want to use one versus the other ?
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: Difference between DBQuery & DBLookup

    Posted 05/14/07 04:14 AM

    Originally posted by: janhess


    DBQUERY has a <CR><LF> at the end of the returned data. DBLOOKUP dous not.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 3.  Re: Difference between DBQuery & DBLookup

    Posted 05/14/07 04:29 AM

    Originally posted by: SystemAdmin


    DBQUERY is useful when your select returns multiple records (all rows will end in <CR><LF>).

    But if your select will return only one row, use DBLOOKUP (if you use DBLOOKUP to return multiple rows, they will all end in <CR><LF> apart from the last one).

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


Related Content