Hi!
I'm not really familiar with Oracle. Is the file export_icat.sql a file containing commands for sqlplus? Where does the output go? To the screen (stdout)?
Then You can probably redirect it to a file, let's call it export_icat.out.
Your mail command sends a mail to user@domain.com, with the Subject "Results" and with the body content "Today's Results". Maybe not even that, depending on what the quotes are. If You want to send the content of the text file export_icat.out as the mail body, use:
Best regards,
Lakris
PS There are other commands in Your script that won't work as it is written.
Maybe
should be replaced with something that actually sets these variables?
Last edited by Lakris; 08-24-2010 at 02:58 PM..
Reason: PS...
Hi ,
I just found you while surfing for the string
'Redirecting sql select query output from within a shell script to txt file/excel file'
Could you find time sending me the code for the above question?
It'll be great help for me.
I have a perl file that calls the sql file... (1 Reply)
Hi Yogesh,
Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel"
I tried creating a simple text file to get the query output, but the... (1 Reply)
Hello Guys...
I want a small help from you guys.
Actually in Oracle, we are having a utlity called spool through which can store whatever SQL statements executed and other queries and the output of those queries in a file
So, similarly in Unix, if I start a session executing a number of Unix... (2 Replies)
Hello,
I run a web hosting company, and I'm wondering how I can use cPanel's Cron Jobs so that a copy of my entire home directory and a copy all of my MySQL databases can be compressed and emailed to me. I know nothing about Linux, Unix, or whatever that thing with the penguin is called. :)
... (7 Replies)
Hi
I need help on this. Its very urgent for me.. please try to help me out..
I have data in tables in DB2 database. I would like to export the data from DB2 tables into a text file, which has to be space delimited. so that I can carry out awk, grep operations on that file. I tried to export... (2 Replies)
I'm having problems with writing my sql results to a file:
sqlplus -S username/password@DB <<!!
set echo off
set verify off
set showmode off
set feedback off
set timing off
set linesize 250
set wrap off
set pagesize 0
set newpage none
set tab off
set trimspool on
set colsep... (1 Reply)
Hi
I want ot save SQL query result in one txt file. for that i have written one code line
sqlplus -s $dbstring @/usr/local/bin/sched/nightly_Cronjob/exec_123.sql >> /usr/local/bin/sched/nightly_Cronjob/result.txt
but it is not working .
database : Oracle
so please advice me how can i... (7 Replies)
Hi,
I am facing issues while exporting the results retrieved from the Database to an excel file.
I have 5 count query in order to count the records in 5 different tables.
I had connected to the DB and retrieved the column count and printed in the screen.
But wat I need to do is, I... (8 Replies)
Hello All,
I am writing the below unix script to email the result of a small pl sql procedure:
#!/bin/bash
ORACLE_HOME=/opt/oracle/orcts/product/9.2.0; export ORACLE_HOME
SQLPLUS=$ORACLE_HOME/bin/sqlplus
sqlplus -s user/pass@Db_instance<<EOF
set echo off
set feedback off
set pages 0... (9 Replies)
Discussion started by: Bunty bedi
9 Replies
LEARN ABOUT SUSE
xdg-email
XDG-EMAIL(1)XDG-EMAIL(1)NAME
xdg-email - command line tool for sending mail using the user's preferred e-mail composer
SYNOPSIS
xdg-email [--utf8] [--cc address] [--bcc address] [--subject text] [--body text] [--attach file] [mailto-uri address(es)]
xdg-email {--help --manual --version}
DESCRIPTION
xdg-email opens the user's preferred e-mail composer in order to send a mail to address(es) or mailto-uri. RFC2368 defines mailto: URIs.
xdg-email limits support to, cc, subject and body fields in mailto-uri, all other fields are silently ignored. address(es) must follow the
syntax of RFC822. Multiple addresses may be provided as separate arguments.
All information provided on the command line is used to prefill corresponding fields in the user's e-mail composer. The user will have the
opportunity to change any of this information before actually sending the e-mail.
xdg-email is for use inside a desktop session only. It is not recommended to use xdg-email as root.
See http://portland.freedesktop.org/EmailConfig for information on how the user can change the e-mail composer that is used.
OPTIONS --utf8 Indicates that all command line options that follow are in utf8. Without this option, command line options are expected to be
encoded according to locale. If the locale already specifies utf8 this option has no effect. This option does not affect mailto URIs
that are passed on the command line.
--cc address
Specify a recipient to be copied on the e-mail.
--bcc address
Specify a recipient to be blindly copied on the e-mail.
--subject text
Specify a subject for the e-mail.
--body text
Specify a body for the e-mail. Since the user will be able to make changes before actually sending the e-mail, this can be used to
provide the user with a template for the e-mail. text may contain linebreaks.
--attach file
Specify an attachment for the e-mail. file must point to an existing file.
Some e-mail applications require the file to remain present after xdg-email returns.
--help Show command synopsis.
--manual
Show this manualpage.
--version
Show the xdg-utils version information.
ENVIRONMENT VARIABLES
xdg-email honours the following environment variables:
XDG_UTILS_DEBUG_LEVEL
Setting this environment variable to a non-zero numerical value makes xdg-email do more verbose reporting on stderr. Setting a
higher value increases the verbosity.
EXIT CODES
An exit code of 0 indicates success while a non-zero exit code indicates failure. The following failure codes can be returned:
1 Error in command line syntax.
2 One of the files passed on the command line did not exist.
3 A required tool could not be found.
4 The action failed.
5 No permission to read one of the files passed on the command line.
CONFIGURATION
Visit http://portland.freedesktop.org/EmailConfig for information how to configure xdg-email to use the email client of your choice.
EXAMPLES
xdg-email 'Jeremy White <jwhite@example.com>'
xdg-email --attach /tmp/logo.png
--subject 'Logo contest'
--body 'Attached you find the logo for the contest.'
'jwhite@example.com'
xdg-email --subject 'Your password is about to expire'
'jwhite@example.com' 'bastian@example.com' 'whipple@example.com'
AUTHOR
Kevin Krammer, Jeremy White.
<kevin.krammer@gmx.at>
<jwhite@codeweavers.com>
xdg-utils 1.0 06/24/2007 XDG-EMAIL(1)