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

How to find the key in vsam ksds file


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
VENKATA999
Warnings : 2

New User


Joined: 05 Jan 2006
Posts: 44

PostPosted: Mon Oct 09, 2006 10:54 am
Reply with quote

Hi ,

How do we know the key field & length in ksds file ?

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

Active User


Joined: 14 Jun 2005
Posts: 186
Location: USA

PostPosted: Mon Oct 09, 2006 10:35 pm
Reply with quote

You can use IDCAMS

Code:

LISTCAT ENTRIES (VSAM FILE NAME) ALL



and in result look for

Code:


ATTRIBUTES                 
  KEYLEN----------------12
  RKP--------------------0



this gives you key length and relative key position.

Another way is by using FILEAID:

F.FA;3.5 option , enter VSAM file name and press enter and look for:

KSDS key length: 12
KSDS key location: 0
Back to top
View user's profile Send private message
VENKATA999
Warnings : 2

New User


Joined: 05 Jan 2006
Posts: 44

PostPosted: Tue Oct 10, 2006 10:34 am
Reply with quote

Thanks a lot ..
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts FTP VB File from Mainframe retaining ... JCL & VSAM 4
No new posts Extract the file name from another fi... DFSORT/ICETOOL 6
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
Search our Forums:

Back to Top