How to execute a sql querry from shell script?

Login or Register to Ask a Question and Join Our Community

How to execute a sql querry from shell script?

Tags

Login to Discuss or Reply to this Discussion in Our Community

Top Forums Shell Programming and Scripting How to execute a sql querry from shell script?

05-11-2013

Registered User

14, 0

Join Date: Feb 2012

Last Activity: 18 May 2013, 1:39 AM EDT

Location: hyderabad

Posts: 14

Thanks Given: 0

Thanked 0 Times in 0 Posts

How to execute a sql querry from shell script?

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

workforsiva

View Public Profile for workforsiva

Find all posts by workforsiva

05-11-2013

Registered User

108, 11

Join Date: Aug 2012

Last Activity: 26 June 2019, 12:56 AM EDT

Posts: 108

Thanks Given: 34

Thanked 11 Times in 11 Posts

Quote:

Originally Posted by workforsiva

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

Hi siva u can do the below lines

Code:

sqlplus -s user/password@database_name <<EOF>> output_result
            set feedback off
            set head off
            set serverout off
            set verify off
            set heading off
            set space 0
            set trimspool on
            set pagesize 0
            set echo on
            set linesize 10000
select emp_id from tsble emp
;
EOF

---------- Post updated 05-12-13 at 12:10 AM ---------- Previous update was 05-11-13 at 10:44 PM ----------

Quote:

Originally Posted by workforsiva

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

GIVE below the try

Code:

#!/bin/bash 
set -x 
export DB2INSTANCE=db2inst1 
db2Path=/data1/db2inst1/sqllib/bin/db2 
scriptPath=/data1/db2inst1 
$db2Path "CONNECT TO DB2Works" 
$db2Path "select emp_id from tsble emp" > $scriptPath/Output.txt 
$db2Path "CONNECT RESET" 

o/p will be in $scriptPath/Output.txt

zozoo

View Public Profile for zozoo

Find all posts by zozoo

Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script to execute sql query.

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...

2. Shell Programming and Scripting

Help with shell script to execute a sql cursor

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...

3. UNIX and Linux Applications

how to execute multiple .sql scripts from within a shell script using sqlplus

using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks any help would be appreciated :wall:

4. Shell Programming and Scripting

Not able to execute many SQL scripts within a shell script

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...

5. Programming

how to execute the sql quires from shell script?

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:

6. Shell Programming and Scripting

how to execute shell script in another server that contain sql.

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.

7. Shell Programming and Scripting

How to execute the multiple line sql using shell script

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...

8. Shell Programming and Scripting

TO execute .sql 2005 query file in shell script

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.

9. Shell Programming and Scripting

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. Shell Programming and Scripting

How to execute a .sql file with shell script

hi everybody... can anyone help me in executing the .sql file with shell scripting.... thanx in advance

Login or Register to Ask a Question