UNIX sql options

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

UNIX Date function with -d options

Hi , I couldn't understand how this program works. Can somebody please explain it to me. DT=`date -d "1 day"` # This part I understand echo ${DT/ */} # How this works echo ${DT/* /}

2. UNIX for Dummies Questions & Answers

UNIX ls options

Hi Guys I'm new to the forums and Unix. I have my first assignment for school and i'm stuck on question 1 spent close to 4 hours on it :(. (doesn't look good). I looked the the online documentation of ls but don't really understand it yet. I need to find files whose names that are of length...

3. Shell Programming and Scripting

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

In my korn shell - I have a sql with say 6 columns whose output i am redirecting to a file and attaching this file while sending a mail. While all this happens correctly, i face issues in the format of this file. my intended output is Column_1 Column_2 Column_3 Column_4 ...

4. UNIX for Dummies Questions & Answers

What are the career options in unix apart from unix system administration?

5. UNIX for Dummies Questions & Answers

Unix : About options of clear command ?

Hello everyone, My question is quite simple, even if I didn't find an answer. I would want a command (maybe clear with some options ?) that can do the following : clear completely the console, as it is when we start a console for the first time. My problem is that I sometimes display a lot...

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

8. Shell Programming and Scripting

unix variables from sql / pl/sql

How do I dynamically assign the below output to unix shell variables so I can build a menu in a shell script? Example: var1 = 1 var2= SYSTEM var3 = 2 var4= UNDOTBS1 and so on, then in the shell script I can use the variables to build a menu. set serveroutput on declare...

9. UNIX for Dummies Questions & Answers

Unix Path Options

I am looking for the best way to move files into a directory (ie PDF_files), if the directory doesn't exist to create it. However I am passing the full filename (psfile) of the file so I will have to remove the filename from the end, which can be at different field end lengths. This is a...

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)

UNIX for Dummies Questions & Answers