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

Retrieving Index details from the system tables.


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

New User


Joined: 15 Apr 2005
Posts: 12
Location: Chennai

PostPosted: Wed May 24, 2006 11:03 am
Reply with quote

Hi,
Given an index name, where to fetch the columns associated with that index, from the system tables.
(Note: DB2 version - DB2 for iseries V5R3)
Back to top
View user's profile Send private message
gskulkarni

New User


Joined: 01 Mar 2006
Posts: 70

PostPosted: Wed May 24, 2006 1:50 pm
Reply with quote

SYSIBM.SYSKEYS
is the table. it has following columns
Code:
IXNAME             VARCHAR(18)
IXCREATOR          CHAR(8)     
COLNAME            VARCHAR(18)
COLNO              SMALLINT   
COLSEQ             SMALLINT   
ORDERING           CHAR(1)     
IBMREQD            CHAR(1)   


You can run SQL on this table by providing the INdex Name that you have.
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 Sysplex System won't IPL at DR site I... All Other Mainframe Topics 2
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts Cobol file using index COBOL Programming 2
No new posts Insert system time/date (timestamp) u... DFSORT/ICETOOL 5
No new posts JCL Dynamic System Symbols JCL & VSAM 3
Search our Forums:

Back to Top