Sponsored Content
Top Forums Shell Programming and Scripting Need to write shell script for my .sql file call Post 302879350 by lakshmanraok117 on Thursday 12th of December 2013 04:12:24 AM
Old 12-12-2013
How to send an email in unix with my .csv file attachment

Hi Guys,
How to send an email in unix with myfile.csv attachment. myfile.csv is in unix path.

I have used the below command, but its sending .csv data in mail body.

mailx -s "Subject" user@domain.com < output.csv

Can any one suggest me plz..

Regards,
LKR
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

how can a call shell script from pl/sql

I like to call a shell script from pl/sql proceduere and i have to use the shell script return value in that procedure. i am using oracle 9i and cygwin. can any one suggest me how can i do this (0 Replies)
Discussion started by: rajesh.P
0 Replies

2. Shell Programming and Scripting

how can i call a shell script from pl/sql

I would like to call the shell script from pl/sql and i need to uses the value returned by the shell script in pl/sql procedure. can any one suggest me how can i do that? (3 Replies)
Discussion started by: rajesh.P
3 Replies

3. Shell Programming and Scripting

how to call shell script from pl/sql loop

Hello, I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea? Here is idea about the code: my... (1 Reply)
Discussion started by: rosalinda
1 Replies

4. Shell Programming and Scripting

call shell script from pl/sql block

Hi Experts, I want to call script_name.ksh as many time as id in customer table and also pass it as a parameter to script. someting Like below. for i in select id from customer do ./script_name.ksh $i & done I have figured out how to have ID from customer but now how to call... (3 Replies)
Discussion started by: Opamps123
3 Replies

5. UNIX for Advanced & Expert Users

call sql through shell script

Hi i am not able to connect sqlplus my script is as follows $ORACLE_HOME/bin/sqlplus << ! > /tmp/extract/DM.txt and output is SQL*Plus: Release 11.1.0.7.0 - Production on Wed Jan 18 02:53:54 2012 Copyright (c) 1982, 2008, Oracle. All rights reserved. Enter user-name: t175481... (1 Reply)
Discussion started by: tushar_spatil
1 Replies

6. Shell Programming and Scripting

Need Help: Shell script to call sql session with variables stored in .txt file

Hi, I need help in writing a shell script which can read data from a text file (Cancel_ID.txt) and then calls sqlplus session (Cancel.sql) with the first line parameter of the text file ("0322600453") till all rows are not completed. ... (4 Replies)
Discussion started by: Khan28
4 Replies

7. Shell Programming and Scripting

How to call SQL Loader in shell script?

HI Experts, I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into the table. Also i... (1 Reply)
Discussion started by: sam1234
1 Replies

8. Shell Programming and Scripting

Need help to write to log file whether the shell script call pass fail

I have the below script triggered daily at 330am in the morning, since last 7 days job not writing anything to database. below impala shell calling shell file which has sql , it is extracting data and loads to a flat file txt file. which is going wrong for last 1 week. need help, echo... (2 Replies)
Discussion started by: cplusplus1
2 Replies

9. Shell Programming and Scripting

Shell script to call sql file

hi , the below script contains sql query and after executed it sends the output of the query (output.txt) to an email body with conditional subject line based on the output of all_counts_match.txt. i want to make this script generic so that it can accept the sql file as parameter and can... (5 Replies)
Discussion started by: itzkashi
5 Replies

10. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv... (6 Replies)
Discussion started by: sandeepgoli53
6 Replies
AMC-MAILING(1)						       Auto Multiple Choice						    AMC-MAILING(1)

NAME
AMC-mailing - mail PDF annotated completed answer sheets to students SYNOPSIS
auto-multiple-choice mailing [--xmlargs args.xml] --projet project-dir --students-list students-list.csv [--list-encoding encoding] --email-column col --sender sender-email --subject subject --text email-body [--debug file.log] [transport arguments...] DESCRIPTION
The command AMC-mailing.pl sends by email the PDF annotated completed answer sheets to the students. Email addresses are taken from the students list file. --projet project-dir Gives the project directory. --students-list students-list.csv sets the students list file name. --list-encoding encoding selects an encoding for file students-list.csv (default is utf-8). --email-column col sets the name of the column containing the email addresses of the students in the students list file. --sender sender-email sets the sender email. --subject subject sets the subject of the emails to send. --text email-body sets the body text of the emails to send. --transport transport sets the transport to use. transport may be sendmail or SMTP. --debug file.log gives a file to fill with debugging information. TRANSPORT ARGUMENTS
Depending on the value used for argument transport, the following arguments can be added: Transport sendmail --sendmail-path path sets the path to the sendmail command (defaults to /usr/sbin/sendmail). Transport SMTP --smtp-host host sets the SMTP hostname (defaults to smtp). --smtp-port port sets the port to use (default value is 25). ARGUMENTS IN A XML FILE
To avoid encoding problems, one can place some arguments in a XML file and use the --xmlargs file.xml argument as the first command argument. Here is an exemple of such a file: <?xml version="1.0" encoding="UTF-8"?> <arguments> <arg>--sender</arg><arg>Bienvenue &lt;paamc@passoire.fr&gt;</arg> <arg>--text</arg><arg>Voila votre copie corrigee</arg> <arg>--subject</arg><arg>QCM</arg> </arguments> AUTHORS
Alexis Bienvenue <paamc@passoire.fr> Main author Jean Berard Translation from French Georges Khaznadar Translation from French COPYRIGHT
Copyright (C) 2008-2012 Alexis Bienvenue This document can be used according to the terms of the GNU General Public License, version 2 or later. Auto Multiple Choice 1.1.1 06/19/2012 AMC-MAILING(1)
All times are GMT -4. The time now is 05:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy