08-23-2013
if [[ -f cm/ims/dev/filename ]]; then
#statements
fi
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
hi
I face the problem the if else statement dint return correct result for me
my script as below:
#!/bin/ksh
sqlplus -s /nolog <<EOF
connect databaseuser/password
column num new_value num format 9999
set head off
select count(*) num from table1;
exit num
EOF
if ; then
echo "$?"... (6 Replies)
Discussion started by: jaseloh
6 Replies
2. Shell Programming and Scripting
Hi
How to compare created or modified date of two files
help needed
thanks
Vajiramani :) (9 Replies)
Discussion started by: vaji
9 Replies
3. Shell Programming and Scripting
Iam trying to compare the string in if else... but some how its not working
following is the code
On executing the above one its giving a error message ': bad number'
in the above parameter l & k are numbers and dbfiles and patchefiles are array
If i do echo ift working fine
... (2 Replies)
Discussion started by: kiranlalka
2 Replies
4. Shell Programming and Scripting
how to compare two lines using shell script? (1 Reply)
Discussion started by: suman_dba1
1 Replies
5. Shell Programming and Scripting
grep "HP_nv6005ud" mail_log.log | awk '{print $2}' >raju.log
if
then
grep "$testdate" raju.log
if
Hi in the above script $2 gives rge today date. and $ydate is yesterdays date.
not in the if condition i need to compare both the dates.
Please help me in this.
Thanks in... (7 Replies)
Discussion started by: intiraju
7 Replies
6. Shell Programming and Scripting
Can someone please help me out here?
I have strings similar to aafafaff45,29.34.942.45,edfdfafa that i want to compare to another similar string to check if they are the same. my script isn't working.
ONE="aafafaff45,29.34.942.45,edfdfafa"
TWO="ddfafagfa,87.57.942.45,afafafff"
if ONE is... (5 Replies)
Discussion started by: SkySmart
5 Replies
7. Shell Programming and Scripting
I have a directory with about 6 files that we receive regularly. these 6 files contain information for 3 different units, 2 for each unit. files related to a specific unit are named similarly with a change in number at the end of the file. the numbers should be sequential. for each grouping of... (3 Replies)
Discussion started by: scriptman237
3 Replies
8. Shell Programming and Scripting
Hi there,
I want to compare 2nd column which are alphanumeric values from each of the 2 files i.e.,lspv_pre.out and lspv_post.out , if found echo some message.
lspv_pre.out
hdisk0 00c39eaa451144dd rootvg active
hdisk1 00c39eaa45223322 ... (3 Replies)
Discussion started by: mbak
3 Replies
9. Shell Programming and Scripting
HI All,
I am new to Unix shell scripts..
Could you please post the unix shell script for for the below request.,
There are two different tables(sample1, sample2) in different schemas(s_schema1, s_schema2).
Unix shell script to compare the columns of two different tables of two... (2 Replies)
Discussion started by: Rajkumar Gopal
2 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I will be having file names like below,
1420SP1.01804
1420SP1.01805D
1420SP1.01805
1420SP1.01806D
1420SP1.01806
1420SP1.01901D
1420SP1.01901
1420SP1.01902D
1420SP1.01902
1420SP1.01903D
1420SP1.01903
1420SP1.01904
1420SP1.01905
From this, I need to list file names which is... (3 Replies)
Discussion started by: Sumanthsv
3 Replies
LEARN ABOUT LINUX
mysql_find_rows
MYSQL_FIND_ROWS MySQL Database System MYSQL_FIND_ROWS
NAME
mysql_find_rows - extract SQL statements from files
SYNOPSIS
mysql_find_rows [options] [file_name ...]
DESCRIPTION
mysql_find_rows reads files containing SQL statements and extracts statements that match a given regular expression or that contain USE
db_name or SET statements. The utility expects statements to be terminated with semicolon (;) characters.
Invoke mysql_find_rows like this:
shell> mysql_find_rows [options] [file_name ...]
Each file_name argument should be the name of file containing SQL statements. If no file names are given, mysql_find_rows reads the
standard input.
Examples:
mysql_find_rows --regexp=problem_table --rows=20 < update.log
mysql_find_rows --regexp=problem_table update-log.1 update-log.2
mysql_find_rows supports the following options:
o --help, --Information
Display a help message and exit.
o --regexp=pattern
Display queries that match the pattern.
o --rows=N
Quit after displaying N queries.
o --skip-use-db
Do not include USE db_name statements in the output.
o --start_row=N
Start output from this row.
COPYRIGHT
Copyright (C) 1997, 2014, Oracle and/or its affiliates. All rights reserved.
This documentation is free software; you can redistribute it and/or modify it only under the terms of the GNU General Public License as
published by the Free Software Foundation; version 2 of the License.
This documentation is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with the program; if not, write to the Free Software Foundation,
Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA or see http://www.gnu.org/licenses/.
SEE ALSO
For more information, please refer to the MySQL Reference Manual, which may already be installed locally and which is also available online
at http://dev.mysql.com/doc/.
AUTHOR
Oracle Corporation (http://dev.mysql.com/).
MySQL 5.5 01/30/2014 MYSQL_FIND_ROWS