TO execute .sql 2005 query file in shell script

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Not able to write SQL query output in to .csv file with shell script.

I am trying to write SQL query output into a .csv file. But in the output columns are displaying in different lines instead of coming in one line. Main Code shell script: this is my code: #!/bin/bash file="db_detail.txt" . $file rm /batch/corpplan/bin/dan.csv...

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

3. Red Hat

Sql query through shell script

hey , i am using this code to store value of a sql query and and then use it in other query but after some time , but it is not working. please help #!/bin/bash val_1=$( sqlplus -s rte/rted2@rel76d2 << EOF setting heading off select max(stat_id) from cvt_stats; exit EOF ) nohup...

4. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

5. Shell Programming and Scripting

Execute SQL query in unix script

Hi I am new in unix. oracle and unix are installed in my sytem.i need the script which could connect to the oracle using username ,password and schema and can run the select * from tab query. Thanks vijay

6. Shell Programming and Scripting

How to use sql data file in unix csv file as input to an sql query from shell

Hi , I used the below script to get the sql data into csv file using unix scripting. I m getting the output into an output file but the output file is not displayed in a separe columns . #!/bin/ksh export FILE_PATH=/maav/home/xyz/abc/ rm $FILE_PATH/sample.csv sqlplus -s...

7. Shell Programming and Scripting

query sql using shell script

query sql using shell script, is it possible? my friend told me to do a file.sql and link to my shell script, but can i query sql using shell script? thanks in advance!

8. UNIX for Dummies Questions & Answers

Execute PL/SQL function from Unix script (.sql file)

Hi guys, I am new on here, I have a function in oracle that returns a specific value: create or replace PACKAGE BODY "CTC_ASDGET_SCHED" AS FUNCTION FN_ASDSCHEDULE_GET RETURN VARCHAR2 AS BEGIN DECLARE ASDSchedule varchar2(6); ASDComplete...

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

LEARN ABOUT PHP

db2_num_fields

DB2_NUM_FIELDS(3)							 1							 DB2_NUM_FIELDS(3)

db2_num_fields - Returns the number of fields contained in a result set

SYNOPSIS

       int db2_num_fields (resource  $stmt)

DESCRIPTION

	Returns the number of fields contained in a result set. This is most useful for handling the result sets returned by dynamically generated
       queries, or for result sets returned by stored procedures, where your application cannot  otherwise  know  how  to  retrieve  and  use  the
       results.

PARAMETERS

	      o $stmt
		- A valid statement resource containing a result set.

RETURN VALUES

	Returns  an  integer  value  representing the number of fields in the result set associated with the specified statement resource. Returns
       FALSE if the statement resource is not a valid input value.

EXAMPLES

       Example #1

	      Retrieving the number of fields in a result set

	       The following example demonstrates how to retrieve the number of fields returned in a result set.

	      <?php

	      $sql = "SELECT id, name, breed, weight FROM animals ORDER BY breed";
	      $stmt = db2_prepare($conn, $sql);
	      db2_execute($stmt, $sql);
	      $columns = db2_num_fields($stmt);

	      echo "There are {$columns} columns in the result set.";
	      ?>

	      The above example will output:

	      There are 4 columns in the result set.

SEE ALSO

       db2_execute(3),	  db2_field_display_size(3),	db2_field_name(3),    db2_field_num(3),    db2_field_precision(3),     db2_field_scale(3),
       db2_field_type(3), db2_field_width(3).

PHP Documentation Group 													 DB2_NUM_FIELDS(3)

Shell Programming and Scripting