02-03-2009
Quote:
Originally Posted by
uativan
set -f
set -- $name
echo $3
I used the code and it work fine, thank you very much!!
The result from the sql now is a little bit different,
"name ------------ Peter (1 row)"
"name ------------ Mary Lee (1 row)"
The result is vary in word length.
set -f
set -- $name
echo $3
'Peter' is ok
'Mary' is not ok, I want to get 'Mary Chan'.
I want to get
'Peter'
'Mary Chan'
Any enhancement i could do?
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have several lines like this ones:
123456789abcde /aa/bb/123456_$data.log
123456789abcde /aa/bb/123456_not_a_data_log
987654321ab /aa/bb/xpto123456_$data.log
...
How do I get into a variable the value "/aa/bb/123456_$data.log" , searching only for the beggining and ending... (3 Replies)
Discussion started by: Scarlos
3 Replies
2. Shell Programming and Scripting
This is probably pretty simple butI'm not sure how to best go about it.
If I have
FILE="myBigLongFileName_1.xls"
FILE_PREFIX=`echo $FILE| cut -d"." -f1`
# that gives "myBigLongFileName_1"
All i want to do now is chop the "_1" from the end of $FILE_PREFIX
Any ideas anyone? (3 Replies)
Discussion started by: djkane
3 Replies
3. Shell Programming and Scripting
i have a strings
abc-def.csv
ghi-jkl.csv
i want to make it as
abc-*-def.xyz
ghi-*-jkl.xyz
How to do it?. (5 Replies)
Discussion started by: senthilk615
5 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I have a value of a filepath in a variable
DATAFILE with value as "customtop/gpsore37/gepspo/1.0/bin/ashoka.csv
".
Now i want the value of last 4 charcters in to another variable.
That is EXTENSION = .csv
How can i do this in Shell scripting
Thanks in advance
Alla Kishore (8 Replies)
Discussion started by: alla.kishore
8 Replies
5. UNIX for Dummies Questions & Answers
I need to check the occurrence of one string within another.
code
********************
if ;then do something done
********************
Thanks (7 Replies)
Discussion started by: w020637
7 Replies
6. UNIX for Dummies Questions & Answers
Hi
I use the below cmd to get the list of files that are modified than <temp> file in the <path> diretory
cmd:find <path> -name '*.zip' -type f -newer <temp> -print
i am getting all the list of files that are new or modified, with abs path, i want to copy all of these files to a... (3 Replies)
Discussion started by: Naveen_5960
3 Replies
7. Shell Programming and Scripting
I have a string '<Hi>abc</Hi>"
How to print "abc" (6 Replies)
Discussion started by: sandy1028
6 Replies
8. UNIX for Dummies Questions & Answers
Hi,
I hav a string lets say aa.txt:bb:txt
length of the string can vary.. I have to keep the token inside a array and the delimiter is : plz send me the code (2 Replies)
Discussion started by: Deekay.p
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a ouput string likes 'u8wos' or 'u10acsd' or somthing else 'u{number}{any characters}'and I want to get the number behind the letter 'u' by bash shell.
Thanks
Damon (11 Replies)
Discussion started by: Damon_Qu
11 Replies
10. UNIX for Dummies Questions & Answers
Hi,
My requirement is to get the substring and then remove special character.
Ex
I have data like T_SYSTEM_XXXXX_YYYY_ZZZ
I want to get XXXXXYYYYZZZ
the part after T_SYSTEM is varying it might be XXX_YY or just XX
can you tell me which all commands i have to use.
i understand i... (5 Replies)
Discussion started by: Mohammed_Tabish
5 Replies
LEARN ABOUT PHP
db2_fetch_row
DB2_FETCH_ROW(3) 1 DB2_FETCH_ROW(3)
db2_fetch_row - Sets the result set pointer to the next row or requested row
SYNOPSIS
bool db2_fetch_row (resource $stmt, [int $row_number])
DESCRIPTION
Use db2_fetch_row(3) to iterate through a result set, or to point to a specific row in a result set if you requested a scrollable cursor.
To retrieve individual fields from the result set, call the db2_result(3) function.
Rather than calling db2_fetch_row(3) and db2_result(3), most applications will call one of db2_fetch_assoc(3), db2_fetch_both(3), or
db2_fetch_array(3) to advance the result set pointer and return a complete row as an array.
PARAMETERS
o $stmt
- A valid stmt resource.
o $row_number
- With scrollable cursors, you can request a specific row number in the result set. Row numbering is 1-indexed.
RETURN VALUES
Returns TRUE if the requested row exists in the result set. Returns FALSE if the requested row does not exist in the result set.
EXAMPLES
Example #1
Iterating through a result set
The following example demonstrates how to iterate through a result set with db2_fetch_row(3) and retrieve columns from the result
set with db2_result(3).
<?php
$sql = 'SELECT name, breed FROM animals WHERE weight < ?';
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, array(10));
while (db2_fetch_row($stmt)) {
$name = db2_result($stmt, 0);
$breed = db2_result($stmt, 1);
print "$name $breed";
}
?>
The above example will output:
cat Pook
gold fish Bubbles
budgerigar Gizmo
goat Rickety Ride
Example #2
i5/OS recommended alternatives to db2_fetch_row/db2_result
On i5/OS it is recommended that you use db2_fetch_both(3), db2_fetch_array(3), or db2_fetch_object(3) over
db2_fetch_row(3)/db2_result(3). In general db2_fetch_row(3)/db2_result(3) have more issues with various column types in EBCIDIC to
ASCII translation, including possible truncation in DBCS applications. You may also find the performance of db2_fetch_both(3),
db2_fetch_array(3), and db2_fetch_object(3) to be superior to db2_fetch_row(3)/db2_result(3).
<?php
$conn = db2_connect("","","");
$sql = 'SELECT SPECIFIC_SCHEMA, SPECIFIC_NAME, ROUTINE_SCHEMA, ROUTINE_NAME, ROUTINE_TYPE, ROUTINE_CREATED, ROUTINE_BODY, IN_PARMS, OUT_PARMS, INOUT_PARMS, PARAMETER_STYLE, EXTERNAL_NAME, EXTERNAL_LANGUAGE FROM QSYS2.SYSROUTINES FETCH FIRST 2 ROWS ONLY';
$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
while ($row = db2_fetch_both($stmt)){
echo "<br>db2_fetch_both {$row['SPECIFIC_NAME']} {$row['ROUTINE_CREATED']} {$row[5]}";
}
$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
while ($row = db2_fetch_array($stmt)){
echo "<br>db2_fetch_array {$row[1]} {$row[5]}";
}
$stmt = db2_exec($conn, $sql, array('cursor' => DB2_SCROLLABLE));
while ($row = db2_fetch_object($stmt)){
echo "<br>db2_fetch_object {$row->SPECIFIC_NAME} {$row->ROUTINE_CREATED}";
}
db2_close($conn);
?>
The above example will output:
db2_fetch_both MATCH_ANIMAL 2006-08-25-17.10.23.775000 2006-08-25-17.10.23.775000
db2_fetch_both MULTIRESULTS 2006-10-17-10.11.05.308000 2006-10-17-10.11.05.308000
db2_fetch_array MATCH_ANIMAL 2006-08-25-17.10.23.775000
db2_fetch_array MULTIRESULTS 2006-10-17-10.11.05.308000
db2_fetch_object MATCH_ANIMAL 2006-08-25-17.10.23.775000
db2_fetch_object MULTIRESULTS 2006-10-17-10.11.05.308000
SEE ALSO
db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_object(3), db2_result(3).
PHP Documentation Group DB2_FETCH_ROW(3)