Below code works for different databases i.e. MYSQL and ORACLE
The problem is for MYSQL in Block:
Code:
if [ $? -ne 0 ]
;
Code:
$?
taking value accordingly but in case of ORACLE
Code:
$?
is always taking this value as zero (0).
That is the reason in Oracle it always going in else Block in any case..
and in case of MYSQL it is working fine.....
Code:
add_fk()
{
echo "`date` Entering $0 " | tee -a $LOGFILE
if [ $DB_SYSTEM = "ORACLE" ]
then
sqlplus -s sna/dbmanager <<! | tee -a $LOGFILE
ALTER TABLE TABLE_NAME ADD CONSTRAINT CONSTRAINT_NAME_FKEY
FOREIGN KEY (LAYERRATENAME)
REFERENCES REFERENCE_TABLE(REFERENCE_TABLENAME);
exit
!
if [ $? -ne 0 ]
then
echo "Foreign Key can not be established - incompatibile data" | tee -a $LOGFILE
echo " Please verify the data in TABLE_NAME and REFERENCE_TABLE table" | tee -a $LOGFILE
status=2
else
echo "Foreign Key is Added" | tee -a $LOGFILE
fi
elif [ $DB_SYSTEM = "MYSQL" ]
then
mysql --user=${OSMDB_USR} --password=${OSMDB_PWD} ${DB_NAME} <<!
set storage_engine=INNODB;
ALTER TABLE TABLE_NAME ADD CONSTRAINT CONSTRAINT_NAME_FKEY
FOREIGN KEY (LAYERRATENAME)
REFERENCES REFERENCE_TABLE(REFERENCE_TABLENAME);
exit
!
if [ $? -ne 0 ]
then
echo "Foreign Key can not be established - incompatibile data" | tee -a $LOGFILE
echo " Please verify the data in TABLE_NAME and REFERENCE_TABLE table" | tee -a $LOGFILE
status=2
else
echo "Foreign Key is Added" | tee -a $LOGFILE
fi
fi
}
Please help me
---------- Post updated at 04:41 PM ---------- Previous update was at 04:12 PM ----------
I have a script which connects to remote server and ftp the files
It works fine, however if there is any failure in ftp connection can it be handled???
ftp log
ftp session start time is: Thu Jun 19 00:00:02 BST 2008
Not connected.
Not connected.
Interactive mode off.
Not connected.... (1 Reply)
Hi ,
Can any one tell me is there any standard method to track errors during sftp ?
using which command i can track sftp errors ? i tried using echo $? .
Most of the times i am getting error number 127 ,1, 255. whether it is constant numbers ?
Please help me out. Thanks in advance (2 Replies)
Helo Experts,
I need a help in handling errors in shell script, wants my errors displayed in text file instead of command window..
My shell script is here;
cd /cygdrive/s/Files
for FILES in ./*.*
do
temp=`basename $FILES`
if cp $FILES /cygdrive/r/CopyFile1/$FILES; then
echo "copy... (5 Replies)
I have this segment of code :
cmd = "finger -m " $1 " 2>/dev/null | head -1"
cmd | getline userinfo
close(cmd)
Sometimes finger returns no such user when given a user id.
With the redirection to the default trash file i am getting rid of any screen "finger:no such user" messages.
I also want... (2 Replies)
Hi,
I need your guys help again. I run a script which check for some process status in a loop. when i check the process some of the process could throw an error, how can i check that inside my script.
Thanks,
RR (3 Replies)
I am writing a wrapper to one of the .ksh script. The wrapper script should capture the error/fatal(if any) and exit out of the script. Here is the script:
#!/bin/sh
. main_script.ksh <arg1> <arg2> > mainscript.log 2>&1
cnt=`grep 'ERROR' -c mainscript.log`
if ; then
echo "Error"
... (6 Replies)
I have a PERL command line embedded in a UNIX script. The script doesn't handle errors coming out of this command. I'm processing large files and occassionally I run out of disk space and end up with half a file.
perl -p -e 's/\n/\r\n/g' < TR_TMP_$4 > $4
How do I handle errors coming out... (1 Reply)
Good Day Everyone,
I was hoping to get a little insight into an expect script that I've written.
Basically we have this expect script to perform an sftp upload, key authentication is not an option, and sftp is the only method supported by our vendor, thus the need for this.
I want to be... (3 Replies)
Hello fellow UNIX gurus :)
I have a problem regarding the script below:
# Variables used in this shell.
power=0 # Stores squared integer
total=0 # Sum of all squared integers
num=0 # Stores command line arguements
# Provides error handling if command line... (5 Replies)
Hi Guys,
I got a csv with pipe delimted file and i want to check second column of the file has any alpha character becuase I am expecting only number in that,
and if any alpha characters then it should throw an error
Thanks in advance (1 Reply)
Discussion started by: Rizzu155
1 Replies
LEARN ABOUT MOJAVE
locale::codes::langext5.18
Locale::Codes::LangExt(3pm) Perl Programmers Reference Guide Locale::Codes::LangExt(3pm)NAME
Locale::Codes::LangExt - standard codes for language extension identification
SYNOPSIS
use Locale::Codes::LangExt;
$lext = code2langext('acm'); # $lext gets 'Mesopotamian Arabic'
$code = langext2code('Mesopotamian Arabic'); # $code gets 'acm'
@codes = all_langext_codes();
@names = all_langext_names();
DESCRIPTION
The "Locale::Codes::LangExt" module provides access to standard codes used for identifying language extensions, such as those as defined in
the IANA language registry.
Most of the routines take an optional additional argument which specifies the code set to use. If not specified, the default IANA language
registry codes will be used.
SUPPORTED CODE SETS
There are several different code sets you can use for identifying language extensions. A code set may be specified using either a name, or
a constant that is automatically exported by this module.
For example, the two are equivalent:
$lext = code2langext('acm','alpha');
$lext = code2langext('acm',LOCALE_LANGEXT_ALPHA);
The codesets currently supported are:
alpha
This is the set of three-letter (lowercase) codes from the IANA language registry, such as 'acm' for Mesopotamian Arabic.
This is the default code set.
ROUTINES
code2langext ( CODE [,CODESET] )
langext2code ( NAME [,CODESET] )
langext_code2code ( CODE ,CODESET ,CODESET2 )
all_langext_codes ( [CODESET] )
all_langext_names ( [CODESET] )
Locale::Codes::LangExt::rename_langext ( CODE ,NEW_NAME [,CODESET] )
Locale::Codes::LangExt::add_langext ( CODE ,NAME [,CODESET] )
Locale::Codes::LangExt::delete_langext ( CODE [,CODESET] )
Locale::Codes::LangExt::add_langext_alias ( NAME ,NEW_NAME )
Locale::Codes::LangExt::delete_langext_alias ( NAME )
Locale::Codes::LangExt::rename_langext_code ( CODE ,NEW_CODE [,CODESET] )
Locale::Codes::LangExt::add_langext_code_alias ( CODE ,NEW_CODE [,CODESET] )
Locale::Codes::LangExt::delete_langext_code_alias ( CODE [,CODESET] )
These routines are all documented in the Locale::Codes::API man page.
SEE ALSO
Locale::Codes
The Locale-Codes distribution.
Locale::Codes::API
The list of functions supported by this module.
http://www.iana.org/assignments/language-subtag-registry
The IANA language subtag registry.
AUTHOR
See Locale::Codes for full author history.
Currently maintained by Sullivan Beck (sbeck@cpan.org).
COPYRIGHT
Copyright (c) 2011-2013 Sullivan Beck
This module is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.18.2 2013-11-04 Locale::Codes::LangExt(3pm)
02-15-2012
