SQL emergency question

Posted in 1999

-=Eclypse=- — 22 Jun 1999 15:49:54 GMT — source: Informix-list mailing list archive (1991-1998)

This past weekend we upgraded one of our RS/6000s and in the process the NVRAM on the box got corrupted. The date got changed to 7/14/2019 and went unnoticed until Monday morning. We run BaaN and Informix on the backend. Several transactions were processed before we caught the date error. We have approximately 80000 tables in our database and several of those have columns of type "DATE". What I need help with is the wording on an SQL statement to find any table with a column type of "DATE" with the value in that column equal to "07/14/2019" and change it to "06/21/1999" anywhere in the database. Any help is appreciated! -- Jon Freeland<*> Informix DBA Miller Industries, Inc. jon@millerind.com eclypse@babylon5.cdc.net