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.  RUN function and returning FAIL function

    Posted 04/27/04 01:05 AM

    Originally posted by: SystemAdmin


    I have a map A where is used RUN-function calling map B.
    RUN("B","-WM -AE -TI " + ECHOIN(1,input))

    In map B is five output cards and everyone is using FAIL-function with error message, like FAIL("error 1").

    Now I want to get that FAIL-function error message returned when using RUN-function. It is possible? Now its returning errorcode 30 (FAIL function aborted map). I cant use -OE because I dont know which one of carda gonna fail.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 2.  Re: RUN function and returning FAIL function

    Posted 04/27/04 05:03 AM

    Originally posted by: SystemAdmin


    I am assuming that your map "B" is using a put command, run command, or DBLOOKUP in all of it's 5 output cards.
    Why not have the output cards be overridden from map "A" and then echo the audit log back to map "A" so you can find out exactly what happened?
    RUN("B","-wm -aem -f -ti "ECHOIN(1,input)" -of1 'c:\mercator6.7\results.txt' -od2 '-dt oracle -c testdb -us user -pw password -tb usertable' -oaftp3 '-url ftp://user:password@ftpsite.com/directory/resultingfile.txt' ...)

    This way you can tell exactly what is happening (and when it is happening) in your map. I have set up all of our logging this way, so map "A"'s output has the audit log of what map "B" did so if I need to go back it will keep it all organized.

    If you are creating a log of events that map "A" does, and it is in XML format, then a warning. Using -aecpm is not XML compliant, if memory serves me correct, the 'p' creates invalid XML.
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender
    #DataExchange


  • 3.  Re: RUN function and returning FAIL function

    Posted 04/27/04 05:20 AM

    Originally posted by: SystemAdmin


    Actually, I don't believe it's necessary to override the output cards to get the audit log back to the calling map. All you should need to do is include the 'm' (memory) command;e.g. "-AEM"

    I don't think you'll be too happy with the "-OE6" approach. If the FAIL function executes, I believe the map stops running at that point and output card 6 will never be reached.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender


  • 4.  Re: RUN function and returning FAIL function

    Posted 04/27/04 05:24 AM

    Originally posted by: SystemAdmin


    Ah. In rereading Tarun's post, I see now that he was suggesting you not use the FAIl function in cards 1-5, so hsi approach would also work.
    #IBMSterlingTransformationExtender
    #DataExchange
    #IBM-Websphere-Transformation-Extender