Join error

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Join error

Post by dnat »

Hi ,

I am getting the following error

Join_227: Error when checking operator: Key field "DEST_LOC_I" was not found in the view-adapted input schema

I have searched the forum and checked the nullability of input and reference in the Join stage. Both are same

There are many join stages before this join stage and when i remove just this join stage, then the error goes off.

I added this again freshly and checked for nullbility, datatype etc..everything looks fine..

There is no input data coming to this join stage so i cannot compare the data, but still this job aborts.

Can anyone help..
dnat
Participant
Posts: 200
Joined: Thu Sep 06, 2007 2:06 am

Post by dnat »

Moving it to parallel forum
Post Reply