Search Results

Hi,

Thanks RTM. This seems to be the best solution so far. I have designed the flow of the algorithm based on this solution - here it goes -

--*******************************************--
|...

We have a ksh which runs once every 15 minutes. Based on a certain condition (for invalid data) we are spooling a file and if the file is of length greater than 0 bytes, then we are mailing this file...

Hi Anbu,

This is giving me a value like as follows -

Tue Oct 17 16:53:45 EDT 2006

What if I want only 'Tue Oct 17 2006' to display. I dont want the hh:mm:ss EDT part.


Thanks
Sree.

But, the values in the description column might have embedded spaces in themselves.

Tmarikle,

Also, please note that desc1:value1 desc2:value2 desc3:value3 are not fixed - they are as coming from the table...so they keep changing for every cell.
There might be a case where there...

But there are other columns as well that are selected in my sql -

My query goes like this -

select npp as NPP,error_message as ERROR,error_type as TYPE,data_selection as DA...

Agreed...Still ....if any leads could come through......

Hi,

I am using sqlplus (called inside my ksh) to create a file which is mailed to the users as an xls.
There is one DESCRIPTION column which is currently coming as wrapped, but, the users want a...

Thanks Anbu.

just for my explanation (for an unix learner like me) -

This is going to replace the string 'CURRENT DATE' with the value of the current date - Am I right?

Hi,

I have a requirement where I need to write the current date to the file.
This remaining content of this file does not change and we use this file to concat with another one.

Only thng is...