Re: SQL emergency question

Just to refresh and say thanks for the help and also to add a bit: Since we're using this database with BaaN, there is another piece to the pie - you have to run session ttaad4225m000 (Reorganize Tables) to rebuild the hash columns that the BaaN indexes are built from or it breaks because it thinks the data in the row is bad. It's a shame how BaaN gets rid of all the cool functionality of Informix, but it does have it's own slow ways of accomplishing its tasks. Just in case anyone runs into something similar in the future. Also, make sure no-one is in the same BaaN company while you're running this session - it doesn't seem to exclusively lock the table and can corrupt stuff if people are in it. :) On Wed, 23 Jun 1999, Mark D. Stock wrote: > Then just to be flash, how about something like: > > OUTPUT TO PIPE "dbaccess my_database" WITHOUT HEADINGS > select "update " || tabname || " set " || > colname || " = '06/21/1999' > where " || colname || " = '07/14/2019';" > from systables, syscolumns > where systables.tabid = syscolumns.tabid > and systables.tabid > 99 > and coltype IN (7, 263) > > to do it in one shot. > > Cheers, > -- Jon<*>