Please help me out with this new enhancment with this shell script which i have written below.
********************************************************
****************************************************
I need the following enhancement from this:
1) The duplicate records exist in file ven_clm_data_20100901449.csv If the input file contains any duplicate records, it should e-mail the user with the file name.
2) The total number of records in the file is 75 Should be able to count the total no. of records in the input file and e-mail the user
3) The duplicate count within the incoming file is 0. If there are no duplicate records, should e-mail the user. This should be done aftere reading the input file.
4) The total number of records loaded into the VEN_CLM table is 0. This is when there are duplicate records in the input file,, the user should get the message that no records are loaded as there are duplicate records in the file.
Please help me out with this, as this is very critical.
Regards Rahman...
Last edited by DukeNuke2; 10-19-2010 at 06:30 PM..
I tried the second point. It loads the data, and e-mails the log file to the user, but it does not e-mail the total no. of files loaded in the table to the user.
Instead it diplays the result on the background itself.
Here's the script that i added to the current script:
Can you please do the changes to the above script, which will e-mail the total records loaded into the table via e-mail to the user.
Thanks
---------- Post updated at 05:03 PM ---------- Previous update was at 04:11 PM ----------
Tried Point No.1.
Table loaded with data,, but the e-mail does not e-mail the user that the input file contains duplicate records in it.
You want the output of the echo and the uuencode to be sent to mailx, so put them in ( ) That way both commands run (1 after the other) and their combined output is piped on:
Thanks Chubler,
It worked. I am getting the output like this :
Message The total number of records in the file is: 143 !
along with the log file.
I am also trying to compare two files for any duplicate records in it. I used this command, but its not working. I need this script to compare two file of the same type,, but if any duplicate records in file B, then the user should be intimated by e-mail that the file B contains duplicate records.
The script that i am working is :
Please let me know how to compare two files and send an e-mail to the user if the file B contains any duplicate records in it.
Thanks,
Rahman
Last edited by Scott; 10-26-2010 at 06:07 PM..
Reason: Code tags, please...
Hi..
when i delete a Lun from a Array on a SAN, and again when i create a Lun it shows that the newly created Lun has the ID of the Old deleted Lun which is leading to data corruption. All this is handled by the Multipath software. can anybody help. (0 Replies)
We are searching for DEVICE MAPPER TABLE FORMAT and how to access it through user space??
We are working on enhancement in multipatrhing as 1] scalable path testing 2] event mechanism 3] i/o load sharing.
So we need to access device info as well as all paths to that device, devices status,paths... (1 Reply)