Dataset dose not exist

thumati.praveen · Post by **thumati.praveen** » Sun Mar 25, 2007 7:23 am

Hi,

I am using in my job 4 datasets and funneling the 4 datasets and loading into database.Here the problem is if any of the dataset is not present the job is getting aboted...

Above 4 datasets were created by 4 different jobs.The problem is some of the jobs processing zero records.

If any of the above 4 datasets not present my database load job not get aborted...any idea

Thanks inadvance,
Pravin.

ray.wurlod · Post by **ray.wurlod** » Sun Mar 25, 2007 8:17 am

It is not possible, it seems, to create a Data Set with zero records. Add a dummy row to each, and ignore it when processing. Submit an enhancement request to IBM, through here or through your support provider.

thumati.praveen · Post by **thumati.praveen** » Mon Mar 26, 2007 12:52 am

ray.wurlod wrote:It is not possible, it seems, to create a Data Set with zero records. Add a dummy row to each, and ignore it when processing. Submit an enhancement request to IBM, through here or through your suppo ...

If i create the dummy record for each dataset every time it will append in the target database.That means it will create duplicates in target,but duplicate records not allowed in my target table the job wil automatically abort.Bcoz i am not using any transformer in between datasets and database stage.

Kindregards,
Pravin

Sreedhar · Post by **Sreedhar** » Mon Mar 26, 2007 2:51 am

Use a before job subroutine and concatenate all the 4 files into one, and use the this file as an input to the job.

In the after job subroutine delete the data set the is temporarily created.

Even one data set does not exist this will not create any prob.