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.  Fix File Output Format

    Posted 08/12/05 02:25 PM

    Originally posted by: SystemAdmin


    Good afternoon.

    Can someone help me with this issue? I am creating a fix file output, with no delimiters and my pad settings are not working properly. For example. I have a few components that the rule in the map is equal to NONE. In the type tree I have set the components to Fixed Size, min 0 and max 10, pad = yes, and value = <SP>. Why does my output not have 10 spaces? What part am I missing in this setup? If someone could help me with this I would truly appreciate it.

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


  • 2.  Re: Fix File Output Format

    Posted 08/13/05 04:26 AM

    Originally posted by: SystemAdmin


    The Apply pad setting defaults to Fixed Group when importing COBOL copybooks while most Groups default to Group Subclass->Format->Implied. If the Group is not Fixed, the pads are not applied. Setting Apply pad to Any context will apply the pads unconditionally at the field level. Alternately, changing the Group properties to Group Subclass->Format=Explicit and Group Subclass->Format->Component Syntax=Fixed should take care of the issue.
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender
    #DataExchange


  • 3.  Re: Fix File Output Format

    Posted 08/15/05 01:05 AM

    Originally posted by: SystemAdmin


    Mary

    Out of interest could you not just set the minimum length to 10 (and keep your other settings as they are). This should work as you are telling the map to force this field to always be 10 characters long.

    regards

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


  • 4.  Re: Fix File Output Format

    Posted 08/15/05 05:24 AM

    Originally posted by: SystemAdmin


    I think this was said before in a different way. Try the "Padded To" option as "Fixed Size" and specificy 10 in the Length.

    Padding will only pad to the minimum of the field length (0 in your case) if "Padded To" is not set.

    This might work for you.
    #IBM-Websphere-Transformation-Extender
    #DataExchange
    #IBMSterlingTransformationExtender


  • 5.  Re: Fix File Output Format

    Posted 08/15/05 08:53 AM

    Originally posted by: SystemAdmin


    To all,

    Wow, this is so awesome to have such a great group of individuals replying back to my e-mail. It was my mistake on my part. Also, Stephanie from IBM has replied as well to help me on this. It was a range setting that I had setup incorrectly. I did have it setup correctly before but I saw two lines as the results, but it was correct, there was no <CR><LF> in the file, notepad just displayed it incorrectly. Again, I appreciate everyone's reply. Have a great day and week.

    Sincerely,
    Mary
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender