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

Column names in SYSIBM tables


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

New User


Joined: 09 Dec 2020
Posts: 8
Location: India

PostPosted: Fri Jan 22, 2021 3:20 pm
Reply with quote

Hi,
Is there is any quick way to cross check the SYSIBM tables (Column names). Apart from [https://www.ibm.com/support/knowledgecenter]
Asking this for JOIN query creation with some conditions. I need to know where (in which tables) certain columns are present.

For example, If I Input a specific column name, It should display all the relevant table names where it is present. Something like that..


Thanks in advance.
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 967
Location: Maryland

PostPosted: Fri Jan 22, 2021 6:32 pm
Reply with quote

1. RTFM - there are plenty of them
2. An example like this
DB2 Joining SYSIBM Tables
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Jan 22, 2021 6:33 pm
Reply with quote

SYSIBM.SYSCOLUMNS?
Back to top
View user's profile Send private message
inforajesh

New User


Joined: 09 Dec 2020
Posts: 8
Location: India

PostPosted: Fri Jan 22, 2021 8:01 pm
Reply with quote

Nic Clouston wrote:
SYSIBM.SYSCOLUMNS?


Thank you.
Back to top
View user's profile Send private message
inforajesh

New User


Joined: 09 Dec 2020
Posts: 8
Location: India

PostPosted: Fri Jan 22, 2021 8:01 pm
Reply with quote

sergeyken wrote:
1. RTFM - there are plenty of them
2. An example like this
DB2 Joining SYSIBM Tables



Thank you
Back to top
View user's profile Send private message
sergeyken

Active Member


Joined: 29 Apr 2008
Posts: 967
Location: Maryland

PostPosted: Fri Jan 22, 2021 8:03 pm
Reply with quote

inforajesh wrote:
sergeyken wrote:
1. RTFM - there are plenty of them
2. An example like this
DB2 Joining SYSIBM Tables



Thank you

Google bless you!
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 Can we Insert duplicates in Primary U... DB2 2
No new posts COnvert a column with mix of hex ,cha... DB2 5
No new posts insert into session tables with UR DB2 0
No new posts Sync logic between VSAM files and DB2... COBOL Programming 9
No new posts Fetch the Dataset names from inside m... TSO/ISPF 18
Search our Forums:

Back to Top