Hi!

I has a problem. I need set values on CURRENT SCHEMA and CURRENT PATH automatically for any connections to the database.

Can somebody help me if it is possible?

Thanks

P.S.
I can not execute SET CURRENT SCHEMA and SET CURRENT PATH after each
connection. I need something like trigger!

default schema (or default sql id) is always the userid. Thats it.
To change it after connecting you have to set it.

Whats wrong that you can't do it ?
What application interface are you using?

In ODBC there is an option to set the CURRENT SCHEMA or CURRENT SQL ID as an parameter under advanced settings in your Configuration Assistant/ODBC data source manager/db2cli.ini .

Also: specifying fully qualified table names in your application might help.

Thanks a lot

I am using ODBC