vsam doubts



Help for IBM's record-oriented filesystem VSAM, ESDS, KSDS, RRDS, LDS and Storage management Subsystems

vsam doubts

Postby pavan » Sun Dec 05, 2010 10:04 am

in a vsam file where indexes are actually stored? and how can we delete records from a vsam file?
pavan
 
Posts: 3
Joined: Sat Nov 27, 2010 8:12 pm
Has thanked: 0 time
Been thanked: 0 time

Re: vsam doubts

Postby dick scherrer » Sun Dec 05, 2010 10:27 am

Hello,

Here is a link to an IBM redbook called Vsam Demystified:
http://www.redbooks.ibm.com/abstracts/s ... .html?Open

This document has all of the information you will need. Suggest you download the pdf so it will always be easily available.

The delete/define for the vsam file specifies where the index is to be stored.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: vsam doubts

Postby suma m.s » Tue Jan 18, 2011 10:40 pm

hi,

is it possible to view the contents of a vsam file just by opening it? :?:
suma m.s
 
Posts: 1
Joined: Wed Sep 15, 2010 9:17 pm
Has thanked: 0 time
Been thanked: 0 time

Re: vsam doubts

Postby Robert Sample » Wed Jan 19, 2011 1:27 am

How would you view the contents of the VSAM data set without opening it?

Opening the VSAM file implies a program is being run -- that program could show you the contents of the data set, depending upon which program it is.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: vsam doubts

Postby steve-myers » Wed Jan 19, 2011 1:55 am

suma m.s wrote:hi,

is it possible to view the contents of a vsam file just by opening it? :?:
You have to OPEN a VSAM dataset (not "file")before you can do anything (other than delete it!) with it. If you want to view the contents of a VSAM dataset you can use the PRINT command in IDCAMS.

The index of a VSAM dataset is stored in an index dataset. The index dataset is automatically allocated when you define a KSDS dataset. You can get the actual name of the index dataet by using the IDCAMS LISTCAT command. You can view the index as a separate entity by using the IDCAMS PRINT command, but it won't do you much good unless you really know VSAM internals.
steve-myers
Global moderator
 
Posts: 2105
Joined: Thu Jun 03, 2010 6:21 pm
Has thanked: 4 times
Been thanked: 243 times

Re: vsam doubts

Postby alexlloyd54 » Wed Jan 19, 2011 5:03 am

suma m.s wrote:hi,

is it possible to view the contents of a vsam file just by opening it? :?:


you could use IDCAMS's Print to print either all or few records :D
If I told you, Mossad would have to kill you :)
User avatar
alexlloyd54
 
Posts: 19
Joined: Mon Apr 26, 2010 1:20 pm
Has thanked: 0 time
Been thanked: 0 time

Re: vsam doubts

Postby NicC » Wed Jan 19, 2011 10:37 am

As far as I am aware an OPEN in any language does not retrieve data so that language would have to issue reads.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 3025
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisies (almost)
Has thanked: 4 times
Been thanked: 136 times


Return to VSAM/SMS

 


  • Related topics
    Replies
    Views
    Last post