IBM Sterling Transformation Extender

Sterling Transformation Extender

Come for answers, stay for best practices. All we're missing is you.

 View Only
Back to discussions
Expand all | Collapse all

Defining record initiator for flat file

  • 1.  Defining record initiator for flat file

    Posted Wed March 12, 2014 12:59 AM

    Originally posted by: SahanaNadig


    Hello,

    I have a flat file as input to WTX map with the record type defined as the 2nd field in each record and terminator being <CR><LF>.

    The first 13 bytes is field -1 and the next 2 bytes is field-2 which is the record type (01,15,16,17,18…)

    Each record type may loop 'n' number of times consecutively within the header record (header record has field-2 value as "01").

    For Example:

    00000000000000101HHCF022720131231            

    00000000000011501EC00020007      201311ZUCK  

    00000000000011601EC00020007      2008010199999

    00000000000011602EC00020007      2013050199999

    00000000000011701EC00020007      2008010120130

    00000000000011702EC00020007      2013050199999

    00000000000011801EC00020007      DUAL201401019

    00000000124911501EC00036661      201310CAS

    00000000124911601EC00036661      201310019

    00000000124911701EC00036661      201310019

    00000000124911801EC00036661      MDID20131

    00000000124911802EC00036661      MED 20131

    When I created the type tree I was able to set the terminator. However, I am confused with setting the initiator of the record.

    Any help on setting record initiator  in the above scenario will be very helpful.

    Thank you in advance,

     

    Regards,

    Sahana


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


  • 2.  Re: Defining record initiator for flat file

    Posted Thu March 13, 2014 08:36 AM

    Originally posted by: Laurent(Satisco)


    I'm afraid the answer is in the documentation, and you need to understand the type tree concepts to be able to do what you need.

    http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m1/index.jsp

     

    http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m1/topic/com.ibm.websphere.dtx.td.doc/concepts/c_type_design_Defining_Component_Rules.htm

    http://pic.dhe.ibm.com/infocenter/wtxdoc/v8r4m1/topic/com.ibm.websphere.dtx.td.doc/concepts/c_type_design_Identifier_Attribute.htm

     

    have, I think, all what you need to achieve your requirement


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


  • 3.  Re: Defining record initiator for flat file

    Posted Thu March 13, 2014 12:05 PM

    Originally posted by: SahanaNadig


    Thanks Laurent !!

     

    Declaring the field-2 as an identifier solved the issue.


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


Related Content