hi,

I am facing a major issue with Input Card validation.

See attached image of the type tree that is causing the issue.

The input card has three components

1. Header
2. NewValues
3. OldValues

The Components delimiter value is 'FS'

The field delimiter value within each component is 'RS'

The input card reads the header and the NewValues record correctly but fails to read the start of the OldValues record.

Below is the portion of the Trace where it fails.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

(Level 3: Offset 1700, len 4, comp 320 of 321, #1, DI 000000000088:)

Data at offset 1700 ('NULL') was found to be of TYPE

   X'015F' (valuation_d datetime_t datatype Audext_operation).

 

(Level 3: Offset 1705, len 10, comp 321 of 321, #1, DI 000000000088:)

Data at offset 1705 ('04/11/2025') was found to be of TYPE

   X'0160' (value_d datetime_t datatype Audext_operation).

 

(Level 2: Offset 95, len 1620, comp 2 of 3, #1, DI 000000000089:)

Data at offset 95 ('NULLRSNULLRSNULLRSN...') was found to be of TYPE

   X'0013' (NewValues Audext_operation).

 

(Level 2: Offset 1715, len 0, comp 3 of 3, #1, DI 00000000008A:)

Data at offset 1715 ('RSFSNULLRSNULLRSNULL...') does not match DELIMITER 'FS'

  of TYPE X'0003' (AuditRec Audext_operation).

 

(Level 2: Offset 1715, len 0, comp 3 of 3, #1, DI 00000000008A:)

Data at offset 1715 ('RSFSNULLRSNULLRSNULL') was found to be of TYPE

   X'0161' (OldValues Audext_operation).

 

(Level 1: Offset 1715, len 0, comp 1 of 1, #1, DI 00000000008A:)

Data at offset 1715 ('RSFSNULLRSNULLRSNULL...') does not match TERMINATOR '<LF>'

  of TYPE X'0003' (AuditRec Audext_operation).

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++

As you can see it is able to read correctly up to the last field 321 for the NewValues component.

But when it start to reads the next (OldValues) component it fails.

I can observe that it is not calculating the offset correct ( 1705 + 10 + 1 = 1716) for the next component. ( see highlighted text in yellow above)

Instead it fails to take into account the 'RS' character and calculates the wrong value ( 1705 + 10 = 1715) and fails to read the next component correctly.

appreciate your help with the above.

Thanks

#DataExchange
#IBM-Websphere-Transformation-Extender
#IBMSterlingTransformationExtender

------------------------------
joseph dmello
------------------------------