Format options while Redirecting output of sql to a file in shell

10 More Discussions You Might Find Interesting

1. Programming

Python or Shell script to Grep strings from input file and output in csv format

Hi Experts, I am writing a python script to grep string from file and display output in csv file as in attached screenshot https://drive.google.com/file/d/1gfUUdfmQma33tz65NskThYDhkZUGQO0H/view Input file(result_EPFT_config_device) Below is the python script i have prepared as of...

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

3. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

4. Shell Programming and Scripting

Redirecting command output to a file in a shell script

Hello All, I have some unique requirement. I have written a very lengthy script which calls number of resource script to execute a particular task. What I want is output of each command(called from main script and resource scripts) should go to a...

5. Shell Programming and Scripting

Help me! Format output file using shell program

Hi, I have following input file. I want to generate output file in specific format using shell program. The input file has atleast few thousands of lines, the below are some sample lines. Input file: "ORDER NO"|"ORDER AMT"|"LINE ITEM"|"LINE AMT"|"SALES COMMISION %" ORD3456|5000|LIN345|30|25%...

6. Shell Programming and Scripting

formatting into CSV format of SQL session output

I am getting a no of fields from a SQL session (e.g. select a,b,c from table). How do I convert the output values into CSV format . The output should be like this 'a','b','c',

7. Shell Programming and Scripting

redirecting sql query output to a file

Hi, I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning. success records to success.log file failure record to failure.log file. As of now i am doing like...

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

redirecting SQL output from within a shell script

Hi all I would like to open a SQL session from within a shell script and then redirect the output of the SQL command to a file. e.g. #!/bin/bash sqlplus "/ as sysdba" <<EOF @$HOME/recovery_space.sql EOF I want to redirect the output of the SQL command to a temp file, because...

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