Code assist does not work for Informix cross-db queries

This is more a feature request than a bug, but it would be very useful to have. To recreate, you need an instance of Informix with two databases, e.g. db1 and db2. Create a table in the first database (db1), e.g.: CREATE TABLE test (id_col INTEGER); In SQL commander, select the second database (db2), and it is possible to query the above table by writing: SELECT * FROM db1:test; In this query, code assist (ctrl+space) does not offer a list of columns when the cursor is positioned just before "*" , as it does with tables within the same database. Also, code assist should show a list of tables in db1 database when positioned just after the ":" in the statement. Both these features work in MySQL, which uses a dot to separate database and table name in the query (e.g. SELECT * FROM db1.test) instead of the colon which is used in the Informix query.

Hi Ivan, I have opened as ticket for this, but I can't promise it will be fixed during the EA period before the next feature release. Best Regards, Hans

That's OK. Just so that you have it on record and fix it when you have the time. Regards, Ivan

Hi Ivan, Just wanted to tell you that this is now fixed in the just released 9.0 version: http://www.dbvis.com/doc/relnotes/?version=9.0 Best Regards, Hans