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.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Using WmFlatFile to parse delimited records with no ID

  • 1.  Using WmFlatFile to parse delimited records with no ID

    Posted Wed January 17, 2007 05:11 AM

    Greetings All,

    This is probably an FAQ, but I can’t find references to the topic easily it seems.

    We have a flat file of delimited records with no record identifiers. I am looking or pointers on how to use WmFlatFile to parse this sort of data.

    I have seen reference to property, but I can’t find any evidence of the existence of this anywhere despite looking hard. Also, I cannot for the life of me find the property and so on.

    The point is that I don’t know how to set up the flat file schema to deal with this simple case.

    I imagine this is a very frequently encountered task. The standard documentation does not seem helpful in this area. Anybody with more experience than me able to set us straight?

    Using IS 6.5.

    Thanks in advance for any assistance.

    cheerio
    Andrew


    #Integration-Server-and-ESB
    #webMethods
    #Adapters-and-E-Standards


  • 2.  RE: Using WmFlatFile to parse delimited records with no ID

    Posted Wed January 17, 2007 08:45 PM

    [url]wmusers.com

    Yes, you won’t find the mention of recordWithNoId in any of the Flat File Adapter documentation but it is mentioned in the EDI BIS Reference doc and is discussed very often on wMUsers.


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB


  • 3.  RE: Using WmFlatFile to parse delimited records with no ID

    Posted Sat February 24, 2007 10:29 PM

    Hi,

    The steps getiing data from flat file

    1. open the flatfile

    2. read the record upto what you mentioned special charactor

    3. prepare Doc type which you need get from flat fine or which u need store in database table

    4. Specify in doc each feild wt is starting postion wt is ending position

    5. insert the database up to end of the record


    #Adapters-and-E-Standards
    #Integration-Server-and-ESB
    #webMethods