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.  GETRESOURCEALIAS function

    Posted 08/30/07 01:27 PM

    Originally posted by: SystemAdmin


    Not sure if anyone managed to use the new function 'GETRESOURCEALIAS' in WTX 8.1.0.2?
    Documentation was not clear at all what the parameters should be. Is this slower compared to reading from a cofig text file?
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: GETRESOURCEALIAS function

    Posted 08/30/07 01:58 PM

    Originally posted by: john.gibby


    I had some dealings with it for a short time while evaluating early in the 8.x cycle. I was unhappy with it at the time, because they were wanting you to provide the MRN file the alias was located in. I felt that was tedious for the developer. They came back to me and asked how I felt it should be implemented. I said I felt like I should only have to supply the Resource Alias name. The engine should be smart enough to resolve it. When I use a Resource Alias in the card settings or in a Get/Put function, it doesn't ask me for which MRN it is in. If I recall correctly, I never got any feedback after that and I never got back to it.

    I decided to just write my own "resolver" map for the MRN files. I wrote my own DTD (which I can no longer find) and imported it to create a Type Tree. We have several [i]map sub-systems[/i] (as we call it) and each has its own MRN file. So I wrote a map that resolves the MRN file into a simple text file for each system. The file format is a simple Name/Value hash table format:
    codeAliasName1=AliasValue1
    AliasName2=AliasValue2[/code]
    This way I can use the following formula code to get the value of any alias for the current environment:
    codeWORD(WORD(RRLookup,"ALIASNAME1=",2),"<NL>",1)[/code]
    Originally, I created an output Type Tree with all the Alias Values, but it quickly became evident that whenever I added a new Resource Alias, I would have to modify this tree also and all of my maps, which I did not want in a CVS environment.

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