Ispirer Website Ispirer Capabilities - Informix Migration Free Trial

Informix - Returning Information as Result Set (Dummy Tables)

In Informix, you have to specify the FROM clause in SELECT statements. In order to return the value from a function, expression as a single row result set, you can use SELECT … FROM systables WHERE tabid=1 that is guaranteed to return 1 row.

Example (Informix):

SELECT CURRENT FROM systables WHERE tabid=1;

This query returns the current date and time as a result set.

Dummy Tables - Differences between Informix and other Databases

Database Returning Result Sets
Oracle SELECT … FROM dual
SQL Server SQL Server SELECT - SELECT without FROM is allowed (no dummy tables required)

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.