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.  Problem identifying record types

    Posted 08/19/10 08:56 AM

    Originally posted by: SystemAdmin


    Hi, everybody.

    I'm having some issues regarding an input file with multiple types of records. The input file is a text file, with fixed length attributes.

    I do know how to identify record types by the use of partitioned groups and initiators. However, what I need to do is a bit different.

    Rather than identifying records by its "n" first characters, I have to identify them by the last three characters of the second attribute. Let me clarify this with an example.

    
DHDR00ABC        AA CCC DHDR03DEF        44422211100055533                     331 DDET08GHI        4  DISTR


    The first two attributes are common for all record types:

    
RECID              CHAR(01)      , 
/* DI RECORD ID                        */ STRUCNAM       CHAR(16)      , 
/* DI STRUCTURE MAME                   */


    The last three characters of STRUCNAME identify the record type. For instance, first record is of ABC type, second is DEF, and third is GHI.

    Any ideas on how to implement this?

    Thanks a lot in advance,

    Martín
    #DataExchange
    #IBM-Websphere-Transformation-Extender
    #IBMSterlingTransformationExtender


  • 2.  Re: Problem identifying record types

    Posted 08/19/10 10:42 AM

    Originally posted by: TarunB


    Can you not use the whole of RECID + STRUCNAM as your Initiator/Identifier? So for example, DHDR00ABC would indicate a record type of ABC.

    Otherwise in your type tree implement a component rule on STRUCNAM such as RIGHT(TRIMRIGHT ($),3)="ABC" ... ad infinitum
    #DataExchange
    #IBMSterlingTransformationExtender
    #IBM-Websphere-Transformation-Extender