Re: How to get DB Server Date and TIme ?

Posted in 1999

David Coburn — Sat, 13 Feb 1999 10:57:05 -0800 — source: Informix-list mailing list archive (1991-1998)

Well, if memory serves Dennis actually said select current from systables where tabname = 'systables' Remember that there is no guarantee of some tabid of 1, but there is a guarantee of a table named systables. David Andreas Asuja <andreas.asuja@iki.fi> on 02/13/99 07:39:52 AM Please respond to Andreas Asuja <andreas.asuja@iki.fi> To: informix-list@iiug.org cc: (bcc: David Coburn/ISG/WVUS/WorldVision) Subject: Re: How to get DB Server Date and TIme ? Frank wrote: > select CURRENT from <tablename> This kinda programming could lead you into trouble if you do this on a big table: The statement goes through every row. (Yeah, done it myself...) ;) As Dennis Pimple wrote, SELECT CURRENT FROM systables WHERE tabid=1; would be the most efficient way of doing this! That's because I assume that systables would reside in the memory all the time!? Cheers, Andreas -- Andreas 'Antti' Asuja - andreas.asuja@iki.fi