Re: Question about NULL's - no-MIME version

From: Tony! <NoSpam@Thank.You.com> > >I have a table created on Informix Dynamic Server Version 7.30.UC8. > >I have three fields with a unique index. > >I created a aix shell script that creates an .sql files then does a >isql < filename.sql. Amongst other things, it inserts new rows into >the table. > >I want it to attempt an insert each time the script is ran in case >there are any new items to be inserted into the database. > >Is the anyway to not show the "Cannot add due to not unique" type >message echoed to the screen? > >Not a big deal all all but just wondering...... isql dbname filename 2> /dev/null or isql < filename.sql 2> /dev/null ? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. Share information about yourself, create your own public profile at http://profiles.msn.com.