Re: create database in shell script

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. -- Jason Foster-Bey, WQ3J (jasonfb@panix.com) Programmer Analyst (formerly Senior Technical Support Analyst) National Multiple Sclerosis Society New York, NY 10017