Page 1 of 1

Compare 2 datasets- probelm

Posted: Thu Aug 16, 2007 11:39 am
by chandra
I want to compare the out put of the 2 datasets if they mismatch i want to abort the seq.
this is the error i got when i was trying to compare
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.

Posted: Thu Aug 16, 2007 4:01 pm
by ray.wurlod
Can you please elaborate on how you are attempting to compare two datasets using DataStage TX?