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

i using dbartisan 9.6.0 accessing ibm db2 database. when entering sql query, dbartisan forces me prefix schema name explicitly before every table name.

i set default schema, searching dbartisan user guide "default schema" no longer returns results (in older db2 versions did)

i know there must way this. suggestions?

don't know dbartisan, can db2-way.

either using parameter currentschema in connection string, e.g. (java example):

jdbc:db2://localhost:50000/mydb:currentschema=myschema; 

or in sql using set current schema before other commands:

set current schema myschema; select * mytable;