Maybe to the OP - things like this are extensions to a particular flavor
of RDBMS. Dan is speaking of the actual Java code to accomplish.
I think JDBCR4 is open source - a person could add such a feature
easily, I think.
OTOH, isn't the default schema an attribute you can set on the JDBC
connection string? Just wondering.
On 2/4/2013 4:44 PM, James H. H. Lampert wrote:
On 2/4/13 10:34 AM, Dan Kimmel wrote:
JDBC abstracts away this kind of difference between underlying
Except that as of yet, JDBCR4 doesn't appear to have an RPG-callable
databases. Use (Connection)con.setSchema(String schemaName) rather
than trying to work out which database engine you are using. Don't
use the "SET SCHEMA" or "USE " statements. Let the driver work out
what is the appropriate statement.
front-end for setSchema. At least, not that I can see in a DSPSRVPGM or
in the source member.