Search Results

In the above code i am getting an excel (xls) file in the error directory . I want to zip(Compress) that perticualr excel there. Kindly suggest how to go further.

I am getting an xls file in the dir errorpath. I would like to zip it. Kindly help me on this.

The code is as below.


sqllst=$errorpath/$run_pgm.${date_stamp}".xls" ...

i have N munbere of file in the format " abc.sequenceno.dat " wher sequenceno starts from 1 to say 100(N). i want files which contain
" 0004" in those files.Can anyone get me the grep...

can anyone help me on the working of the below statement.

Hi all,

Could anyone suggest me on Renaming a file to a file_current datetime in a shell script.

ok. that looks much simpler.

my subject is like ABCDEFGHIJ DATE(DD-MON-YY) Format.

its in a shell script which after execution ll mail to an mail id.

hmmm.. looks complicated...
i just want to print a date in my subject of a mail sent from the script.

Could anyone suggest me on how to write unix script for displaying yesterdays date ie. if today is 2nd Mar then when i run .sh script i should get displayed as "01-Mar-2010".

this is my original code.. which gives me excel attached zipped. i just want to add body to this code.

@Varu0612:



@Scottn:

auto_repconnect auto_sql auto_status 1>>auto_suc.xls 2>>auto_err
gzip -c auto_suc.xls | uuencode auto_suc.xml.gz |mailx -m -s "Subject" abc@xyz.com
this is inside a shell script(.sh) file
need to...

can i keep the code given by you inside a shell script ???

because i am exporting the excel file using one more sql query...all these command are there in a shell script

cat << ! | mailx ......
Message body goes here
$(gzip -c ASC.xls | uuencode ASC.xls.gz)
!



Hi could you please describe the above code whats the (!) in the code ?

echo "Hi All" >> cnt
echo "" >> cnt
echo "" >> cnt
cat cnt | gzip -c ASC.xls | uuencode .........

I am using the above format but i am getting attchment but not the body in the email"HI ALL".

Thanks Much!!!



Please suggest on how to write body for the email above.

Hi All,

Currently i am using below script to attach excel and email from a Unix script.
uuencode ASC.xls|mailx -m -s "ABCD_subject`TZ=CST+24 date +%d-%b-%y`" email@email.com

Can anyone give...