Howdy:
Trying to connect to DB2 v. 6.1.2 from command line client
(CLP) version 5.2.
I need two things:
1) What is the name of the table that has the comments for all tables and columns?
I'm sure it is a system table, but I don't know what it could be. Is it
sysibm.syscolumns?
2) I want to select the table, columns and the comments for each; how
do I do that? I can get table and some other useful information:
[snip]
select
name,
tbname,
tbcreator,
colno,
coltype
from sysibm.syscolumns
where tbname = '<whatever>';
[/snip]
So, how do I incorporate the column / table comments in
this?
Thanks!
-X
