#1435 Current schema / Code Completion

[Claus]

Below of Result Schema is a (new?) Info:
Current schema: "Schemaname" (refreshbuton) (selectbutton) - see Picture CurrentSchema.png

This seems to be default to my Username I connect to DB.
If I enter

set current schema abc;
set schema abc;

It won't change - therefore i guess - i have sometimes problems using code suggestions.

Additional: Even if i select the correct current schema, I see always all schemas while using CTRL-SPACE for code completion - see codecompletion.png

[Claus]

I should add I currently use a System i 7.3 (AS400)

[Gerd Wagner]

It is true that the schema panel does not automatically refresh on
"set schema ..." or "set current schema ...".

Generally code completion is aware of schemas only when schema qualified names are used.

The completion popup is meant to show catalogs and schemas only when tables with the same name occur in different schemas. E.g. from your codecompletion.png I'd guess that a table C1BAB1AA exists in all the schemas the PNG shows.
On the AS400 / DB2 system I have access to this works as expected. So I'm sorry I can't reproduce your problem.

For your information, I'm using:

• "DB2 UDB for AS/400" version "07.04.0000 V7R4m0"
• JDBC driver "AS/400 Toolbox for Java JDBC Driver" version 11.8