Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

running db2 sql and exporting output from ksh scipt

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting running db2 sql and exporting output from ksh scipt
# 1  
Old 03-12-2008
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 <db_name>; set schema APP;"
export to /home/db2inst1/esb_checks/kicker/kicker.del of del;
select * from <TABLE_NAME>;

The script connects OK, and sets the correct schema however an error is produced as follows when running and exporting the sql code:-

/home/db2inst1/esb_checks/kicker/kicker.del: This is not a
n identifier.

When I login as the db2inst1 user and run the query manually it works fine:-

connect to <database_name>;
set schema APP;
export to /home/db2inst1/esb_checks/kicker/kicker.del of del;
select * from <TABLE_NAME>;

I've scoured the UNIX forums and found nothing to resolve my problem, I have found a few threads that have pointed me in what I have thought is the right direction, but I am still at a loss.

I'm wondering if this is a permissions issue? or maybe not?

Any help or expert pointers, much appreciated

Cheers

Candlino
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Storing multiple sql queries output into variable by running sql command only once

Hi All, I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise. Eg : Select 'Query 1 output' from dual; Select 'Query 2 output' from dual; I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies

2. Shell Programming and Scripting

Need Fix in Exporting a db2 query output

When I use export for sql query in a Script : Select '1',ModHist',count(*) from cc.mdhist; it was exporting the record to a file as: "1" "ModHist" 778201 Here 1 & ModHist are coming in Doublequotes. If I run the above query directly in Unix prompt it was displaying the output as... (1 Reply)
Discussion started by: karumudi7
1 Replies

3. Shell Programming and Scripting

Change the font of text in output file in shell scipt

hi, I want to change the font of text in output file. :( I tried the below code code: if awk 'BEGIN{if('$RSS'>='1000')exit 0;exit 1}' then RED=`echo "\033 i can see colors in terminal but not in output file :wall: please help me how i can get colors text in output file. edit... (1 Reply)
Discussion started by: sreelu
1 Replies

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

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

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

7. Shell Programming and Scripting

Running Sql scripts accross db2

Hi, I would be really thankful, if anyone could help me out with this,since i am very new to this shell scripting. I have 6 sql scripts that i am trying to run in unix across db2. i want the scripts to be executed as follows, script_1 should be executed first. Then... (4 Replies)
Discussion started by: jnimz
4 Replies

8. UNIX for Advanced & Expert Users

find command from shell scipt (ksh) problem

Hi experts, I have a simple shell script as follows. #!/bin/ksh FIND_STRING="\( -name 'testfile*.Z' -o -name 'DUMMY_*' \) " find /tmp -type f $FIND_STRING -print When I run this with ksh -x testscript, I get the following output. + FIND_STRING=\( -name 'testfile*.Z' -o -name... (6 Replies)
Discussion started by: kodermanna
6 Replies

9. Shell Programming and Scripting

Run SQL queries in DB2 and output to file

Hi, I new to Unix and scripting. Following is my requirement. Can someone tell me whether its possible or not. Also please let me know how to proceed further if this is possible. List of queries are stored in a file. For example, I have to run a query like this: Select * from &XYZ where... (0 Replies)
Discussion started by: simhasuri
0 Replies

10. Shell Programming and Scripting

flags to suppress column output, # of rows selected in db2 sql in UNIX

Hello, I am new to db2 SQL in unix so bear with me while I try to explain the situation. I have a text file that has the contents of the where condition that I am using for a db2 SQL in UNIX ksh. Here is the snippet. if ; then echo "Begin processing VALUEs" ... (1 Reply)
Discussion started by: jerardfjay
1 Replies
Login or Register to Ask a Question

LEARN ABOUT PHP

cubrid_ping

CUBRID_PING(3)								 1							    CUBRID_PING(3)

cubrid_ping - Ping a server connection or reconnect if there is no connection

SYNOPSIS

       bool cubrid_ping ([resource  $conn_identifier])

DESCRIPTION

	Checks whether or not the connection to the server is working.

PARAMETERS

	      o $conn_identifier
		- The CUBRID connection identifier. If the connection identifier is not specified, the last connection opened by cubrid_connect(3)
		is assumed.

RETURN VALUES

	Returns TRUE if the connection to the server CUBRID server is working, otherwise FALSE.

EXAMPLES

       Example #1

	      cubrid_ping(3) example

	      <?php
	      set_time_limit(0);

	      $conn = cubrid_connect('localhost', 33000, 'demodb');

	      /* Assuming this query will take a long time */
	      $sql = "select * from athlete";
	      $result = cubrid_query($sql);
	      if (!$result) {
		  echo 'Query #1 failed, exiting.';
		  exit;
	      }

	      /* Make sure the connection is still alive, if not, try to reconnect */
	      if (!cubrid_ping($conn)) {
		  echo 'Lost connection, exiting after query #1';
		  exit;
	      }
	      cubrid_free_result($result);

	      /* So the connection is still alive, let's run another query */
	      $sql2 = "select * from code";
	      $result2 = cubrid_query($sql2);
	      ?>

PHP Documentation Group 													    CUBRID_PING(3)