Hi all,
I am new to scripting. I want to automate things.
I get file named as NY.csv, CA.csv,FL.csv in folder /apps/data. Now these NY,CA and FL have existing data in two tables.
1. I want to retrieve the name NY first from the filename
run 2 queries:
delete * from TABLENAME1 where state='retrieved name from file i.e.(NY)';
commit;
delete * from TABLENAME2 where state='NY';
commit;
and load the new NY.csv via crontab ( i already have the crontab setup done) . then do the same for CA and then for FL.


Thanks in advance.

You should also consider that there may be PA.csv that should not be processed.
The entire process should be in your cron job.