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

flat file first record removal

  • 1.  flat file first record removal

    Posted Mon December 21, 2009 07:27 AM

    Hi ,
    I am having a problem in processing flatfiles.
    The first record of my first file is the column names
    eg
    sno|sname|dept
    1|John|IT
    2|Alex|Mech
    i am using convertToValues which gives me a document list which i am passing to a batch insert jdbc adapter service.
    Problem is I am getting columns also in the document list as first record.
    currently i am handling it using coding
    I dont want this . Is there any want to handle it in flat file schema itself


    #Flow-and-Java-services
    #Integration-Server-and-ESB
    #webMethods


  • 2.  RE: flat file first record removal

    Posted Mon December 21, 2009 02:13 PM

    just declar the header line a record itself and don’t map it. As column headers typically are constant recognition shouldn’t be a problem.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB