Search Results

Originally Posted by nitinrp1
...
Assume i have the input file as below



Code:
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qrylog
WHERE StartTime >= '2010-03-24 20:10:08'
...

Thanks Tyler...

Assume i have the input file as below

SEL elapsedtime ,StartTime,QueryText
FROM dbc.qrylog
WHERE StartTime >= '2010-03-24 20:10:08'
AND username in...

Thanks a lot Tyler.. Appreciate your qucik reply ... as i have zero knowledge on Perl... hence i would like to understand how actually how the script is working.. Thanks again..

Thank You ... But i am looking out in perl

---------- Post updated at 06:11 AM ---------- Previous update was at 06:01 AM ----------

Thank You...

Assume if there are space before...

HI,

if there is a space before 'xxx_yyy_aaa_01' and also if there are no spaces before 'xxx_yyy_aaa_01' then how to modify the code..

SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry...

Hi Guys,

i have a input file as below

SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username ='xxx_yyy_aaa_01'
ORDER ...

Thanks for pointing out the typo .... its working now ...

---------- Post updated at 01:28 AM ---------- Previous update was at 01:25 AM ----------

Sorry for the confusion, there was a typo...

Moderator,

that was a typo in my script ... the $ is not there in my script ... but still its not working and not giving me the excepted result ... pls help

tried the way u said ... still its not working error message : binary operator expected

code

if [ $a eq "=" ]; then echo "Not a walid match"; else echo "walid match"; fi

suppose if i...

Hi Guys,

i have a variable which hold a string value of "in" when i try to compare this value against another value the if statement is not working.

$a=in

if [ "$a" == "=" ]
then
...

Thank You again !!! i may seek ur help again as i am totally new to unix :D

Thanks Guys !!! Suppose if i want to search for in( or in ( or in ( how to grep in one command with above sceniro...

Thank You ... can i use output in to a variable and then use in my if statement

HI Guys,

I need some expert help.. i have this below data as input

WHERE StartTime >= '2010-03-24 20:10:08'
AND username in('abc_xxx_yyy_01')

and output need is
just

in
...