DSXchange

Hi friends,

I am facing with compare stage.

i have two sequential files with same fields and also same rows but iam facing below fetal error.

main_program: Fatal Error: Attempt to drop schema variable: "first.rec"; this may be due to dropping a subrec which contains a schema variable; this operation is not currently supported; to work around this limitation, insert a copy operator between the modify and the upstream operator.

Please give solution for this....

search for the error.

DS User

Insert a Copy stage as the message indicates. This is a known issue and you have been given the workaround.

Mr Devendra,

This is very simple.

Don't add any columns to the compare stage output page and Enable Runtime column propagation, then datastage itself will decide the column names and insert the data into your target file.

Your target columns will be Result+first file columns+second file columns

Data in the result will be zero(0) if the two records are same from the source files.


Please let me know still if you are not getting the desired result.

Thanks,
Sreekanth

Hi peddakkagari,

i am not getting output results but virtual data showing records. in output dataset have no columns .