Originally posted by: jvanboga
Generated a type tree via DBID.... Works fine....
I then modified the tree. I added a new group called 'File', copied DBSelect to a two new groups called SUB_DEP and DEP respectively. I then modified the new groups so that the tree looks something like....
File
-SUB_DEP (S)
--Row {added component rule: RECORD_TYPE Column:$=10 }
--DEP
---Row (S) {added component rule: RECORD_TYPE Column:$=20 }
Terminators, separators etc are the same.... Added component rule.
If I validate against 'DBSelect' the everything works. If I validate against 'File' I get the msg 'Input valid but unknown data found'. The unknown data is always the last record extracted via query. Based on where the failure occurs it looks like it's something to do with terminators.
Trace file extract below (offset 1961 is start of last rec and 2176 is end, 2178 if you include the <NL>):
Level 3: Offset 2176, len 0, comp 55 of 55, #1, DI 0000022F:)
COMPONENT number 55 of TYPE X'0005' (Row select_mem_proc Data):
occurrence 1 is optional and has no content.
(Level 3: Offset 2176, len 0, comp 55 of 55, #1, DI 0000022F:)
Data at offset 2176 ('<CR><LF>') was found to be of TYPE
X'003D' (DEP_HANDICA_IND Column select_mem_proc Data).
(Level 2: Offset 1961, len 215, comp 1 of 2, #1, DI 00000230:)
Data at offset 1961 ('1477|10|55928|10') was found to be of TYPE
X'0005' (Row select_mem_proc Data).
(Level 2: Offset 2178, len 0, comp 2 of 2, #1, DI 00000231:)
COMPONENT number 2 of TYPE X'0004' (SUB_DEP select_mem_proc Data)
is required, but does not exist.
(Level 1: Offset 1961, len 0, comp 1 of 1, #7, DI 000001F9:)
COMPONENT number 1 of TYPE X'0003' (FILE select_mem_proc Data):
occurrence 7 is optional and does not exist.
(Level 0: Offset 0, len 1961, comp 1 of 0, #1, DI 000001F9:)
Data at offset 0 ('1477|10|55928|10') was found to be of TYPE
X'0003' (FILE select_mem_proc Data).
INPUT 1 was valid but contained 217 bytes of unknown data at the end.
End of Validation messages for INPUT CARD 1.
End of Execution messages.
#IBM-Websphere-Transformation-Extender#IBMSterlingTransformationExtender#DataExchange