Everybody,
can you tell me how express about this; we have text data file as :
parameter1 Parameter2
AA 55
BB 77
. .
. .
. .
We want to draw table for this data as attached then send as body of Email (4 Replies)
Hi
The below script working when we are sending the html as attachment can u please guide how to send thesmae data in table form direct in the mail and not in mail attachment .
cat Employee.sql
SET VERIFY OFF
SET PAGESIZE 200
SET MARKUP HTML ON SPOOL ON PREFORMAT OFF ENTMAP ON -
HEAD... (0 Replies)
I have to send a couple of rows that have been returned from a SQL query. I have written the output of the query to a file and while i try to print this in the mail body the formatting goes wrong.
Intended Output in mail body:
Col1 Col2 Col3
------ ... (2 Replies)
Hello,
Currently i have a script which will disply the results in plain text format.
I want to format the result in more readable format like Making bold headings and format with colors etc. Something like html and send that content as email.
Please help me how i can do that.
I am using... (10 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
select p.spid,se.program seprogram, se.machine, se.username, sq.sql_text,sq.retrows from v$process p
inner join v$session se on p.addr = se.paddr
inner join
( select... (2 Replies)
I have two details to send in html email, two details present in variables, Processname & date which I need to send html email in table. Column1 is Processname: Process1 & column 2 is date:16/6/16 4:55 AM
I have below basic html code, how to create table in html to send mail
echo "<html>" >>... (1 Reply)
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Discussion started by: Dharmatheja
2 Replies
LEARN ABOUT HPUX
evmvarformat
EvmEventFormat(3) Library Functions Manual EvmEventFormat(3)NAME
EvmEventFormat(), EvmEventFormatFromTemplate(), EvmVarFormat() - format events for display
SYNOPSIS
Library
EVM Support Library
Parameters
buffer A pointer to a character string to receive the formatted event data. The stored string is null-terminated, even if trun-
cated, unless the length operand is zero(0).
length The maximum length (number of characters) of the output string. If the formatted event is longer than length, the output is
truncated.
event The event to be formatted.
show_template The primary template for formatting the output.
var_name The name of a variable data item of the event whose value is to be formatted.
translate A Boolean value indicating whether I18N (internationalization) translation is to be attempted on the variable data item
(var_name). If the translate operand is translation is attempted. In addition, the following conditions must be met:
o The variable is of type string and includes an I18N (internationalization) message identifier
o The event contains I18N (internationalization) catalog information.
DESCRIPTION
Information contained in an event must be formatted into a readable format. The software which posts the event (event poster) supplies
formatting information through the event's format data item. The routines described here explain the event formatting capabilities.
The routine combines the supplied event's format data item with any data items or variables specified in the event's format item that are
available in the event. returns a formatted version of the event in buffer.
If the event contains I18N message catalog information, and the catalog is available in the user's locale, the format string is retrieved
from the message catalog if possible. If no translation is possible, the format string from the event is used.
If the event does not contain format information, produces a generic display of the event's name and any variables.
The routine also formats the supplied event. uses the supplied show_template string as its primary formatting template. Literal charac-
ters in show_template are transferred to the buffer unchanged.
Any token of the form or is replaced by the value of the corresponding data item from the supplied event, if it is present. item_name is
the name of the item stored in the event. If width is supplied, the value occupies a minimum of width character positions. width is an
integer number specifying the size of the value stored in item_name. The item_name is the name of a standard event data item. The special
string is replaced by the results of applying to the event.
Refer to evmshow(1) and EvmEvent(5) for more information about formatting events for display.
retrieves a variable called var_name from the supplied event, and returns a formatted version of its value in buffer.
If translate is I18N translation is applied as appropriate.
Notes
Floating point values are formatted using the format specifier.
RETURN VALUE
The operation completed without error.
One of the arguments to the function is invalid.
A value in a structure member is invalid.
An operation failed because an attempt to acquire heap memory failed.
ERRORS
The value of is not set.
SEE ALSO
Commands
evmshow(1), locale(1).
Routines
EvmEventDump(3), printf(3S), setlocale(3C).
Event Management
EVM(5).
EVM Events
EvmEvent(5).
EvmEventFormat(3)