Search Results

Hi,

I need to get the Status Column in Green if it is approved and Red if it is declined in the HTML output attachment#!/bin/bash
body_csv="/authlistener/ProdA/service/queryRS.csv"...

Thank you.... it is working...

---------- Post updated at 02:23 AM ---------- Previous update was at 02:06 AM ----------

Not able to receive the mail...

---------- Post updated at 02:27 AM...

Hi, When i am trying to run the script which was prepared for sending the SQL output through mail body and attachment iam getting an error

String """missing terminating quote(").
SP2-0734: ...

Hi Yodha, As i had mentioned earlier. it should work only based on script not even SQL package should be used. No tools available in that environment and i dont have permissions to install as well.
...

ok. But is there any other way to get the output in excel attachment.

will be grateful if you can provide some idea.

Thank you...

iam the one who is doing this in my pre-prod env...

i had used the mailx as well. but it is not working.

thanks.

file is in same path.

thanks.

How do you tell? What connection / relation do you have to the original requestor?

att_csv="/authlistener/ProdA/service/attchment.csv"
att_op="/authlistener/ProdA/service/attachment.xml"
from="venkata.maddela@cgi.com"
to="venkata.maddela@cgi.com"
subject="test with attachment"...

Hi, Initially i had generated CSV through SQL and then trying to convert CSV to excel. here i am getting the output in one cell or it is throwing an error as excel format corrupted. i am not having...

i am trying to get an SQL output into an excel attachment and the other output into mail body as excel format. i am getting the excel format in the mail body, but i am not getting the excel...