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.  DBLOOKUP - Oracle query with % as argument

    Posted 02/27/19 09:01 AM

    Originally posted by: PSAK


    How to call a Oracle function with more than one argument using "%" ? When I run a DBLOOKUP as below, its treating arguments as resource registry? Any suggestion to call them with "%"?

    DBLOOKUP(" CALL ?= DB1.Func12("aaa,'test%',20180977',yyy%yy'),"-DT ORACLE -SOURCE DBNAME -USER admin -PASS pass -T trace.dbl)

     

     

     

     


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


  • 2.  Re: DBLOOKUP - Oracle query with % as argument

    Posted 03/01/19 12:42 PM

    Originally posted by: PaulBrett


    Yes, have a resource registry entry called 'percent', with a value of %percent%, then re-write your rule to:

    DBLOOKUP(" CALL ?= DB1.Func12("aaa,'test%',20180977',yyy%percent%yy'),"-DT ORACLE -SOURCE DBNAME -USER admin -PASS pass -T trace.dbl)

    Thank you.

    Paul

    Follow me on Twitter


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


Related Content