09-20-2002
Re: Read a file and replace a value- Bourne and Korn shell
Try :
l_var=`sed -e 's/employee_id = " "/employee_id is null/p' <filename> | head -n 1`
l_var is your string variable
<filename> is the file that contains your sql statement
is that what you were looking for?
cheers
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Im trying to code some logic into a test script to test for the existence of a file before recreating it. Im using the following line to test for this:
if -r test.txt;
However I get the error message
./testScript.sh: -r: not found
Having read through the man pages im still not clear whats... (2 Replies)
Discussion started by: blakmk
2 Replies
2. Shell Programming and Scripting
Hello!!
I'm want to read each line of a file.
I'm doing a cut command, using \n - linefeed as delimeter and "list" as my file.
cut -f1 -d"\n" -s < list
Changing the file, putting spaces and doing cut -f1 -d" " -s < list it works, but with linefeed nothing is returned.
Thanks... (5 Replies)
Discussion started by: alienET
5 Replies
3. Shell Programming and Scripting
I am attempting to itterate through a file that has multiple lines and for each one read the entire line and use the value then to search in other files. The problem is that instead of an entire line I am getting each word in the file set as the value I am searching for. For example in File 1... (2 Replies)
Discussion started by: run_unx_novice
2 Replies
4. UNIX for Dummies Questions & Answers
How do I test for the presence of a file in Bourne Shell (3 Replies)
Discussion started by: vins
3 Replies
5. UNIX for Dummies Questions & Answers
Hi,
I have a script that uses "nohup" command to execute a korn shell script. Which one is the correct shell to use bourne shell or korn shell to execute a korn shell? and why?
Thanks in advanced. (2 Replies)
Discussion started by: XZOR
2 Replies
6. Shell Programming and Scripting
What is the differance between "C-Shell", "Korn-Shell" and "Bourne-Shell"? Please explain me! (3 Replies)
Discussion started by: Prathinidhi
3 Replies
7. Shell Programming and Scripting
Hallo,
i need a Prompting read in my script:
read -p "Enter your command: " command
But i always get this Error:
-p: is not an identifier
When I run these in c-shell i get this error
/usr/bin/read: read: bad option(s)
How can I use a Prompt in the read command? (9 Replies)
Discussion started by: wiseguy
9 Replies
8. Shell Programming and Scripting
Hi All
I have writing a Korn Shell script to execute it on many of our servers. But some servers don't have Korn Shell installed, they use Borne Shell.
Some operations like calculation don't work :
cat ${file1} | tail -$((${num1}-${num2})) > ${file2}
Is it possible to activate Korn Shell... (3 Replies)
Discussion started by: madmat
3 Replies
9. Shell Programming and Scripting
Could some one tell me the difference btw Bourne shell and the Kshell? Which is more flexible and reliable in terms of portability and efficiency. When i type the following command ..
$ echo $SHELL
yields me
/bin/sh
Does this tells me that I am in Bourne shell. If yes, how can i get... (6 Replies)
Discussion started by: bobby1015
6 Replies
10. Shell Programming and Scripting
I am suppose to make a program that cuts the extension off of a file. It uses that .ext to decide which program needs to be used to open the file. This only finds the name of the program from a list of programs I made. My problem is when it has the name of the program it needs to use, how can I... (3 Replies)
Discussion started by: dordrix
3 Replies
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)