Unanswered: use more than one database in the same sql query
Please is it possible in the same query to interogate rows in two différents databases? I said i have 2 databases and i want to be sure that with Informix Online 12 or less it is possible to write a sql query which would retrieve rows from both database in the same informix instance which have i suppose more than one database in the dbspace?
I'm pretty sure the syntax is <DB name>@<servername>:<DB owner> (in single quotes).<tablename> so please give this a try assuming ipo is your DB owner. You need a period between the DB owner & the table name, this syntax works with Informix OnLine 11 but I've never worked with 12.
select * from database1@onlinetcp_server1:'ipo'.tabela1, database2@onlinetcp_server2:'ipo'.tabela2