Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

DB2 Column Description!!

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
nareshkareti

New User


Joined: 22 Jul 2008
Posts: 33
Location: Chennai

PostPosted: Wed Aug 10, 2011 1:49 pm    Post subject: DB2 Column Description!!
Reply with quote

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?)
Back to top
View user's profile Send private message

sushanth bobby

Senior Member


Joined: 29 Jul 2008
Posts: 1013
Location: India

PostPosted: Wed Aug 10, 2011 2:16 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
vasanthz

Global Moderator


Joined: 28 Aug 2007
Posts: 1506
Location: Chennai

PostPosted: Wed Aug 10, 2011 2:41 pm    Post subject:
Reply with quote

LABEL Column of SYSIBM.COLUMNS also may contain some description along with REMARKS.
Quote:
But best way will be to ask your lead or someone from that team.
Seconded.
Back to top
View user's profile Send private message
Prasanthhere

Active User


Joined: 03 Aug 2005
Posts: 306

PostPosted: Wed Aug 10, 2011 3:14 pm    Post subject:
Reply with quote

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
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Loading data to table gives wrong for... Raghu navaikulam DB2 19 Thu Jul 13, 2017 2:11 pm
This topic is locked: you cannot edit posts or make replies. DB2 query Using Recursion, Converting... smilewithashu2 DB2 3 Tue Jan 03, 2017 12:50 pm
No new posts TWS EQQYCAIN - not sure how to get ap... mbenaud IBM Tools 0 Wed Dec 14, 2016 8:45 pm
No new posts SQZ pipe delimited file with 1 column... Rick Silvers DFSORT/ICETOOL 6 Sun Nov 06, 2016 8:11 pm
This topic is locked: you cannot edit posts or make replies. Checking wether a string starts from ... sundaram.naveen CLIST & REXX 9 Thu Oct 06, 2016 11:56 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us