Easy Q: Dummy table?
Posted in 1997
Chad Chervitz — — source: Informix-list mailing list archive (1991-1998)
I have a need to print CURRENT variables from within a simple SQL file
being piped to dbaccess. It is so that I can surround a SQL
statement with two datetime selects to trace how long the SQL
statement took to run.
Is there a way just to "select CURRENT" so that it gets output along with
the SQL results?
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).
Thanks,
Chad