IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Retrieve list of column name for a particular table name.


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
samedesh
Currently Banned

New User


Joined: 22 May 2007
Posts: 46
Location: India

PostPosted: Mon Oct 05, 2009 3:17 pm
Reply with quote

Hello All,

How can we get the list of column name for a particular table. Actually I am accepting table name as an input and I want to display column name.
For this I have written rexx code and panel code also but I am unable to find the list of columns for a particular table. Please help.
Back to top
View user's profile Send private message
Srihari Gonugunta

Active User


Joined: 14 Sep 2007
Posts: 295
Location: Singapore

PostPosted: Mon Oct 05, 2009 3:31 pm
Reply with quote

Sameer,
Check SYSIBM.SYSCOLUMNS
Back to top
View user's profile Send private message
samedesh
Currently Banned

New User


Joined: 22 May 2007
Posts: 46
Location: India

PostPosted: Mon Oct 05, 2009 3:38 pm
Reply with quote

Hi srihari,

Gr8 thanks.. It worked... I had a looked but missed this...
Thanks once again..
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Load new table with Old unload - DB2 DB2 6
No new posts Pulling a fixed number of records fro... DB2 2
No new posts How to load to DB2 with column level ... DB2 6
No new posts RC query -Time column CA Products 3
No new posts How to create a list of SAR jobs with... CA Products 3
Search our Forums:

Back to Top