Page 1 of 1

Missing dataset file

Posted: Wed Jan 22, 2014 5:29 pm
by pk7
I have a DS job which has 4 different dataset files as inputs. If one of those files happens to be missing one day (it could happen) then the job blows up. Is there any way to simply ignore the non-existence of the file and continue processing with the others? I know that with Sequential files there is such an option but I can find nothing like that for dataset files.

Thanks in advance for your help!

Posted: Wed Jan 22, 2014 5:38 pm
by chulett
I'm not aware of an option of that nature for datasets nor for sequential files. If they're not there when called for as a source, job go boom.

Posted: Wed Jan 22, 2014 5:45 pm
by ray.wurlod
Only by checking prior to starting the job, for example using Execute Command activities in the controlling sequence. There is absolutely no way to require a job to ignore a missing Data Set. The sequence-based approach would have to direct control to one of a number of jobs that handle different combinations of existing Data Sets. Not pretty.

Re: Missing dataset file

Posted: Wed Jan 22, 2014 10:07 pm
by chulett
What about this assertion:
pk7 wrote:I know that with Sequential files there is such an option
Is that some new functionality I haven't seen mentioned before?

Posted: Thu Jan 23, 2014 10:49 am
by aebdw
Thanks for taking a shot at this guys.

Regarding sequential files having a "missing file" option, check in the Output tab and then Properties. It is the "Missing File Mode" option. Works slick!

Posted: Thu Jan 23, 2014 11:46 am
by chulett
Good to know, thanks. :wink: