This is related to my previous post under the topic of "Promote Subrecord"
Input records are in different level numbers. when i pass it to transformer it shows me the same error.
##E TFAV 000000 02:19:11(001) <transform> When processing argument -inputschemaWhen processing schema: schema contains a field "CISSFTS_HEADER" that is a subrec or tagged; only top-level fields are accepted....
"CISSFTS_HEADER" is top level nuber record.
the structure would be
level no col name
10 CISSFTS_HEADER
05 xxxxx
05 yyyyy
10 zzzzzz
initially i deleted the CISSFTS_HEADER and changed the both 05 level records to level 10 and worked. But now the col CISSFTS_HEADER is required. it is tagged. CISSFTS_HEADER has the values of xxxxxx + yyyyyy contcatinated together. i.e., if i veiw data in the input stage the value of CISSFTS_HEADER alone comes with the value of (xxxxxx yyyyyy) .
Any inputs to this...
How are you reading this mainframe file into datastage?. I assume you are using an CFF stage. While intially reading the file into datastage, you need to read all the information ( Header + Detail). In the subsequent stages, you can use a transformer to pass whatever information you need in the job ( Header or Detail or Both), It depends on your job requirement.
hi naveen,
If the data comes in EBCDIC format then we use CFF stage for code conversion, else sequential stage works fine. Irrespective of stages transformer produces error.