SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB2 set current schema = <schema>

899261Nov 9 2011 — edited Nov 9 2011

Hallo,

i'm connecting with SQL-Developer 3.0.04 to DB2-Databases.

DB2 uses a SET-command to set schema.
Syntax: "SET CURRENT SCHEMA = <schema>".

SQL-Developer is filtering that valid SQL-Command (in DB2) because it looks like an Oracle SQL*plus-command.

Is ther any way to deactive that filtering while connecting to other DBMS than Oracle?
Or is anyone knowning an alternative way to setting schema in DB2-connections by using SQL-Developer?

Thanks for your help
Harry

Edited by: 896258 on 09-Nov-2011 06:43

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 7 2011

Added on Nov 9 2011

#schema, #sql-developer

2 comments

3,459 views