Re: schema dates

---- you wrote: > Is there a way to find the date of a schema? I have two different DB's > and they are both modified by outside users. In an attempt to create a > historical DB I have unloaded the contents of one DB but when I use the > current column settings with older unloaded data I get mismatches. Any > help on this would be appreciated Only ls -l Dude. AB ---------------------------------------------------------------- Get your free email from AltaVista at http://altavista.iname.com

In article <88ed9k$n9k$1@news.xmission.com>, a_blonde@mindless.com wrote: > > ---- you wrote: > > Is there a way to find the date of a schema? I have two different DB's > > and they are both modified by outside users. In an attempt to create a > > historical DB I have unloaded the contents of one DB but when I use the > > current column settings with older unloaded data I get mismatches. Any > > help on this would be appreciated > > Only ls -l Dude. > > AB I suspect what the original author is after is the date a specific schema change was made to a specific table. We use Server Studio for Informix (www.agsltd.com for downloadable eval) for many of our database admin tasks. This shows the date each table was last created/modified, so logic (?) dictates that this info must be in the system tables somewhere. Login also dictates that I know not in which system table this info resides. Over to the experts .... I have no connection with AGS Ltd other than being a satisfied customer (quick .. have him stuffed). Regards Mr Creosote -- "Just a waffer thin mint?" Sent via Deja.com http://www.deja.com/ Before you buy.