Shell Programming and Scripting

We have a job which we need to run on daily bases, before loading data in a table we need to validate whether the input file is received or not.Inputfile formatsrc_sps_d_Call_Center_Reporting_yyyymmdd_01.dat SPS-Service nameYYYY-yearMM-MonthDD-dayLike above we will get n number of files for different services.SS_list.txt File contains data like below1)SPS2)OCWEN3)XYZ Ss_load_proc_day tableS_servicer_code Load_Date File_Recv_D1 File_Recv_D2SPS TUE MON FRISPS Wed Tue SPS Thu Wed SPS Fri Thu SS_Calendar tableS_Servicer_code Date No_File_Receive_Day ( etc) Month_EndSPS 3/29/20013 N YSPS 4/1/2003 Y NOCWEN 4/1/2003 N NXYZ 3/30/20013 N N1. Take one sub servicer vendor name from SS_List.txt and perform #2  #6Check ../SrcFiles , if file for this vendor available today  src_sps_d_Call_Center_Reporting_yyyymmdd_01.dat 2. If Yes, start from #13. Else , Check if load date(currentday) for this vendor is No_File_Receive_Day in SS_Calendar table4. If Yes, start from #15. If Not, Send File missing ALERT with file name.1. Take one sub servicer vendor name from SS_List.txt and perform #2  #42. append VendorName-Day ( viz ‘SPS-TUE'). Check SS_Procday.txt for any entry. If Not* start #13. If Yes, Get the days ( MON, FRI ); Check all the received files' Proc_Dates (embedded in file name) They should match. 4. If missing any, Send ALERT with file names. If the source file exist then it should update output file name as Yes else No

Please make you post legible or this thread will be closed...