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: 15
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
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1188

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: 15
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: 15
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
Warnings : 2

Senior Member


Joined: 29 Apr 2008
Posts: 1188

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 SORT HELP - SORT A COLUMN and GROUP B... DFSORT/ICETOOL 9
No new posts Uploading from desktop, a CSV file, s... DB2 2
No new posts Unable to retrieve Datasets Names usi... CLIST & REXX 20
No new posts Add column to existing records using ... JCL & VSAM 2
No new posts Discrepancy b/w SYSIBM tables and BMC... DB2 0
Search our Forums:

Back to Top