any possible to run sql result and output to file

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Run sql query in shell script and output data save as delimited text

I want to run sql query in shell script and output data save as delimited text (delimited text would be comma) Code: SPOOL_FILE=/pgedw/dan.txt SQL=/pgedw/dan.sql sqlplus -s username/password@myhost:port/servicename <<EOF set head on set COLSEP , set linesize 32767 SET TRIMSPOOL ON SET...

2. Shell Programming and Scripting

Get SQL query result to file in putty

How to Get SQL query result to file in putty? I have one SQL query and I want that query output to be redirected to the file. uname -a SunOS XXX 5.8 Generic_117350-58 sun4u sparc SUNW,Sun-Fire-480R Please suggest.

3. Shell Programming and Scripting

Run SQL thru shell script: how to get a new line when run sql query?

Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database. I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :( What should I do? I'm not sure that...

4. Shell Programming and Scripting

Awk script to run a sql and print the output to an output file

Hi All, I have around 900 Select Sql's which I would like to run in an awk script and print the output of those sql's in an txt file. Can you anyone pls let me know how do I do it and execute the awk script? Thanks.

5. Shell Programming and Scripting

Write result to output file

Good morning everybody, Beeing an absolute newbie in shell scripting I would like to look for some help here. I would like to read an external text file and format the data and write it to an output file. What I was trying to do was to display the result (this worked). But now I...

6. UNIX for Advanced & Expert Users

Output the SQL Query result to a File

Hello Guys, This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help. Here is my script- #! /bin/ksh export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2 /opt/oracle/app/oracle/product/9.2/bin/sqlplus -s...

7. Shell Programming and Scripting

Help! Paste Multiple SQL output result to exec command

Hi, I want to write the shell script to change multple file name (the file name is get from DB) e.g. cp db1.txt file1_new.txt cp db2.txt file2_new.txt cp db3.txt file3_new.txt I have write the script like this: VAR=`sqlplus -s $LOGON @<<ENDOFTEXT set termout off ...

8. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi Yogesh, Lucky that i caught you online. Yeah i read about DBI and the WriteExcel module. But the server is not supporting these modules. It said..."Cannot locate DBI"..."Cannot locate Spreadsheet::WriteExcel" I tried creating a simple text file to get the query output, but the...

9. Shell Programming and Scripting

Redirecting sql select query result to txt file

Hi , I just found you while surfing for the string 'Redirecting sql select query output from within a shell script to txt file/excel file' Could you find time sending me the code for the above question? It'll be great help for me. I have a perl file that calls the sql file...

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

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)

Shell Programming and Scripting