Skip Empty MLoads in Sequencer

RRourke · Post by **RRourke** » Thu Mar 13, 2003 3:03 pm

Hi,

Is there a simple(?) way of skipping Mload jobs in a sequencer if the input file is empty?

vmcburney · Post by **vmcburney** » Thu Mar 13, 2003 4:56 pm

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