Hey all,

I just upgraded and migrated a win2k server 7.2 udb to 8.1.
After also installing the Admin Client the set schema and set current schema appear to have no effect anymore (After executing the set schema and then executing an SQL statement it returns an error indicating that the schema is still set to the USER special register).

Is there a problem with set schema on 8.1? (I haven't put in any fixpacks yet)
Or is it handled dirrently?

Cheers.

Some slighly clearer information:

Set CURRENT schema works in the interactive window of 7.2 but does NOT seem to have any effect in the interactive window in 8

Any idead?

Maybe you need to apply at least fixpak 4

JR18599 DB2CLI.INI PARAMETERS SUCH AS CURRENTSCHEMA ARE LOST BY
COMMAND CENTER WHEN DISPLAYING RESULTS TO RESULTS PAGE

Ah right .. cool ... I am waiting on the CD media for the full Workgroup Server version, so I only have a trial of EE on there and so didn't bother with fixpacks yet.

CHEERS!