By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
437,586 Members | 2,418 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 437,586 IT Pros & Developers. It's quick & easy.

need sql queries for following

P: n/a
hi All,

I am writing a java application which queries DB2. I need SQL queries
for following :

1. Query to check whether, the attributes for LOB columns like BLOB and
CLOB is "LOGGED" or not?

2. Query for checking if tables are created under table space of
pagesize 32K or not?

This is really urgent and important..

Please help me..

-A

Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Ajay wrote:
hi All,

I am writing a java application which queries DB2. I need SQL queries
for following :

1. Query to check whether, the attributes for LOB columns like BLOB and
CLOB is "LOGGED" or not?

2. Query for checking if tables are created under table space of
pagesize 32K or not?


Homework or other exercise?

Have a look at the DB2 catalog views, namely SYSCAT.COLUMNS for your 1st
task and SYSCAT.TABLES and SYSCAT.TABLESPACES for the 2nd.

The manual can be found here:
http://publib.boulder.ibm.com/infoce...n/r0011297.htm

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Nov 12 '05 #2

P: n/a
Not a homework.. :)

New to DB2 area.. I tried with SYSCOLUMNS table but failed.

But SYSCAT.COLUMNS does not show if "LOGGED" is an attribute or not of
the specified column

Nov 12 '05 #3

P: n/a
ooops sorry for that.. :)

it does solve my issues.. & a lot other too..

See, we were trying to get database metadata using
connection.getmetadata() method.

Strangely, this is not a very stable method and fails intermittently
for DB2 only. (my aplication supports - db2, oracle, sql server). I
never looked/tried for getting this data using alternate methods for
DB2.

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.