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 OSF1
tbl
tbl(1) General Commands Manual tbl(1)NAME
tbl - formats tables for nroff
SYNOPSIS
tbl [file...]
OPTIONS
Produces output without fractional line motions. You use this option when the destination output device or printer or post-filter cannot
handle fractional line motions. Reads in ms macros prior to table formatting. Reads in the mm macros prior to table formatting, if your
system has the *roff mm macros installed.
DESCRIPTION
The tbl preprocessor is used for formatting tables for nroff. When you run tbl, the input files are copied to standard output, except for
lines between the .TS (table start) and .TE (table end) command lines. All lines between the .TS and .TE command lines are assumed to
describe a table and are reformatted.
If no arguments are given, tbl reads from standard input, so it can be used as a filter. When tbl is used with neqn or other equation for-
matting *roff tools, the tbl command should be invoked first to minimize the volume of data passed through the pipes.
EXAMPLES
The following examples show tables that have been coded using tbl macros and the results after you run tbl to format the table. .TS
tab(@); c s s c c s c c c l n n. Household Population Town@Households @Number@Size Bedminster@789@3.26 Bernards Twp.@3087@3.74
Bernardsville@2018@3.30 Bound Brook@3425@3.04 Branchburg@1644@3.49 Bridgewater@7897@3.81 Far Hills@240@3.19 .TE
When formatted by tbl and then nroff, the output is as follows:
Household Population
Town Households
Number Size Bedminster 789 3.26 Bernards Twp. 3087 3.74 Bernardsville 2018 3.30 Bound Brook
3425 3.04 Branchburg 1644 3.49 Bridgewater 7897 3.81 Far Hills 240 3.19 The following example shows
how to specify column widths using the w column option. The width of a column must be large enough to contain it's anticipated
data. Multiple line column entries are controlled by T{ and T}.
.TS tab(@); cw(.5i) lw(1.2i) lw(3.0i). Return@Error@Description _ 0@@Successful completion. 1@ENOM@T{ Insufficient memory exists
to create this object. Multiple lines can be written in text surrounded by T braces. T} 2@EINVAL@The value specified is invalid.
.TE
When formatted by tbl and then nroff, the output is as follows:
Return Error Description _________________________________________________________________
0 Successful completion.
1 ENOM Insufficient memory exists to create
this object. Multiple lines can be
written in text surrounded by T braces.
2 EINVAL The value specified is invalid.
SEE ALSO neqn(1), nroff(1), ms(5)tbl(1)