CODEWITHSUNDEEP
db2database-connectiondbartisan
Victor Grazi
Victor Grazi

Reputation: 16490

How can I set up a default DB2 schema In DBArtisan 9.6

I am using DBArtisan 9.6.0 for accessing an IBM DB2 database. When entering a SQL query, DBArtisan forces me to prefix the schema name explicitly before every table name.

I would like to set up a default schema, but searching the DBArtisan user guide for "default schema" no longer returns any results (in older DB2 versions it did)

I know there must be a way to do this. Any suggestions?

Upvotes: 2

Views: 1668

Answers (1)

Uooo
Uooo

Reputation: 6334

Don't know about dbartisan, but you can do it the DB2-way.

Either using the parameter currentSchema in the connection String, e.g. (Java example):

jdbc:db2://localhost:50000/MYDB:currentSchema=MYSCHEMA;

Or in your SQL using set current schema before your other commands:

set current schema MYSCHEMA;
select * from MYTABLE;

Upvotes: 2

Related Questions