Rows are getting dropped when stage variable condition fails

sreddy666 · Post by **sreddy666** » Thu May 31, 2012 1:48 pm

Hi Friends,

In DataStage 8.5 server jobs,

1> when stage variable condition is falling, rows are getting dropped insteand of going to reject link (which is connect to DRS stage, database sql server).

if i remove DRS stage and place sequential file, then rows are going to reject link.

Thanks in advance..

chulett · Post by **chulett** » Thu May 31, 2012 3:19 pm

When you say "when stage variable condition is falling" do you actually mean "when the constraint expression evaluates to false"?

rameshrr3 · Post by **rameshrr3** » Thu May 31, 2012 3:43 pm

Can you set link ordering to execute the reject link first ?
You may need to change the stage variable or apply a NOT on it and use that to direct the reject link constraint. I 've faced this row drop due to link ordering . Something feels like a bug

ray.wurlod · Post by **ray.wurlod** » Thu May 31, 2012 4:31 pm

Clearly the database to which the DRS stage connects is not accepting the reject rows for some reason. Take a look at the data in the text file to see what the problem is.

sreddy666 · Post by **sreddy666** » Fri Jun 01, 2012 1:15 am

Thank you all..

Issue got resolved, data is not accepting into table.