Library list for JDBC

[Guest.Visitor]

I have read Don's short article about this topic (NetJava Expert August/Sept 1999, p.7). Unfortunately Don only gave one user library as an example. If you have tables in more than one libraries, you have to qualify the tables with library name. Our applications often access tables in more than one libraries in one single SQL statement. It would be ideal if I can just use the table names without qualifying with a library name in my SQL statements. Does anybody out there have ways to achieve this?

[Guest.Visitor]

You can add as many libraries as you want, separated by commas, in the getConnection method. If you are using tables from different libraries, you should add all the libraries you will need. You can also use *LIBL, which will use the library list for the user you refer to in the getConnection method. You should be able to resolve any library list issues that you would normally have on the AS/400 in the getConnection method.