05-14-2013
An alternative with no sw cost is JAVA JDBC tool xigole jisql.
Converting delimited text to proper CSV is a task for a serious tool, but if you have no ',' or '"' in your data, you can just change the delimiter to comma. Now you have a CSV file. You need an attaching batch email client like mutt to send the file as an attachment with your message to your distribution list. Sometimes you can use uuencode to pack the csv for you, or you can send it as a 8 bit binary, using sendmail and various tricks.
You could turn it into an HTML table and send an HTML email. Users can paste the html table into excel.
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am searching a way to export data file on Unix to SQL server on a daily bases.
Any one has any ideas?
Thanks in advance! (20 Replies)
Discussion started by: whatisthis
20 Replies
2. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
3. Shell Programming and Scripting
Hello All,
I am starting with UNIX. Any help is highly appreciated.
How to extract data using UNIX shell script? And how do you export data using UNIX shell scripts into Microsoft Excel format?
Thank you. (3 Replies)
Discussion started by: desiondarun
3 Replies
4. Shell Programming and Scripting
Hi All,
I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data).
The tables list is not static, and those are selecting through dynamic sql
query. Can any body help how to write this shell script.
Thanks, (3 Replies)
Discussion started by: sankarg
3 Replies
5. Shell Programming and Scripting
I am writing a unix shell script that will extract records from table and write into a file.
======================================
#! /bin/ksh
############################
# AFI Monitor Script
############################
. /db2/uszlad48/sqllib/db2profile
export... (5 Replies)
Discussion started by: kmanivan82
5 Replies
6. Shell Programming and Scripting
Hi,
How to fetch data from oracle database in unix shell scripting.
list=`sqlplus -s ds_user/dsuser@EMI <<EOF
set feedback off
set serveroutput on
set heading off
set pagesize 0
set tab off
select IP_ID from table
/
exit
EOF`
The output is not what i expected.I need output in... (4 Replies)
Discussion started by: Anusha_Reddy
4 Replies
7. Shell Programming and Scripting
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea . (2 Replies)
Discussion started by: honey26
2 Replies
8. Shell Programming and Scripting
Export data from database in Excel sheet with the help of Shell script and automated the report every day in the mornig. (1 Reply)
Discussion started by: neeraj617
1 Replies
9. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
1 Replies
10. Shell Programming and Scripting
Hi All ,
I am stuck on the below situation.I have a table called "test" which are created on hive.I need to export the data from hive to a file(test.txt) on local unix system.I have tried the below command ,but its giving the exception .
hive -e "select * from test " > /home/user/test.txt ;
... (1 Reply)
Discussion started by: STCET22
1 Replies
LEARN ABOUT SUSE
calibre-smtp
CALIBRE-SMTP(1) calibre CALIBRE-SMTP(1)
NAME
calibre-smtp - part of calibre
SYNOPSIS
calibre-smtp [options] [from to text]
DESCRIPTION
Send mail using the SMTP protocol. calibre-smtp has two modes of operation. In the compose mode you specify from to and text and these are
used to build and send an email message. In the filter mode, calibre-smtp reads a complete email message from STDIN and sends it.
text is the body of the email message. If text is not specified, a complete email message is read from STDIN. from is the email address
of the sender and to is the email address of the recipient. When a complete email is read from STDIN, from and to are only used in the SMTP
negotiation, the message headers are not modified.
Whenever you pass arguments to calibre-smtp that have spaces in them, enclose the arguments in quotation marks.
OPTIONS
--version
show program's version number and exit
-h, --help
show this help message and exit
-l, --localhost
Host name of localhost. Used when connecting to SMTP server.
-o, --outbox
Path to maildir folder to store failed email messages in.
-f, --fork
Fork and deliver message in background. If you use this option, you should also use --outbox to handle delivery failures.
-t, --timeout
Timeout for connection
-v, --verbose
Be more verbose
COMPOSE MAIL
Options to compose an email. Ignored if text is not specified
-a, --attachment
File to attach to the email
-s, --subject
Subject of the email
SMTP RELAY
Options to use an SMTP relay server to send mail. calibre will try to send the email directly unless --relay is specified.
-r, --relay
An SMTP relay server to use to send mail.
--port Port to connect to on relay server. Default is to use 465 if encryption method is SSL and 25 otherwise.
-u, --username
Username for relay
-p, --password
Password for relay
-e, --encryption-method
Encryption method to use when connecting to relay. Choices are TLS and SSL. Default is TLS.
SEE ALSO
The User Manual is available at http://calibre-ebook.com/user_manual
Created by Kovid Goyal <kovid@kovidgoyal.net>
calibre-smtp (calibre 0.6.53) July 2010 CALIBRE-SMTP(1)