I'm using the bulk loader because of high data volumes. In the bulk loader I have the option to code a delete statement. The delete will delete any data loaded for a period and then re-load the data being pushed to it. This has been done to cater for re-runnability.
However, if no rows go down the link the delete statement is still invoked. It seems as though DataStage will invoke the bulk loader just because it is in the job.
I have tried the @INROWNUM, @OUTROWNUM in the constraint to no avail. Even did a lookup doing a "select count(*) etc" and put the linkname.numrows > 0 in the constraint. The bulk loader still gets invoked when the rows on the link are zero
![Confused :?](./images/smilies/icon_confused.gif)
Does anyone have a workaround/answer for this one?