...
Assume if there are space before xxx_yyy_aaa_01 , can pls provide me the perl script for this.
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username = 'xxx_yyy_aaa_01'
ORDER BY LastRespTime DESC
or
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username in 'xxx_yyy_aaa_01'
ORDER BY LastRespTime DESC
Here are a few cases I could think of -
Code:
$
$
$ # equal-to (=) operator not followed by space
$ cat file1.sql
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username ='xxx_yyy_aaa_01'
ORDER BY LastRespTime DESC
$
$ perl -lne '/^(\s*\w+){2}\s*(.*?)[\s(]*.xxx_yyy_aaa_01.*$/ && print $2' file1.sql
=
$
$ # equal-to (=) operator followed by a space
$ cat file2.sql
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username = 'xxx_yyy_aaa_01'
ORDER BY LastRespTime DESC
$
$ perl -lne '/^(\s*\w+){2}\s*(.*?)[\s(]*.xxx_yyy_aaa_01.*$/ && print $2' file2.sql
=
$
$ # IN operator followed by bracket "(" not followed by space
$ cat file3.sql
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username in('xxx_yyy_aaa_01')
ORDER BY LastRespTime DESC
$
$ perl -lne '/^(\s*\w+){2}\s*(.*?)[\s(]*.xxx_yyy_aaa_01.*$/ && print $2' file3.sql
in
$
$ # IN operator followed by space followed by bracket "("
$ cat file4.sql
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username in ('xxx_yyy_aaa_01')
ORDER BY LastRespTime DESC
$
$ perl -lne '/^(\s*\w+){2}\s*(.*?)[\s(]*.xxx_yyy_aaa_01.*$/ && print $2' file4.sql
in
$
$ # IN operator followed by space not followed by bracket "("
$ cat file5.sql
SEL elapsedtime ,StartTime,QueryText
FROM dbc.qry
WHERE StartTime >= '2010-03-24 20:10:08'
AND username in 'xxx_yyy_aaa_01'
ORDER BY LastRespTime DESC
$
$ perl -lne '/^(\s*\w+){2}\s*(.*?)[\s(]*.xxx_yyy_aaa_01.*$/ && print $2' file5.sql
in
$
$
I have a need to regularly add all macs in our domain to dns.
Ideally it would work like Wintel machines. Transparently and automatically.
What are the tools, scripts, roadblocks to doing so?
I'm not talking about DynDNS type of service here. This is the internal dns for where I work. (0 Replies)
hi i am using fedora core 5 and i already configured the dhcp server and the dns server but i want to configure dynamic dns to update the dns automatiklly
thank you in advance (1 Reply)
Hi,
Could any one tell me solution for this.
i have a library in my /usr/lib and latest in /myhome/lib/ (thay differ functionality symbols my application uses symbols from latest lib).
when compile and link my application , every thing goes fine
but when running the application ld... (4 Replies)
I have a file that reads File (X.txt)
Contents of record 1:
rdrDESTINATION_ADDRESS (String) "91 971502573813"
rdrDESTINATION_IMSI (String) "000000000000000"
rdrORIGINATING_ADDRESS (String) "d0 movies"
rdrORIGINATING_IMSI (String) "000000000000000"
rdrTRAFFIC_EVENT_TIME... (0 Replies)
Hi people,
I am writing a korn shell script, and one of the command gives an output something like below:
release.label.2010.03.02
objects:
/project/path/to/some/file_name.ksh
/project/path/another/file_name01.dat
I have to retrieve the file paths one by one & use them as... (9 Replies)
Hi,
I have two files , one file with data file with attributes that need to be sent to another file to generate a predefined format.
Example:
File.txt
AP|{SSHA}VEEg42CNCghUnGhCVg==
APVG3|{SSHA}XK|"password"
AP3|{SSHA}XK|"This is test"
....
etc
---------
test.sh has... (1 Reply)
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of... (1 Reply)
I am attempting to create a script that would allow me to list all the instances associated with a DB2 and then prompt the user to choose which one to issue the db2profile command against. I use the db2 command db2ilist to get a list of the instances for a particular server, but the number of... (7 Replies)
Hi Folks,
I am trying to assign a value from the command to a dynamic variable. But I am not getting the desired output.. I am sure something is wrong so i need experts advise.
There will be multiple files like /var/tmp/server_1, /var/tmp/server_2, /var/tmp/server_3, having different server... (6 Replies)
Hello,
I'm using the awk command to insert empty columns on a tab delimited flatfile - which works fine -
=> But I'm not able to manage dynamicaly the filename of the awk output based on the source flatfile filename
I have 3 source flatfile:
flatfile_Jan-2016.csv
flatfile_Feb-2016.csv... (3 Replies)
Discussion started by: Tipiak
3 Replies
LEARN ABOUT LINUX
cosnotification
CosNotification(3erl) Erlang Module Definition CosNotification(3erl)NAME
CosNotification - This module export functions which return QoS and Admin Properties constants.
DESCRIPTION
To get access to all definitions include necessary hrl files by using:
-include_lib("cosNotification/include/*.hrl").
EXPORTS
'EventReliability'() -> string()
This function returns the EventReliability QoS identifier
'BestEffort'() -> short()
This function returns the BestEffort QoS value.
'Persistent'() -> short()
This function returns the Persistent QoS value.
'ConnectionReliability'() -> string()
This function returns the ConnectionReliability QoS identifier.
'Priority'() -> string()
This function returns the Priority QoS identifier.
'LowestPriority'() -> short()
This function returns the LowestPriority QoS value.
'HighestPriority'() -> short()
This function returns the HighestPriority QoS value.
'DefaultPriority'() -> short()
This function returns the DefaultPriority QoS value.
'StartTime'() -> string()
This function returns the StartTime QoS identifier.
'StopTime'() -> string()
This function returns the StopTime QoS identifier.
'Timeout'() -> string()
This function returns the Timeout QoS identifier.
'OrderPolicy'() -> string()
This function returns the OrderPolicy QoS identifier.
'AnyOrder'() -> short()
This function returns the AnyOrder QoS value.
'FifoOrder'() -> short()
This function returns the FifoOrder QoS value.
'PriorityOrder'() -> short()
This function returns the PriorityOrder QoS value.
'DeadlineOrder'() -> short()
This function returns the DeadlineOrder QoS value.
'DiscardPolicy'() -> string()
This function returns the DiscardPolicy QoS identifier.
'LifoOrder'() -> short()
This function returns the LifoOrder QoS value.
'RejectNewEvents'() -> short()
This function returns the RejectNewEvents QoS value.
'MaximumBatchSize'() -> string()
This function returns the MaximumBatchSize QoS identifier.
'PacingInterval'() -> string()
This function returns the PacingInterval QoS identifier.
'StartTimeSupported'() -> string()
This function returns the StartTimeSupported QoS identifier.
'StopTimeSupported'() -> string()
This function returns the StopTimeSupported QoS identifier.
'MaxEventsPerConsumer'() -> string()
This function returns the MaxEventsPerConsumer QoS identifier.
'MaxQueueLength'() -> string()
This function returns the MaxQueueLength Admin identifier.
'MaxConsumers'() -> string()
This function returns the MaxConsumers Admin identifier.
'MaxSuppliers'() -> string()
This function returns the MaxSuppliers Admin identifier.
Ericsson AB cosNotification 1.1.16 CosNotification(3erl)