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

Don't use "isql" use "dbload". It's a little more complicated, but it filters out bad rows and loads just the good rows. Tony! wrote: > > 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...... > > -Tony- > > > > -- Colin McGrath cmm@trac3000.ueci.com Washington Group International, Inc. (215) 422-4144 Philadelphia, PA, USA Any opinions I state are my own and not necessarily those of my employer