Re: Easy Q: Dummy table?

Posted in 1997

Gert Brinkmann — Wed, 22 Oct 1997 09:18:53 +0200 — source: Informix-list mailing list archive (1991-1998)

Chad Chervitz wrote: > IOW, I'm looking for the equivalent of a tableless > select in Sybase (i.e., select sysdate()) or a DUMMY table select in > Oracle (i.e., select to_date("MM-DD-YYY", now) from DUMMY). Hello, i think you mean a select like the following (example for the Universal Server, i do not know if the table and columnnames are the same in Online): select function_call() from systables where tabid=1; This leads to the same result as the above described dummy-table-selects. Ciao, Gert. -- Gert Brinkmann email: gbrinkmann@dimedis.de Software Development tel: 0221/921260-0 dimedis GmbH fax: -99 Habsburgerring 2-12 http://www.dimedis.de 50674 Koeln http://www.RealTimeImage.de