From: Mondal, Subrata (SMondal@IMF.ORG)
Date: Tue Jun 18 2002 - 11:26:15 EDT
Hi Gurus:
1. I have already a scrpt which runs perfectly on my cron job
but I need a small tinkering. This is what my process does:
1. I get a flat file from an external source. The flat file
has a date.ext eg : 20020617.txt
2. My scrpt takes care of automatic ftp from their
site.
3. I bcp the flat file to my database - Mainly sybase
Ver 11.9
4. I run a stored procedure with the date as my parameter.
Now the tinkering in the scrpt :
Regularly I get a single file - My scrpt works fine
But I have cases when they do not send the file -
2 files comes in on teh same day
and there my problem starts. My scrpt at the databadse level taking the
date as parameters at the stored proc level does not work
How do I handle this scenerio - Can some one throw some lights on thelogic.
Subrata
This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:16:00 EDT