04-04-2008
Shell Script to execute SQL's
Hi people, i need youre help on this.
I need to create an Shell SCript to list in a directory some sql files and then execute them one by one .
Also i need to have Logs from the executed Sql's to send to our costummers.
Can anyone help me on this
Regards,
osramos
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi everybody...
can anyone help me in executing the .sql file with shell scripting....
thanx in advance (2 Replies)
Discussion started by: abuanas
2 Replies
2. Shell Programming and Scripting
Hi,
I know in oracle a .sql file is called by @ <path> /<filename>.
But how to call in sql 2005, I am opening the sql sessionwith sqsh, is there any command to execute there a .sql file (query in sql 2005) in K shell script. (0 Replies)
Discussion started by: n2ekhil
0 Replies
3. Shell Programming and Scripting
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where... (1 Reply)
Discussion started by: girish.raos
1 Replies
4. Shell Programming and Scripting
hi all,
how to execute shell script in another server that contain sql script. i tried using "ssh -l" option.. but i am unable to load the environment variable of the remote host.
please suggest how execute the shell script contain sql part inside it. (2 Replies)
Discussion started by: sandeep909
2 Replies
5. Programming
hi all,
I'm new to shell scripting, i want to know how to use the sql statements from the shell script? is there any documents or pdf to learn from the begining? plese provide me some useful links on the same.
Thanks all in advance..,:b: (3 Replies)
Discussion started by: vij_krr
3 Replies
6. Shell Programming and Scripting
I am using HP-UX:
I have written a ksh script where I need to connect to sqlplus and execute few sql scripts. Part of this code is -
sqlplus user/temp1234 <<!
set serverout on
set feedback off
set pages 1000
set colsep ,
set echo off
spool /home/supp1/pks/output.csv... (8 Replies)
Discussion started by: Sriranga
8 Replies
7. Shell Programming and Scripting
hello forum ,
I am new to shell scripting. as part of my assignment i have to execute a sql querry from the shell script. please help me.
example.
sql queerry:db2 "select emp_id from tsble emp".
i have to execute the above querry from the script.
advance thanks to forum
Siva ranganath (1 Reply)
Discussion started by: workforsiva
1 Replies
8. Shell Programming and Scripting
Hi All,
I want some help in writing a shell script which will be in the below form:
A logical representation of shell scripts:
->Shell scripts start
->Connect to database
->Execute a sql and store the output in a cursor(need to know is there any concept of cursor in unix)
->Using a loop... (2 Replies)
Discussion started by: Chitragupta
2 Replies
9. Shell Programming and Scripting
Hi Experts,
Need your support.
Not able to use sql query alias in shell script.
Could you please help me in finding right way to use alias with sql query in shell script.
Below is the code i am using.
#!/bin/bash
sqlplus -s abc/abc@abc << EOF> bcd.csv
set trimspool on
select zone_id... (4 Replies)
Discussion started by: as7951
4 Replies
10. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
LEARN ABOUT SUSE
mlmmj-sub
mlmmj-sub(1) General Commands Manual mlmmj-sub(1)
NAME
mlmmj-sub - subscribe address to a mailinglist run by mlmmj
SYNOPSIS
mlmmj-sub -L /path/to/list -a john@doe.org [-c | -C] [-d | -n] [-h] [-U] [-V]
-a: Email address to subscribe
-c: Send welcome mail
-d: Subscribe to digest version of the list
-C: Request mail confirmation
-h: This help
-L: Full path to list directory
-m: Subscriber moderation string
-n: Subscribe to nomail version of the list
-s: Don't send a mail to the subscriber if already subscribed
-U: Don't switch to the user id of the listdir owner
-V: Print version
DESCRIPTION
This utility is used to subscribe people to the specified mailinglist. It will write the email address in a file with the name of the
beginning letter of the email address getting subscribed in the <listdir>/subscribers.d/ directory.
Unless the -U switch is used it will switch its user id to the user id owning the list directory. This is done to make sure that new files
created are having correct permissions.
The nomail version of the list is a list version where people are subscribed like usual, but they won't recieve any postings to the list.
This is useful for people who read the mailinglist through a news gateway, but want to be able to post to the list.
Normally a mail is sent to the subscriber if the address is already subscribed to the list. If the -s switch is used such a mail will not
be sent.
When neither -c nor -C are specified, subscription silently happens.
SEE ALSO
mlmmj-unsub(1), setuid(2)
AUTHORS
This manual page was written by the following persons:
Soren Boll Overgaard <boll@debian.org> (based on html2man output)
Mads Martin Jorgensen <mmj@mmj.dk>
mlmmj-sub September 2004 mlmmj-sub(1)