Solved

DB2 current schema

Posted on 2009-07-13
2
825 Views
Last Modified: 2012-06-27
If I have an instance of a JDBC DB2 connection, how do I get the current schema?

Either a SQL statement would work, or just a JDBC method call.
0
Comment
Question by:mbevilacqua
2 Comments
 
LVL 18

Accepted Solution

by:
daveslash earned 500 total points
ID: 24843887

This works for me ....
select current_schema  

from   sysibm.sysdummy1

;

Open in new window

0
 

Author Closing Comment

by:mbevilacqua
ID: 31603008
Ah, sysdummy1, i was using sysdummy. Cheers!
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Problem to insert 6 369
Find Value column 2 does not work 1 180
Define external data structure with free d specs in RPG 4 342
How would you as a DBA (DB2) answer this question? 9 74
Recursive SQL in UDB/LUW (you can use 'recursive' and 'SQL' in the same sentence) A growing number of database queries lend themselves to recursive solutions.  It's not always easy to spot when recursion is called for, especially for people una…
Recursive SQL in UDB/LUW (it really isn't that hard to do) Recursive SQL is most often used to convert columns to rows or rows to columns.  A previous article described the process of converting rows to columns.  This article will build off of th…
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

911 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now