Page 1 of 1
Skip Empty MLoads in Sequencer
Posted: Thu Mar 13, 2003 3:03 pm
by RRourke
Hi,
Is there a simple(?) way of skipping Mload jobs in a sequencer if the input file is empty?
Posted: Thu Mar 13, 2003 4:56 pm
by vmcburney
You could write a DataStage routine that receives a file name and location which checks the size of that file. The routine returns true or false depending on whether the file is empty. In the sequence job you would use a routine stage to run the routine and use triggers to either run the job for a populated file or move to the next stage for an empty file.
Vincent McBurney
Data Integration Services
www.intramatix.com