Unanswered: Changing default schema for user with JDBC
I'd like to know if it is possible to change default schema using jdbc driver options. We've got legacy java application that connect to DB2 with different user name with different rights for various purposes. While we used JDBC:ODBC driver on NT, we could set CURRENT SQLID variable. With pure JDBC on Linux we can't do that.
We also can't rewrite appplication and add SET CURRENT SCHEMA clause.
I saw some jdbc drivers for DB2 for platform other than Linux which have "sqlid=newschemaname;" option, but our driver doesn't have such option (or I missed it).
Can you advise me right way to use that option?