06-27-2002
Try:
find ../../ -name \*.sql -print | sed 's=.*/=='
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
I have a question, and don't know my way around with it. :(
If I have a pathname
say. i have the following pathname:
/users/classA/tests
how can I get only 'tests' out of that path.
I know we have to use IFS=/ ... but next, i am clueless :confused:
I also know that I can use... (2 Replies)
Discussion started by: sam2004
2 Replies
2. Shell Programming and Scripting
With C Shell you can get the root, head, tail and extension of a pathname by using pathname variable modifiers.
Example Script:
#! /bin/csh
set pathvar=/home/WSJ091305.txt
echo $pathvar:r
echo $pathvar:h
echo $pathvar:t
echo $pathvar:e
The result of executing this script is:
... (7 Replies)
Discussion started by: BCarlson
7 Replies
3. Shell Programming and Scripting
I am wondering if there's an easy way to extract individual directories from a pathname in a csh script. For example, if I have a shell variable such as
set datadirlist = /space/quimby/1
can I get 'space', 'quimby', and '1' and assign it individually to another variable?
Any suggestions... (2 Replies)
Discussion started by: same1290
2 Replies
4. UNIX for Advanced & Expert Users
Hi all
when I execute pmap command on one of my daemon process, I am able to see the following output.
Address Kbytes RSS Anon Locked Mode Mapped File
00010000 40 40 - - r-x-- irs026bmd
00028000 56 56 16 - rwx-- irs026bmd
00036000... (3 Replies)
Discussion started by: axes
3 Replies
5. Shell Programming and Scripting
Hi,
Im finding some files form a specific path and den writing those files to another file as:
find /SYS/admin/data/xml -name '*.xml' -type f ! -newer file1 -print >>out.xml
and when im doing cat out.xml im getting like dis:
... (2 Replies)
Discussion started by: ss_ss
2 Replies
6. UNIX for Dummies Questions & Answers
I'm trying to prune out the findings of a certain directory path and have something like the following workiing on Linux (Linux 2.6.9-67.0.7.ELsmp #1 SMP x86_64):
find . -path 'test/tmp' -prune -o -print
I now need to have this working on sun/solaris (SunOS 5.8 Generic_117350-34 sun4u sparc... (12 Replies)
Discussion started by: antonino
12 Replies
7. Shell Programming and Scripting
I am capturing the files in a directory to an array. I have 2 arrays with list of files in two different directories. Both the directories are supposed to have the same number of files and filenames.
I want to check that the same file exists in both the directories. After I capture the... (1 Reply)
Discussion started by: Sangtha
1 Replies
8. Shell Programming and Scripting
Hello.
After looking through the forum I am trying without success to remove lines from a file each time that ligne contains a pattern.
As this is running in script, I am using some variables:
The command : sed '/pattern/d' source_file > corrected_source_file
In the script
sed ... (2 Replies)
Discussion started by: jcdole
2 Replies
9. UNIX for Dummies Questions & Answers
Hi!
If your working directory contains a file you want to work on, or give as an argument, you don't have to give the explicit pathname, just the filename, like so:
$ vi while_loop.ksh
But if you want execute an executable file, you must supply the explicate pathname, like so:
./while_loop.ksh... (20 Replies)
Discussion started by: sudon't
20 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have a few csv files within the directory structure as shown below
/tmp/user/Proj/V1/data/Common1/Zip1/123.csv
/tmp/user/Proj/V1/data/Common2/Zip2/3453.csv
/tmp/user/Proj/V1/data/Common2/Zip2/1234.csv
and so on...
I need to get these csv files and move to another dir... (5 Replies)
Discussion started by: Jag02
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)