DB2 Column Description!!

nareshkareti · New User Joined: 22 Jul 2008 Posts: 33 Location: Chennai

Is there way that we can find the description of a column of a DB2 Table..
For Example There is a table Customer with a column of CT_AD_DT.

Is there any tool/place in Mainframe/DB2 where the column expansions/description will be maintained.

Here CT_AD_DT means Customer Add Date (I need to know if similar descriptions are maintained in DB2?)

sushanth bobby · Posted: Wed Aug 10, 2011 2:16 pm

Hi Naresh,

In SYSIBM.SYSCOLUMNS, there is column called REMARKS, you can check that, but there is only little chance you will find data there.

But best way will be to ask your lead or someone from that team.

Thanks,
Sushanth

vasanthz · Posted: Wed Aug 10, 2011 2:41 pm

LABEL Column of SYSIBM.COLUMNS also may contain some description along with REMARKS.

Prasanthhere · Active User Joined: 03 Aug 2005 Posts: 306

If you have a data architects team in your site, they will be maintaining the data models and repository . If they are maintaing and updating the repository you should be having the info .

All are site specific and depends on how often they update or maintain these. If you have a changeman installed in your Z/OS and once you enter ,there should be an option repository. Try your luck .

This remains the same with the REMARKS column in SYSIBM.SYSCOLUMNS.If you have maintained through Comment statement you should have an entry else blank