Select info from all databases

[cymerman]

Hi All,

I have an old version of informix.
I do have 8 different databases in the same system. The table structure is all the same across the system.
How do I select info from one particular table in all the different databases ?
I know that in SQL Server you can do something like:


SELECT * FROM TABLENAMEall

Thanks

 

[mberni]

Hi,

you can give the database with the select:

select * from database1:mytable
union all
select * from database2:mytable
union all
select * from database3:mytable