UNIX for Advanced & Expert Users

After you set your date from Oracle, try to show it like the following:

Code:

> dt_a="03-07-2008"
> echo ${dt_a}
03-07-2008
> echo ${dt_a} | od -An -t dC -w10
   48   51   45   48   55   45   50   48   48   56
   10

Those are the ASCII representations of the text. You can look up the ASCII table, but 48 is a "0" & 51 is a "3" & 45 is a "-" and so on. The 10 is a line-feed.

I am curious if there are some control characters like tab or carriage-return or something else that is somehow part of the string.

Hi all,

The value of week_end_date is coming properly. There is no problem in echoing that. The problem is that value is not displayed in the subject of the mail. On the contrary if I specify $week_end_date in the text part of the mail then it is displaying it properly. I am writing the code again with proper output. kindly check the same

the ouptut is


and the mail which i get has subject as shown below


Hope these things will help u all to understand now.

waiting for reply.

Thanks.

please reply asap!!!!

Are you reading reply to your questions?
Why you did not make what you have been asked?
People spend time to get your problem, try it, think about it, replay you, but you do not care, repeating the same and, even, 'asap'!
I am sure you have 'lf' in your data and if you would do what I asked you to do or, even better, apply the 'od' command as it was advised, you would see it.
I do not see a reason to spend time for this thread and it is my last post here.
You can continue just to do the same and repeat it again and again. Good lock!

(Sorry for off-top)

Alex,

For your kind information i have already tried your method i.e. ">${week_end_dt}<" to include in the subject. but its not working. I dont know why. probably it might be working for u. For the same reason i am repeating my code in this thread to get u all the better idea. Regarding the 'od' command i dint get time to check thru it. i was in hurry when i lastly posted.

By the way thanks for your precious time. I am really glad to have ur suggestions.

Hi all,

I got the solution to my question. Sometimes we think too complex solutions for the simple questions.
The subject just required to be assigned with echo command to get it displayed in the mail.

Code:

subject=`echo Early view data mart build completed on $week_end_dt`

This resolves the problem.
Thanks for your valuable efforts.

Hmm, interesting, I wonder if that is something to do with the way oracle is assigning the variable $week_end_dt

As an aside, what unix are you running? and what version of oracle?

Thanks for letting us know you've got it sorted