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....
problem with compare stage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
problem with compare stage
Devendra,Bangalore,India
Re: problem with compare stage
search for the error.
DS User
DS User
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 26
- Joined: Thu Aug 12, 2010 12:07 am
Re: problem with compare stage
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
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
-
- Participant
- Posts: 31
- Joined: Tue May 24, 2011 12:16 am
Re: problem with compare stage
Hi peddakkagari,
i am not getting output results but virtual data showing records. in output dataset have no columns .
i am not getting output results but virtual data showing records. in output dataset have no columns .
Devendra,Bangalore,India