Getting the database name of a given table?

Posted in 2010

David N. Heydon — Fri, 19 Mar 2010 11:40:05 -0000 — source: Usenet: comp.databases.informix

Hi All. If I have a piece of SQL like:- SELECT some_cols FROM DB1:atable UNION SELECT some_cols FROM DB2:atable UNION SELECT some_cols FROM DB3:atable How can I also return as a column the database the row matches so I can differentiate between DB1, DB2 and DB3 in the above example? I've tried a few things but no success so far. Any inspiration appreciated! TIA. David