Checking file existence in DOS!!!!!!!!

[Nithya]

we are working on conversion of foxpro table data to oracle through a text file.we are through with it.we need to automate the process.at the command prompt,we tried to automate by creating a batch file.we have to check the existence of the text file used during conversion.can anyone help us out on checking the file existence in DOS.
thanks in advance
nithya

 

[sem]

if exist <filename> <your command>

 

[THoey]

Here is a script that I use:

echo _____________________________   >>"\\D740015\FTP\Scripts\Logs\agent.txt"
Date /T  >"\\D740015\FTP\Scripts\Logs\agent.txt"
Time /T  >>"\\D740015\FTP\Scripts\Logs\agent.txt"
del /Q "\\D740015\FTP\Reports\agent.txt"
if exist "\\D740000\Public\Force Mngmt\Reports\Agent Report\Mike's Reports2.prn" goto FileFound
goto FileNotFound
:FileFound
echo File Found!  >>"\\D740015\FTP\Scripts\Logs\agent.txt" 
"\\D740015\D$\Program Files\Monarch\program\monarch.exe" "\\D740000\Public\Force Mngmt\Reports\Agent Report\Mike's Reports2.prn" "\\D740015\FTP\Scripts\agent.mod" "\\D740015\FTP\Reports\agent.txt" /T
del /Q "\\D740000\Public\Force Mngmt\Reports\Agent Report\Mike's Reports2.prn"
echo File processing completed at: >> "\\D740015\FTP\Scripts\Logs\agent.txt"
Date /T >>"\\D740015\FTP\Scripts\Logs\agent.txt"
Time /T >>"\\D740015\FTP\Scripts\Logs\agent.txt"
goto end
:FileNotFound
echo File Not Found!  >>"\\D740015\FTP\Scripts\Logs\agent.txt"
:end

Terry M. Hoey

Please read the following FAQ to learn how to help me help you...

faq183-874