How to find currentSchema from JDBC application

[Pete Geraghty]

I want to use DatabaseMetadat a to retrieve details of those stored procedures which belong to the current schema. How can I find out what is the current schema for an existing Connection?

Or alternatively is there any special syntax in the getProcedures method to limit the results to procedures belonging to the current schema?

Is there any clear documentation about the interpretation to be given to catalog and schema in DB2's JDBC implementation?

Thanks.

Pete

[skchonghk]

Execute "values current schema" SQL statement with the connection. The resultset will have the current schema.