File Exists in Directory

edward_m · Post by **edward_m** » Wed Mar 14, 2007 12:10 pm

All,

I want to run the job if the source file exists in directory..if not i want to send an email notifiation to users says source file not exists..
How to check whether file exists in directory..if so run the job else email notification.I am calling this job in sequencer.
Please throw some light on this..
Thanks in advance..

ganesh123 · Post by **ganesh123** » Wed Mar 14, 2007 12:19 pm

Is the sorce filename same all the time ?

narasimha · Post by **narasimha** » Wed Mar 14, 2007 12:22 pm

Check if you can use Wait_For_File_Activity in your sequence.

ganesh123 · Post by **ganesh123** » Wed Mar 14, 2007 12:22 pm

If its same hardcore it in parameter in job properties and then select the before jobsubroutine "DSwaitfofile".

Add this job in seqencer with Email notificaiton activity.

edward_m · Post by **edward_m** » Wed Mar 14, 2007 12:24 pm

No..The file lands in directory with filename+date ..in before job subroutine i am converting that to fixed name and pass it to job.

Thanks in advance..

ganesh123 · Post by **ganesh123** » Wed Mar 14, 2007 12:32 pm

Ok then I guess you should do everything in Shell script itself.
first check the filename if it exists continue else send email.

edward_m · Post by **edward_m** » Wed Mar 14, 2007 12:42 pm

As i mentioned my DS is on Windows..Is there any code in DOS to check the file exists in directory or not..

Thanks in advance..

ganesh123 · Post by **ganesh123** » Wed Mar 14, 2007 12:42 pm

something like

Code: Select all


x=filename
a=$x + `date`.txt
b=ls -l

if [$a -eq $b];
then 
continue
else
UtilitytoAbort("File does not exist")
fi

use this job with email notification activitiy in a seq

ganesh123 · Post by **ganesh123** » Wed Mar 14, 2007 12:51 pm

Sorry my bad. Something like this but check before doing as I am not sure:

Code: Select all


IF EXITS FILENAME
continue
else
UtilitytoAbort("No File")

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 12:53 pm

Write a routine that tries to rename the file. If the file is not there (rename was unsuccessful) and returns a non zero return code. If its there, it returns 0 as return code. Call this routine in routine activity in a sequence job and check for its return code. If 0, run the job else send out email using Notification Activity.

edward_m · Post by **edward_m** » Wed Mar 14, 2007 1:02 pm

Thanks DSGuru..Could you please throw the code for this routine..

Thanks in advance..

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 1:21 pm

How are you currently renaming the file? Just pass that command in DSExecute() in a routine and check the ReturnCode and pass it back.

edward_m · Post by **edward_m** » Wed Mar 14, 2007 1:57 pm

DSGuru,

I tried with the following code in the routine its giving error

Code: Select all

Call DSEXECUTE("DOS","copy E:\*.*/a E:srcpos.txt/a",output,SystemReturnCode)
Ans = SystemReturnCode

.

Please advise..

DSguru2B · Post by **DSguru2B** » Wed Mar 14, 2007 2:02 pm

Replace DOS with NT.

edward_m · Post by **edward_m** » Wed Mar 14, 2007 2:08 pm

I did..when i test the output says <<ERROR>>

Program "DSU.FileExists": Line 2, Unable to open the operating system file "DSU_BP.O/DSEXECUTE".
[ENOENT] No such file or directory
Program "DSU.FileExists": Line 2, Unable to load file "DSEXECUTE".
Program "DSU.FileExists": Line 2, Unable to load subroutine.

Thanks in advance..