Missing dataset file

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
pk7
Participant
Posts: 44
Joined: Fri Aug 03, 2007 8:35 am
Location: Kansas CIty

Missing dataset file

Post 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!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post 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.
-craig

"You can never have too many knives" -- Logan Nine Fingers
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post 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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Re: Missing dataset file

Post 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?
-craig

"You can never have too many knives" -- Logan Nine Fingers
aebdw
Premium Member
Premium Member
Posts: 3
Joined: Mon Dec 02, 2013 4:32 pm

Post 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!
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Good to know, thanks. :wink:
-craig

"You can never have too many knives" -- Logan Nine Fingers
Post Reply