Requirement is :-
- there will be daily monthly and on demad flat files coming in SourceDir folder in unix.
I want that if daily files are copied in the folder then my script shd check that if files are copied and are correct then process to load files trigger otherwise send a mail to support team with proper msg.
eg 2 flat files and 1 contrl file needs to be copied at loaction SorceDir for daily load.
flat files will contain data and named like ZIP_ORG_UNIT_YYYYMMDD.TXT and INDIVIDUAL_ORG_UNIT_YYYYMMDD.TXT and 1 control file which contains both the flat file names and count like:-
Daily_Cotrol_File_YYYYMMDD.cntrl
it has data like :-
FileNames Count
ZIP_ORG_UNIT_YYYYMMDD.TXT 2000
INDIVIDUAL_ORG_UNIT_YYYYMMDD.TXT 40000
So in unix script i want to check:
if file ZIP_ORG_UNIT_YYYYMMDD.TXT exists in SourceDir then
echo "file ZIP exist ">> $logfile
else send email to source team that ZIP_TO_ORG file has not reached today please send the file.
if file INDIVIDUAL_ORG_UNIT_YYYYMMDD.TXT exists in SourceDir then
echo " file individual exists">> $logfile
else send email to source team that INDIVIDUAL_ORG_UNIT file has not reached.
if Daily_Cotrol_File_YYYYMMDD.cntrl exists in SourceDir then
echo "Contol file exists"
else send email that contrl file is not reached.
if all the 3 files are copied then check in script that:-
wc-l of ZIP_ORG_UNIT_YYYYMMDD.TXT is equal to 2000 mentioned in the control file.
also
wc -l of INDIVIDUAL_ORG_UNIT_YYYYMMDD.TXT is eqal to 40000 in the control file.
if wc-l in file not equal to control file count then send email to support team with proper file name that for this file count does not match in control file.d
all these scenarios shd also work when there are multiples control files and multiple data files in SrcFolder if data is not loaded from 2-3 days . we can have multiple control files and multiple data files.