error in compare stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
ggs
Participant
Posts: 7
Joined: Mon Oct 01, 2007 7:14 am
Location: Hyderabad

error in compare stage

Post by ggs »

A job containing 2 input files ,1 output file and 1 compare stage.while running this job i am getting 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"

can any body help me regarding this?
Maveric
Participant
Posts: 388
Joined: Tue Mar 13, 2007 1:28 am

Post by Maveric »

Looks to me like you are doing an explicit conversion with RCP on. So it is dropping the original field due to field name conflict and asking you to drop it in a copy stage. Swith off RCP and try.
madhukar
Participant
Posts: 86
Joined: Fri May 20, 2005 4:05 pm

Re: error in compare stage

Post by madhukar »

Output file does not support vector records. try dataset and check
ggs
Participant
Posts: 7
Joined: Mon Oct 01, 2007 7:14 am
Location: Hyderabad

Post by ggs »

Thanks Madhukar,
here i am explaining my job in detail:

a)First Input: Sequential File :
Field 1
Field 2
Field 3

b)Second Input :Sequntial File :
Filed 1
Field 2
Field 3

c)Comapre Stage :

d)Output: Dataset

Field1 values are differring in both the input tables.
Here the output should contain the data in both the input files .

How can i go ahead?
Post Reply