CODEWITHSUNDEEP
schemadb2oracle-sqldeveloper
Frantumn
Frantumn

Reputation: 1764

DB2 in Oracle SQL Developer - Default Schema

When connecting to a DB2 database with Oracle SQL Developer, is there a way to specify my schema in the connection properties so that I'm always aimed where I want to be?

Upvotes: 1

Views: 5135

Answers (1)

bhamby
bhamby

Reputation: 15469

I don't know how Oracle SQL Developer works, but at least the JDBC driver for DB2 has the option to specify the schema in the connection string, like:

jdbc:db2://server:50000/MYDB:currentSchema=MySchema;

If you can manually change the connection string that OSD is using, then perhaps you can add that option in.

Upvotes: 5

Related Questions