Hi All,

Can any one tell me the query to find the name of the database table.
I know the description of a column,but I dont know the data is in which column and which table.
How can I do this ....
I went through all the system defined tables but I could'nt trace out.

In oracle we can do the same I guess with the the system table called either usercolumns or user objects....I dont know perfectly...but we can do in oracle..

How can this be done in DB2 UDB..

Very Urgent...
Query Expected from all DB2 Gurus...

Thanks in Advance
Milind

Simple use the command:
db2 describe table sysibm.systables

The "name" and "creator" columns will link to the "tbname" and "tbcreator" columns of table sysibm.syscolumns.

"Query Expected from all DB2 Gurus... " !! EXPECTED?? What gives you the right to expect a response from anyone?

It was after re-reading that that I deleted the one I had written.

James Campbell

See the DB2 Catalog Tables in the appendix of SQL Reference Vol 1.