How to obtain the schema from a JDBC Connection ?

apattin

Hi all,

Does anyone know how to get the schema name given a JDBC Connection
object? I see that I can do "toString" and pick the "User=" substring,
but smells of a hack. :)

Thanks,

Alejandrina

Mar 31 '06 #1

Knut Stolze

apattin wrote:

Hi all,

Does anyone know how to get the schema name given a JDBC Connection
object? I see that I can do "toString" and pick the "User=" substring,
but smells of a hack. :)

Query the CURRENT SCHEMA special register.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Apr 3 '06 #2

apattin

Thanks! I can do that.

Alejandrina

Apr 3 '06 #3