webMethods

webMethods

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
  • 1.  Repeating fields Flat File Schema

    Posted Mon April 19, 2004 11:02 PM

    Hi,

    Does webMethods allow the fields in a record, in a flat file schema to be repetitive. We have the following flat file structure. Can any body please suggest how to go about making a schema for it.

    Delimeters

    1. Record level, say, “;”
    2. Field level, say, “,”
    3. End of repeating field, say, “|”

    What the last delimeter means is that some of the fields may repeat a variable number of times. And the presense of the delimeter 3 would signify the end.

    This a typical flat file sample

    RecordIdentifierField1,Field2,Field2,Field2|Field3,Field4;RecordIdentifierField1,Field2,Field2|Field3,Field4;

    Appreciate your help.
    Vikas.


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


  • 2.  RE: Repeating fields Flat File Schema

    Posted Tue April 20, 2004 12:29 AM

    I don’t think it is possible.
    you have to define a field for each Field2. (This means that you should know maximum allowed number of instances of Field2)


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


  • 3.  RE: Repeating fields Flat File Schema

    Posted Tue April 20, 2004 04:48 AM

    I haven’t tried this but how about making the repeating field a record or composite record.
    That might work.

    HTH


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


  • 4.  RE: Repeating fields Flat File Schema

    Posted Tue April 20, 2004 06:43 PM

    When you are building composite or record you need to have the knowledge of their definition. You can set Max Repeat property of a record to unlimited, it will allow unlimited no. of records. However you cannot set max repeat property of a field or composite. Had wM allowed to do that it would have been possible to do what Vikas is asking.(it would be nice feature enhancement)


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