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.  POWER Function

    Posted 12/21/09 01:27 AM

    Originally posted by: SystemAdmin


    I have one requirement to implement the logic of 10 to the power of 9.so i have used the power function as below
    POWER(10,9)...but its not working..Map designer gives me the following error during compilation.

    "Rule references unknown map: POWER."

    one more thing if a function is valid then its color turns to blue in the mapping rule but its color remain in red.

    Please suggest how to use power fucntion.

    Thanks and Regards
    Santanu
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 2.  Re: POWER Function

    Posted 12/21/09 08:09 AM

    Originally posted by: NancyR


    I don't believe there is a WTX function named POWER. Since it's not a WTX function, it's being interpreted as a functional map call which is why you're getting the error "Rule references unknown map: POWER.". It's also why "POWER" is not turning to blue in your rule - it's not a WTX function.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: POWER Function

    Posted 12/21/09 09:38 AM

    Originally posted by: thorstenhirsch


    Yes, there is a POWER function in wtx since 8.1. But it's not one of the core functions. It's a mathlib function, so you've got a slightly different call:

    mathlib->POWER( 10, 9 )
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 4.  Re: POWER Function

    Posted 12/21/09 07:39 PM

    Originally posted by: SystemAdmin


    The online documentation indicates that POWER is a standard function in 8.1. However, the POWER function doesn't work as a standard map rule function. It does work as Thorsten points out if you precede it with "mathlib->" as in =mathlib->POWER(10, 2).

    Now where is that documented? I don't find any documentation on Resourcelib or Xmlib either. I thought I was a WTX expert but I missed these new features. I thought they were something to be used with the development kit. Thanks.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 5.  Re: POWER Function

    Posted 12/21/09 07:49 PM

    Originally posted by: Rich_McFate


    I don't know about 8.1, but I see them in the 8.2 Functions and Expressions Guide (1006.pdf). It isn't clear, however, how you get to them. You have to think to look in the index to see them listed as mathlib, xmllib, and resourcelib functions, but I don't see anything elsewhere in the doc that tells you where to find them.

    I agree it's a bit odd.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 6.  Re: POWER Function

    Posted 12/21/09 07:58 PM

    Originally posted by: SystemAdmin


    Or how to use them! They do appear in the documentation as standard map rule functions when they apparently require the *lib-> prefixes.
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 7.  Re: POWER Function

    Posted 12/22/09 03:07 AM

    Originally posted by: Kepa_Screen


    I'm going crazy with this as I also thought I was a WTX expert...!
    I didn't know anything about this 'new features?'...Using WTX 8.1.0.3, but could not find nothing about this at 8.1 documentation.

    Personally would like to migrate to 8.3 but it's something difficult at my enterprese, they don't like changes too much. "It it's working, don't touch it" it's a recurrent "maximal" here.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender