Re: How to get DB Server Date and TIme ?
At 12:38 AM 2/12/99 , Obnoxio The Clown wrote:
>>Frank wrote in message <79oavq$d44$1@camel19.mindspring.com>...
>>
>>Adding 2 bits:
>>
>>>select CURRENT from <tablename>>>
>>select unique current ...
>>or have a WHERE that guarantees only 1 value returned. My favorite:
>>select .... from systables where tabname = "systables">
>Adding _one_ bit:
>
>I would have thought
>
>WHERE tabid=1
>
>was marginally more efficient. ;-)
>
But it also trusts Informix to always have a table with tabid=1, which to
me is like trusting Informix to always support ROWID. I've never seen any
documentation that guarantees the tabid values of the system table (never
even seen any that guarantees they stay below 99), so if I can avoid it
I'll not trust it.
A systable named "systable" is documented.
My reasons may be loopy, but I always have one ...
//////////////// =======================================================
////////// // Dennis J. Pimple Informix Software, Inc.
////// / /// Principal Consultant 6300 S Syracuse Way Ste 205
///// // //// dennisp@informix.com Englewood CO 80111
//// // /////
/// // ////// recept: 303-850-0210
// // /////// direct: 303-740-5611 Opinions expressed are mine,
/ /////////// fax: 303-779-4025 and do not necessarily
//////////////// http://www.informix.com reflect those of my employer
For Informix Databeses replace
select unique current
by
select distinct current
----For SE Databeases instead of OnLine
you can use just any existing database and table,
you may create it before and drop it then
or you may user stores7.
Dennis Pimple wrote:
> At 12:38 AM 2/12/99 , Obnoxio The Clown wrote:
> >>Frank wrote in message <79oavq$d44$1@camel19.mindspring.com>...
> >>
> >>Adding 2 bits:
> >>
> >>>select CURRENT from <tablename>> >>
> >>select unique current ...
> >>or have a WHERE that guarantees only 1 value returned. My favorite:
> >>select .... from systables where tabname = "systables"> >
> >Adding _one_ bit:
> >
> >I would have thought
> >
> >WHERE tabid=1
> >
> >was marginally more efficient. ;-)
> >
>
> But it also trusts Informix to always have a table with tabid=1, which to
> me is like trusting Informix to always support ROWID. I've never seen any
> documentation that guarantees the tabid values of the system table (never
> even seen any that guarantees they stay below 99), so if I can avoid it
> I'll not trust it.
>
> A systable named "systable" is documented.
>
> My reasons may be loopy, but I always have one ...
>
> //////////////// =======================================================
> ////////// // Dennis J. Pimple Informix Software, Inc.
> ////// / /// Principal Consultant 6300 S Syracuse Way Ste 205
> ///// // //// dennisp@informix.com Englewood CO 80111
> //// // /////
> /// // ////// recept: 303-850-0210
> // // /////// direct: 303-740-5611 Opinions expressed are mine,
> / /////////// fax: 303-779-4025 and do not necessarily
> //////////////// http://www.informix.com reflect those of my employer
--
Mit freundlichen Grüßen / with best regards :-)
-\\|/-
)ø^o(
+=========oOOo==(_)==oOOo=======Mail-Client: Netscape V4.5==+
| Ernst Sauerwein Siemens ITService GmbH & Co. oHG|
| =============== ISC-D 144 |
| Microsoft Certified OLTP-Systems |
| Professional INFORMIX® Database Support |
| Tel: +49 89 3601 2699 Area South Europe |
| FAX: +49 89 3601 2402 Berliner Str.95,III/C190-193 |
| NERV: mailto:sauerwein.muc@sni.de |
| EMAIL: mailto:ernst.sauerwein@mch.siemens.de |
| EMAIL: mailto:ernsts@informix.com |
| FTP: ftp://ftp.mch.sni.de/ (external) |
| ftp://MB184060.mch.sni.de/ (internal) |
| WWW: http://its.mch.sni.de/ (external) |
| http://MB184060.mch.sni.de/ (internal) |
+===========================================================+