Skip to Content

key field problem

Hi all,

Suppose i have a field say value1 which is of length 1 char.

My file can come with this field being set as 'N' or 'Y'.

Now how do i specify a keyfieldvalue for the same?

Is there anyway i can say that the keyfieldvalue is 'Y' or 'N' ??

Regards,

ShabZ

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 12, 2005 at 02:39 PM

    Hi

    <i>I think u misunderstood the concept of Keyfieldvalue,

    this parameter is used when</i> you specify a variable number of substructures for recordsetStructure (at least one substructure with the number ‘*’ ), the substructures must be identified by the parser from their content. This means that a key field must be set with different constants for the different substructures.

    In this case, you must specify a key field and the field name must occur in all substructures.

    If a structure has a fixed number of substructures, this specification is ignored.

    so i suggest u go through this blog link where and how it is used

    <b>/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

    Hope it helps

    Regards

    Arpit Seth

    Add comment
    10|10000 characters needed characters exceeded

    • hi dhanna,

      but how will the adapter even read the file in such a condition?

      >>>>>>

      <i>suppose you have a file as follows,

      headA1,headA2

      fieldB1,fieldB2

      fieldB1,fieldB2

      fieldB1,fieldB2

      ......

      trailc1,trailc2

      now in my file headA1 may come with the value as AAA or at times it may come with BBB. As for other fields there is no problem involved.</i>

      >>>>>

      i guess that isn't a problem anymore.

      But if fieldB1 has the same problem wherein the value changes, and occurance is unbounded, we need to specify the keyfieldvalue (which may change according to the input file).

      I just want to confirm if this can be done thru the content conversion parameters.

      Regards,

      ShaBz