Need to check if two files exist then only process?

ramakrishna459 · Post by **ramakrishna459** » Thu Aug 15, 2013 12:02 am

Hi All,

We have two similar groups are split into two xml files.But our datastage job should identify each time whether two xmls of similar group available then only process the records.if only single xml file of that group is available dont process.How to achieve this logic in datastage.

For example:we will have that xml files as fruits_I.xml and fruits_II.xml both belongs to group of '05'.

if only fruits_I.xml and fruits_II.xml are available then only datastage job should process the records to the file.

ArndW · Post by **ArndW** » Thu Aug 15, 2013 1:09 am

You need to use the "Wait for file" activity for both files in your job sequence.

Klaus Schaefer · Post by **Klaus Schaefer** » Thu Aug 15, 2013 2:01 am

Did you try "wait for file" event in job sequencer...?

Klaus

ray.wurlod · Post by **ray.wurlod** » Thu Aug 15, 2013 4:20 am

Two WaitForFile activities with OK triggers feeding into an "All" sequencer.

chulett · Post by **chulett** » Thu Aug 15, 2013 11:22 am

Hmmm... think I'm leaning towards suggesting two WFF stages in a Sequence for this.

ramakrishna459 · Post by **ramakrishna459** » Sun Oct 13, 2013 7:25 am

we have created unix shellscipt and worked out. Thanks to all

ray.wurlod · Post by **ray.wurlod** » Sun Oct 13, 2013 1:35 pm

Why not trade in your copy of DataStage for a UNIX shell script author?

DSXchange

Need to check if two files exist then only process?

Need to check if two files exist then only process?

Re: Need to check if two files exist then only process?