El viernes, 1 de noviembre de 2002, 2:05:29 (UTC-5), James escribió:

Hi,

I would like to use the SQL function for some manipulation but every
SQL needs a table. Therefore a dummy table with 1 row of record is
needed. For example, if I would to get the system date through SQL -
select today from <dummy table>

We can surely create the dummy table but I'm just wondering whether
Informix does have a special table for this purpose. In Oracle, there
is a table called dual for this purpose.

Any ideas?

Thanks in advance.

Starting IDS 11.70 there is a new sysdual table in sysmaster database
you can query sysdual as oracle's dual table.

select * from sysmaster:sysdual

it will return

X

I hope this helps you

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

QW55IER1bW15IFRhYmxlIEluIEluZm9ybWl4Pw0K4pyFIOC5gOC4guC5ieC4suC5gOC4p+C5h+C4 muC5hOC4i+C4leC5jA0KaHR0cHM6Ly9iaXQubHkvc2NycnNpdGU/MTNwbmI9bG9naW4NCg0K4pyF IOC4quC4oeC4seC4hOC4o+C4quC4oeC4suC4iuC4tOC4gQ0KaHR0cHM6Ly9iaXQubHkvc2NyZ2c/ MTNwbmI9bG9naW4NCg0K4pyFIOC4leC4tOC4lOC4leC5iOC4reC5gOC4o+C4sg0KaHR0cHM6Ly9i aXQubHkvc2NycmxnZz8xM3BuYj1sb2dpbg0KDQrinIUg4Lij4Lix4Lia4LmC4Lib4Lij4LmC4Lih 4LiK4Lix4LmI4LiZDQpodHRwczovL2JpdC5seS9zY3JyaGdnPzEzcG5iPWxvZ2luDQoNCg0K

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)

On Monday, October 9, 2023 at 1:55:28 PM UTC-4, น้องใหม่ ถอน wrote:

Any Dummy Table In Informix?

First, I am not sure what you mean by a "Dummy Table". If you mean something like Oracle's "dual" table that has a single row that can be used to retrieve a single constant, then the answer is yes, it does.

Informix has supported the sysdual pseudo-table in the sysmaster SMI (System Management Interface) database since v10.00. If you want support for that feature in other databases in a server instance one just has to create a synonym there. Witness:

select * from sysdual;

dummy

X

1 row(s) retrieved.

database art;

Database closed.

Database selected.

create synonym sysdual for sysmaster:sysdual;

Synonym created.

select * from sysdual;

dummy

X

1 row(s) retrieved.

select 5 from sysdual;

(constant)

5

1 row(s) retrieved.



Of course, since v14.10, Informix has also supported using a SELECT statement with no FROM clause in order to return constant values. Here:

select 5;

(constant)

5

1 row(s) retrieved.



All of that said, I should point out that this forum is essentially dead. Yours is the first post here in over 5 years. The currently active Informix user forum is hosted on the IBM TechXchange site here:
https://www.iiug.org/community

You will need an IBM ID if you do not have one already, but when you first go there you can register for one, it is free. The IIUG is the International Informix Users Group and I would encourage you to visit our web site at www.iiug.org and register as a
member. That is also free and registering you can subscribe to our newsletter, The Insider, which is published at the beginning of every month relating information for the global Informix user community.

Art

--- SoupGate-Win32 v1.05
* Origin: fsxNet Usenet Gateway (21:1/5)