#!/usr/bin/perl
use warnings;
open (DATAFILE, "<data1") or die $!;
while (<DATAFILE>){
my ($line) = $_;
if ($line =~ /Execution started/){ print $line; print "\n";
}
}
Sir,
I want to check for the repation of a user address in a file i used || as my delimiter and want to check repetaip0n of the address that is mailid and then i have to use IMAP and all.
How can i do this...
I am in linux ...and my file is linux file.
... (5 Replies)
following file is taken as input
aaa bbb ccc
ddd eee ffff
grep -w aaa <filename> gives proper output.
grep \<\(aaa\).*\> filename :- should give output, since aaa is at begining, however i dosen't get any ouput.
Any discrepancy.
machine details:-
Linux anaconda... (1 Reply)
Hi all
I have a file with below content (content is variable whenever new product is launched). I need form a grep command like this
egrep "Unknown product|Invalid symboland so on"
How to do it using a script?
Unknown product
Invalid symbol
No ILX exch found
exceeds maximum size
AFX... (4 Replies)
Hi Guys, :p
I have a file like this:
2010-04-25 00:00:30,095 INFO - ]- start process U100M4
2010-04-25 00:00:30,096 DEBUG - ] -- call EJB
2010-04-25 00:00:30,709 INFO - - end processU100M4
2010-04-25 00:00:30,710 DEBUG - got message=Sorry
I want to out put format.
2010-04-25... (5 Replies)
Hi All,
I have searched the forum and tried to print only matching(pattern) words from the file, but its printing entire line. I tried with grep -w. I am on sunsolaris.
Eg:
cat file
A|A|F1|F2|A|F3|A
A|F10|F11|F14|A|
F20|A|F21|A|F25
I have to search for F (F followed by numbers) and ... (5 Replies)
Hi All,
I have a file which looks like this:
abc 1
abc 2
abc 3
abc 4
abc 5
bcd 1
bcd 3
bcd 3
bcd 5
cde 7
This file is just a miniature version of what I really have. Original file is some 1 million lines long.
I have tried to come up with the code for what I wish to accomplish... (1 Reply)
Hi,
I am stuck with a problem, will be thankful for your guidance and help.
I have two files. Each line is a group of words with first word as group Id. eg. 'gp1' in File1 and 'grp1' in File2.
<File1>
gp1 : xyz xys3 syt2 ssx itt kty
gp2 : syt2 kgk iti op2
gp3 : ppy yt5 itt sky... (11 Replies)
Hi
Consider the file
this is a good line
when running
grep '\b(good|great|excellent)\b' file5
I expect it to match the line but it doesn't... what am i doing wrong??
(ultimately this regex will be in a awk script- just using grep to test it)
Thanks,
Storms (5 Replies)
Hello dear Unix shell professionals,
I am desperately trying to get a seemingly simple logic to work. I need to extract words from a text line and save them in an array. The text can look anything like that:
aaaaaaa${important}xxxxxxxx${important2}ooooooo${importantstring3}...I am handicapped... (5 Replies)
Discussion started by: Grünspanix
5 Replies
LEARN ABOUT PHP
db2_fetch_object
DB2_FETCH_OBJECT(3) 1 DB2_FETCH_OBJECT(3)db2_fetch_object - Returns an object with properties representing columns in the fetched rowSYNOPSIS
object db2_fetch_object (resource $stmt, [int $row_number = -1])
DESCRIPTION
Returns an object in which each property represents a column returned in the row fetched from a result set.
PARAMETERS
o $stmt
- A valid stmt resource containing a result set.
o $row_number
- Requests a specific 1-indexed row from the result set. Passing this parameter results in a PHP warning if the result set uses a
forward-only cursor.
RETURN VALUES
Returns an object representing a single row in the result set. The properties of the object map to the names of the columns in the result
set.
The IBM DB2, Cloudscape, and Apache Derby database servers typically fold column names to upper-case, so the object properties will
reflect that case.
If your SELECT statement calls a scalar function to modify the value of a column, the database servers return the column number as the
name of the column in the result set. If you prefer a more descriptive column name and object property, you can use the AS clause to assign
a name to the column in the result set.
Returns FALSE if no row was retrieved.
EXAMPLES
Example #1
A db2_fetch_object(3) example
The following example issues a SELECT statement with a scalar function, RTRIM, that removes whitespace from the end of the column.
Rather than creating an object with the properties "BREED" and "2", we use the AS clause in the SELECT statement to assign the name
"name" to the modified column. The database server folds the column names to upper-case, resulting in an object with the properties
"BREED" and "NAME".
<?php
$conn = db2_connect($database, $user, $password);
$sql = "SELECT breed, RTRIM(name) AS name
FROM animals
WHERE id = ?";
if ($conn) {
$stmt = db2_prepare($conn, $sql);
db2_execute($stmt, array(0));
while ($pet = db2_fetch_object($stmt)) {
echo "Come here, {$pet->NAME}, my little {$pet->BREED}!";
}
db2_close($conn);
}
?>
The above example will output:
Come here, Pook, my little cat!
SEE ALSO db2_fetch_array(3), db2_fetch_assoc(3), db2_fetch_both(3), db2_fetch_row(3), db2_result(3).
PHP Documentation Group DB2_FETCH_OBJECT(3)