MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

vsam file is fixed or variable length

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management
View previous topic :: View next topic  
Author Message
pkrishnakishore
Beginner


Joined: 07 Feb 2006
Posts: 4
Topics: 3

PostPosted: Mon Oct 16, 2006 6:02 am    Post subject: vsam file is fixed or variable length Reply with quote

Hi,

I am new to VSAM programming,

1) Can somebody tell me how to find whether a vsam file is fixed or variable length by looking at the file.
2) Also what is the definition syntax for a var length KSDS vsam file using IDCAMS.
3) Also while Reproing the var length KSDS vsam file to a flat file, what values should be given to the lrecl and recfm parameters ?

Thanks in advance,
Kishore
_________________
krishna kishore
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12376
Topics: 75
Location: San Jose

PostPosted: Mon Oct 16, 2006 7:21 am    Post subject: Reply with quote

pkrishnakishore,

1. Type this command at option 6

Code:

TSO LISTC ENT('your vsam cluster in question') all


and press enter. you will find the information under attributes section

2. Check this link for DEFINE cluster with examples

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/dgt1v403/3.7?DT=19990113080956

3. Specify the max lrel as the lrecl and Vb as recfm

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
pkrishnakishore
Beginner


Joined: 07 Feb 2006
Posts: 4
Topics: 3

PostPosted: Mon Oct 16, 2006 8:08 am    Post subject: Reply with quote

thanks kolusu, I will try it out and will let you know
_________________
krishna kishore
Back to top
View user's profile Send private message
Bill Dennis
Advanced


Joined: 03 Dec 2002
Posts: 579
Topics: 1
Location: Iowa, USA

PostPosted: Mon Oct 16, 2006 10:46 am    Post subject: Reply with quote

I think you want to use max lrecl + 4 to account for RDW on VB file.
_________________
Regards,
Bill Dennis

Disclaimer: My comments on this foorum are my own and do not represent the opinions or suggestions of any other person or business entity.
Back to top
View user's profile Send private message
bablack
Beginner


Joined: 04 Dec 2002
Posts: 71
Topics: 0
Location: Little Falls, NJ

PostPosted: Mon Oct 16, 2006 1:17 pm    Post subject: Reply with quote

Actually all VSAM (except Linear) is variable, meaning that every record starts with its length. But in a LISTCAT if the MAXLRECL and the AVGLRECL values are the same, then it is effectivly a fixed file (all records the same length).
_________________
Bruce A. Black
Senior Software Developer
Innovation Data Processing
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Mon Oct 16, 2006 2:40 pm    Post subject: Reply with quote

Quote:
Actually all VSAM (except Linear) is variable, meaning that every record starts with its length.


For a VSAM record, isn't the length in the RDF rather than at the start of each record?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
bablack
Beginner


Joined: 04 Dec 2002
Posts: 71
Topics: 0
Location: Little Falls, NJ

PostPosted: Tue Oct 17, 2006 8:54 am    Post subject: Reply with quote

Frank, you are correct. I am used to looking at the physical CIs in VSAM, where you use the lengths in the RDF to move between records.
_________________
Bruce A. Black
Senior Software Developer
Innovation Data Processing
Back to top
View user's profile Send private message Send e-mail Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Data Management All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group