Exception Handling

bertpereira · #1 (**permalink**) 05-24-2007

Hi,

I have written a script to load csv files into a mysql database, however, i would like for the shell script to exit in the event of an error (missing file, load error etc.) - currently if an error is encountered the next statement is processed - This is how i am loading the csv scripts

export id=root
export db=testcsv
export db_add=localhost

mysql -h$db_add -u$id -D$db <loadA.sql

Thanks in advance

Bert

aigles · #2 (**permalink**) 05-24-2007

Try to use the 'set -e' command.
Extract from man page :

Quote:

-e If a command has a non-zero exit status, execute the ERR
trap, if set, and exit. This mode is disabled while reading profiles.

Code:

set -e
export id=root
export db=testcsv
export db_add=localhost

mysql -h$db_add -u$id -D$db <loadA.sql

Jean-Pierre.

bertpereira · #3 (**permalink**) 05-24-2007

Awesome!!!! - Is there a way i can GOTO a certain block if such an error is trapped?? - for instance once the error is encountered GOTO cleanup-script block??

aigles · #4 (**permalink**) 05-24-2007

You can use the trap command :

Code:

cleanup_script()
{
   echo "Cleaning ..."
}
trap 'cleanup_script' ERR
set -e

export id=root
export db=testcsv
export db_add=localhost

mysql -h$db_add -u$id -D$db <loadA.sql

Jean-Pierre.

bertpereira · #5 (**permalink**) 05-24-2007

Thanks Man - Brilliant

kany2k · #6 (**permalink**) 01-14-2009

Hi Aigles,

I also have similar requirement as in this chain, i have written the shell script to execute a COBOL program which loads the data into Peoplesoft tables. If for some reason if the data load fails which means if the COBOL program fails i want the script to be errored and should be proceed with the rest of the process. Can i get some sample script of this type or any help is highly appreciated.

Kannan

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
MMU exception	Puntino	Linux	2	05-07-2008 12:35 PM
Help with RPC Exception	ejbrever	HP-UX	2	08-24-2006 02:08 PM
RPC Exception - Help	ejbrever	UNIX for Advanced & Expert Users	0	08-21-2006 12:56 PM
Linux g++ 2.95.3 exception handling	earl	High Level Programming	0	08-16-2005 01:46 PM
exception handling	RichardS	UNIX for Advanced & Expert Users	1	06-16-2004 05:29 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: