Is there a way to set a proper library list for Run SQL Scrips in i Access Client Solutions?
I found the JDBC Configuration manager, in which you can edit configurations, and within each configuration to can specify a schema list. The tooltip says it's a comma or space separated list of library names used for resolving unqualified names. So I input a few libraries into it and reconnect using that configuration. But when I run SQL with unqualified table names it only seems to look in the first library, not all of them.
E.g say that FILE1 is in LIB2. If I specify LIB1,LIB2,LIB3 and then do "select * from FILE1", I get an error saying FILE1 in LIB1 not found
On the Special Registers tab the CURRENT PATH entry lists all my libraries, but the next line, CURRENT SCHEMA, lists only the first library.
Any advice?
I found the JDBC Configuration manager, in which you can edit configurations, and within each configuration to can specify a schema list. The tooltip says it's a comma or space separated list of library names used for resolving unqualified names. So I input a few libraries into it and reconnect using that configuration. But when I run SQL with unqualified table names it only seems to look in the first library, not all of them.
E.g say that FILE1 is in LIB2. If I specify LIB1,LIB2,LIB3 and then do "select * from FILE1", I get an error saying FILE1 in LIB1 not found
On the Special Registers tab the CURRENT PATH entry lists all my libraries, but the next line, CURRENT SCHEMA, lists only the first library.
Any advice?
Comment