Sponsored Content
Top Forums Shell Programming and Scripting Running Sql scripts accross db2 Post 302250323 by avis1981 on Thursday 23rd of October 2008 06:49:39 AM
Old 10-23-2008
or you can just use
read sql script into a string variable sqltext,
db2 -x +w <sqltext>
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

SQL scripts not running, possible timeout issue?

I am a novice Unix scripter and need a little advice/help on a script I've written that's causing some problems. We are using Solaris 9 on a Sun box and the script is invoked with the korn shell. I have a two-part question: I wrote a shell script that calls and executes 3 separate sql scripts,... (3 Replies)
Discussion started by: E2004
3 Replies

2. Shell Programming and Scripting

Running SQL Scripts from Shell script - Need insight!

I've a script that fetches various values from the database as below: #! /bin/ksh $conn="user/pwd@service_name" `sqlplus -s << $conn EOF1 @xyz.sql @pqr.sql @abc.sql EOF1` The output of the script should generate txt files containing the results from queries which are further... (6 Replies)
Discussion started by: manthasirisha
6 Replies

3. Shell Programming and Scripting

Calling SQL LDR and SQL plus scripts in a shell script

Hi- I am trying to achieve the following in a script so I can schedule it on a cron job. I am fairly new to the unix environment... I have written a shell script that reads a flat file and loads the data into an Oracle table (Table1) via SQLLDR. This Works fine. Then, I run a nested insert... (5 Replies)
Discussion started by: rajagavini
5 Replies

4. Shell Programming and Scripting

running db2 sql and exporting output from ksh scipt

Hi there, I am trying to write a shell script as root on AIX 5.3 where I change user to db2inst1, connect to our db2 database, run a sql select query and export the result of the query to a file. The code I have so far is as follows:- #!/usr/bin/ksh su - db2inst1 -c "db2 connect to... (0 Replies)
Discussion started by: candlino
0 Replies

5. Shell Programming and Scripting

Reading values from a file using DB2 SQL

I have some alphbetical codes in that (1 Reply)
Discussion started by: kavithakuttyk
1 Replies

6. Shell Programming and Scripting

Connect to DB2 table using Shell scripts

Can anyone please help me with an unix shell script to connect a DB2 database. My requirement is just to display the no of records present in a table of a DB2 database through Unix Shell script. Thx - Ram (1 Reply)
Discussion started by: onlyraja
1 Replies

7. Programming

db2 sql and Java Gui's

Hi Everyone, I'm basically trying to rewrite a korn shell script that currently runs and execute a db2 SQL and then it presents the output below to the users. I wonder how I can achieve the same in Java using GUI's. Any advise / comments would be highly appreciated. Thanks. DBNAME ... (1 Reply)
Discussion started by: arizah
1 Replies

8. Shell Programming and Scripting

Execute multiple SQL scripts from single SQL Plus connection

Hi! I would like to do a single connection to sqlplus and execute some querys. Actually I do for every query one connection to database i.e echo 'select STATUS from v$instance; exit' > $SQL_FILE sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies

9. Shell Programming and Scripting

Help in executing the following db2 sql querry in unix

Hi All, Please help me out in executing the following db2 querry in unix db2 "select AP_RQ_ACQ_INST_ID || ',' || txn_classifier || ',' || AP_RS_RESP_CD || ',' || (count(*) AS COUNT1) || ',' || (SUM(AP_RQ_TXN_AMT) AS TOTAL_AMT) from TXN_RECORD where CREATE_TS > '2010-11-22 11:00:00.008645' ... (1 Reply)
Discussion started by: dudd9
1 Replies

10. UNIX for Advanced & Expert Users

Call parallel sql scripts from shell and return status when both sql are done

Hi Experts: I have a shell script that's kicked off by cron. Inside this shell script, I need to kick off two or more oracle sql scripts to process different groups of tables. And when both sql scripts are done, I will continue in the shell script to do other things like checking processing... (3 Replies)
Discussion started by: huasheng8
3 Replies
cvm-mysql(8)						      System Manager's Manual						      cvm-mysql(8)

NAME
cvm-mysql - MySQL module SYNOPSIS
cvm-mysql CREDENTIALS
Pass phrase DESCRIPTION
This module queries a MySQL database for the account name, compares the stored pass phrase with the given one using crypt(3). CONFIGURATION VARIABLES
CVM_MYSQL_DEFAULT_FILE The full path of the defaults file to read if the following variable is set. If not set, the file $HOME/.my.cnf will be read (the MySQL default). CVM_MYSQL_DEFAULT_GROUP If set, the module will read connection default options from the named group in the defaults file as above CVM_MYSQL_HOST The hostname or IP of the MySQL server. If not set, a connection to the local host is assumed. CVM_MYSQL_USER The MySQL login ID to connect as. If not set, the invoking user is assumed. CVM_MYSQL_PASS The password for the above user. CVM_MYSQL_DB The database name, must be set. CVM_MYSQL_PORT The port number for the TCP/IP connection (only used if the server is not local). CVM_MYSQL_POSTQ (optional) The SQL query to execute after the credentials have been validated, see cvm-sql(7). CVM_MYSQL_PWCMP (optional) The password comparison module to use. CVM_MYSQL_SOCKET The path to the socket that should be used for connections to a local server. CVM_MYSQL_QUERY (optional) The SQL query to issue to retrieve the row containing the account information from the database, see cvm-sql(7). SEE ALSO
cvm-sql(7), cvm-pgsql(8), cvm-pwfile(8), cvm-qmail(8), cvm-unix(8), cvm-vmailmgr(8), cvm-benchclient(8), cvm-checkpassword(8), cvm-test- client(8) http://untroubled.org/pwcmp/pwcmp.html http://untroubled.org/cvm/cvm.html cvm-mysql(8)
All times are GMT -4. The time now is 11:31 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy