03-06-2013
I would recommend to use tail, cut, and printf, as previously suggested.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
in a shell script how can I put the result of a grep command in a variable :
myvariable=grep mystring myfilename
Thank you. (3 Replies)
Discussion started by: big123456
3 Replies
2. Shell Programming and Scripting
Hi,
I worte a script which runs perfect when i execute it manually. But when i scheduled into cron the grep command alone is not working.
the sample script,
/usr/bin/grep FTP $subfile > /tmp/tfsrec.dat
tfs=`echo $?`
if
then
echo "FTP FOUND"
else
echo "FTP NOT FOUND"
Where... (5 Replies)
Discussion started by: thiru_cs
5 Replies
3. Shell Programming and Scripting
Dear Experts,
My file contains below-
GET:SUB:ISI,432350414557432;
RESP:0:MD,019352020633:ISI,432350414557432:T11,1:T21,1:T22,1:B16,1:T62,1:BAIC,0:BAOC,1:BOIC,0:BIRO,0:BORO,0:PAID,1;
GET:SUB:ISI,432350414581060;... (2 Replies)
Discussion started by: thepurple
2 Replies
4. UNIX for Advanced & Expert Users
Hi Folk,
Following is the command I used to get data related to the DataFlowEngine.
I wanted to know the % usage of cpu and memory.
ps avg | grep Data
This command will show the processes with its PID as :
PID TTY STAT TIME PGIN SIZE RSS LIM TSIZ TRS %CPU %MEM COMMAND
... (1 Reply)
Discussion started by: varungupta
1 Replies
5. Shell Programming and Scripting
Dear users,
I googled for a while, but i have got a lot of different answers regarding a simple unix command.
lets say there are a lot of files in a directory.
How can i list the files in a directory whose file types is "text"?
Thank you in advance (4 Replies)
Discussion started by: kevincobain2000
4 Replies
6. Shell Programming and Scripting
Hi Folks,
I am new to ksh, i have informatica parameter file that i need to update everyday with shell script. i need your help updating this file with new parameters.
sample data
$$TABLE1_DATE=04-27-2011
$$TABLE2_DATE=04-23-2011
$$TABLE3_DATE=03-19-2011
.......Highligned... (4 Replies)
Discussion started by: victor369
4 Replies
7. Programming
Dear All,
Could you help me how to put to the next line if I have pattern below in Perl language.
Data-123 Linux MacOSData-124 windows FreeBSDData-125 OpenBSD NetBSD
I would the output below:
Data-123 Linux MacOS
Data-124 windows FreeBSD
Data-125 OpenBSD NetBSD
... (2 Replies)
Discussion started by: askari
2 Replies
8. Shell Programming and Scripting
Hi all,
My sample file is something like this,
ORA-00206: Message 206 not found; product=RDBMS; facility=ORA
ORA-00202: Message 202 not found; product=RDBMS; facility=ORA
ORA-27063: Message 27063 not found; product=RDBMS; facility=ORA
ORA-00206: Message 206 not found; ... (1 Reply)
Discussion started by: sri1977
1 Replies
9. Shell Programming and Scripting
Hi,
I have below script
PROJECT_NAME=UDL/UDL_Weekly
sub= echo ${PROJECT_NAME}|cut -d "/" -f2
cat pr.sh|mail -s "`hostname`: $sub failed" sonu.pal@xyz.com
While running the script I am receiving the subject line in mail as " podetlsapp01: failed' instead of " podetlsapp01: ... (1 Reply)
Discussion started by: sonu_pal
1 Replies
10. UNIX for Dummies Questions & Answers
I am running a mailx command as follows in Linux:
mailx -s "Elapsed Time: " ora_dbas < $RUNDIR/sql_timings.out
I am trying to parse the file "sla_local_sql_timings.out" for the word Elapsed Time: and get the time from that file stored in a variable and display that variable in the subject... (4 Replies)
Discussion started by: vrkcamry
4 Replies
LEARN ABOUT PHP
mysqlnd_ms_query_is_select
MYSQLND_MS_QUERY_IS_SELECT(3) 1 MYSQLND_MS_QUERY_IS_SELECT(3)
mysqlnd_ms_query_is_select - Find whether to send the query to the master, the slave or the last used MySQL server
SYNOPSIS
int mysqlnd_ms_query_is_select (string $query)
DESCRIPTION
Finds whether to send the query to the master, the slave or the last used MySQL server.
The plugins built-in read/write split mechanism will be used to analyze the query string to make a recommendation where to send the query.
The built-in read/write split mechanism is very basic and simple. The plugin will recommend sending all queries to the MySQL replication
master server but those which begin with SELECT, or begin with a SQL hint which enforces sending the query to a slave server. Due to the
basic but fast algorithm the plugin may propose to run some read-only statements such as SHOW TABLES on the replication master.
PARAMETERS
o $query
- Query string to test.
RETURN VALUES
A return value of MYSQLND_MS_QUERY_USE_MASTER indicates that the query should be send to the MySQL replication master server. The function
returns a value of MYSQLND_MS_QUERY_USE_SLAVE if the query can be run on a slave because it is considered read-only. A value of
MYSQLND_MS_QUERY_USE_LAST_USED is returned to recommend running the query on the last used server. This can either be a MySQL replication
master server or a MySQL replication slave server.
If read write splitting has been disabled by setting mysqlnd_ms.disable_rw_split, the function will always return
MYSQLND_MS_QUERY_USE_MASTER or MYSQLND_MS_QUERY_USE_LAST_USED.
EXAMPLES
Example #1
mysqlnd_ms_query_is_select(3) example
<?php
function is_select($query)
{
switch (mysqlnd_ms_query_is_select($query))
{
case MYSQLND_MS_QUERY_USE_MASTER:
printf("'%s' should be run on the master.
", $query);
break;
case MYSQLND_MS_QUERY_USE_SLAVE:
printf("'%s' should be run on a slave.
", $query);
break;
case MYSQLND_MS_QUERY_USE_LAST_USED:
printf("'%s' should be run on the server that has run the previous query
", $query);
break;
default:
printf("No suggestion where to run the '%s', fallback to master recommended
", $query);
break;
}
}
is_select("INSERT INTO test(id) VALUES (1)");
is_select("SELECT 1 FROM DUAL");
is_select("/*" . MYSQLND_MS_LAST_USED_SWITCH . "*/SELECT 2 FROM DUAL");
?>
The above example will output:
INSERT INTO test(id) VALUES (1) should be run on the master.
SELECT 1 FROM DUAL should be run on a slave.
/*ms=last_used*/SELECT 2 FROM DUAL should be run on the server that has run the previous query
SEE ALSO
Predefined Constants, user filter .Runtime configuration, mysqlnd_ms.disable_rw_split, mysqlnd_ms.enable.
PHP Documentation Group MYSQLND_MS_QUERY_IS_SELECT(3)