Re: create database in shell script

>From: Gary Broughton <garybro@ozemail.com.au> >Subject: Re: create database in shell script >Date: 15 Jan 1995 23:41:45 GMT >X-Informix-List-Id: <news.10823> >jasonfb@panix.com (Jason Foster-Bey) wrote: > >A better way to do this is: > >cat <<EOF > tmp.sql > >create database $1 with log ansi; > >EOF > >This way, you can check the exit status in $? upon completion. Otherwise, you > >will always get a 1 for the exit status. >I found that the exit status of various releases of isql is unreliable. The exit status of ISQL is either unreliable (variable but not significant) or gives no information as it is always zero (successful), depending on version. Also, it does not stop when an error occurs, so you can't try a transaction and have it rolled back if it fails and committed if it succeeds. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h>