IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only
Expand all | Collapse all

Identifying records with substrings in rec name

  • 1.  Identifying records with substrings in rec name

    Posted Thu October 06, 2005 03:22 PM

    I have a flat file with following data.


    COM data data
    COMPdata

    so I created record definitions for COM adn COMP at same level, when i tetsed the data file against the schema in devleoper I dont get the expected result I should be getting COM and COMP records at the smae level. what i get is COMP as child of COM.

    Can anyone please suggest the remedy.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 03:38 PM

    PD,
    what is the record delimiter you set and coming in the flatfile…see if delimiter is creating problem when parsing…Unless you keep COMP under COM record it does not show you as a child of COM.

    HTHm
    RMG


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 3.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 04:04 PM

    new line is set as record deliminator. And new line as deliinator is working fine with other records. Am i missing t oset some other record property?


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 4.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 04:39 PM

    Is it fixed length?and what is the field delimiter?


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 5.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 04:53 PM

    fields are space deliminated.


    #edi
    #Integration-Server-and-ESB
    #webMethods


  • 6.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 06:03 PM

    Infact the problem arise in the file with the folowing pattern

    COM
    COMP
    COM

    The parser really gets lost and confused.


    #Integration-Server-and-ESB
    #webMethods
    #edi


  • 7.  RE: Identifying records with substrings in rec name

    Posted Thu October 06, 2005 08:48 PM

    If so in your flatfile schema create COM recorddefinition(set maxRepeat=Unlimited) and create COMP recorddefinition as child of COM,so that your flatfile will parse as a trick.

    HTH,
    RMG


    #webMethods
    #edi
    #Integration-Server-and-ESB


  • 8.  RE: Identifying records with substrings in rec name

    Posted Mon October 10, 2005 05:32 PM

    No RMG it could not be soleved this way, I have to do a work around for identifying each section uniquely because the COMP section occurs anywhere in the messsage (it does not always appear below COM) so I cannot design it to be the child of COMP. But for time being the work around is working fine for me, lets see how it goes ahead. Let me know if you have some other suggestion.


    #edi
    #webMethods
    #Integration-Server-and-ESB


  • 9.  RE: Identifying records with substrings in rec name

    Posted Mon October 10, 2005 07:43 PM

    OK,i will let you know if any clue…

    sometimes weird tweaks can help…

    Thanks for update…


    #webMethods
    #edi
    #Integration-Server-and-ESB