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

Composite fields in FlatFile schema

  • 1.  Composite fields in FlatFile schema

    Posted Mon May 02, 2005 11:07 AM

    Hi,
    In our project we use GIS as the translator which we are trying to migrate to webMethods. We are facing a couple of problems in that,

    Consider the FF structure like,

    ENV|FIRST|SECOND|COMP_1|COMP_2|THIRD

    | - field and subfield delimiter.

    Where FIRST and THIRD are Fields and SECOND is a composite element and COMP_1 and COMP_2 are subfields under SECOND.

    1.In the flat file format used in our case the composite elements are defined like,

    ‘Subfield:Subfiled’

    '–> field delimiter
    : –> Subfield delimiter

    where as all the subfields are considered as data.

    In case of webMethods when i tried to do the same the first subfield is not considered as data(SECOND). Instead the data it assumes starting from subfield number 2(COMP_1). Can any one suggest me a way to come out of this.

    1. In some of the cases in a flatfile a delimiter was used both as a field delimiter and a subfiled delimiter. This was a acceptable scenario in GIS, but in WM I when i tried this i saw that the composite element was not taken for data at all,

    i,e in this FF the output was for the FIRST field and the COMP_1 only. The SECOND Field was not considered as a composite at all.

    Please help.


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


  • 2.  RE: Composite fields in FlatFile schema

    Posted Thu May 05, 2005 07:50 AM

    Hi All,
    I some how resolved the first problem in the fields getting populated.

    Can any one give a way to resolve the second issue.

    Thanks,
    Karthik


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