View previous topic :: View next topic |
Author |
Message |
pkrishnakishore Beginner
Joined: 07 Feb 2006 Posts: 4 Topics: 3
|
Posted: Mon Oct 16, 2006 6:02 am Post subject: vsam file is fixed or variable length |
|
|
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 |
|
 |
kolusu Site Admin

Joined: 26 Nov 2002 Posts: 12385 Topics: 75 Location: San Jose
|
|
Back to top |
|
 |
pkrishnakishore Beginner
Joined: 07 Feb 2006 Posts: 4 Topics: 3
|
Posted: Mon Oct 16, 2006 8:08 am Post subject: |
|
|
thanks kolusu, I will try it out and will let you know _________________ krishna kishore |
|
Back to top |
|
 |
Bill Dennis Advanced

Joined: 03 Dec 2002 Posts: 579 Topics: 1 Location: Iowa, USA
|
Posted: Mon Oct 16, 2006 10:46 am Post subject: |
|
|
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 |
|
 |
bablack Beginner
Joined: 04 Dec 2002 Posts: 71 Topics: 0 Location: Little Falls, NJ
|
Posted: Mon Oct 16, 2006 1:17 pm Post subject: |
|
|
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 |
|
 |
Frank Yaeger Sort Forum Moderator

Joined: 02 Dec 2002 Posts: 1618 Topics: 31 Location: San Jose
|
Posted: Mon Oct 16, 2006 2:40 pm Post subject: |
|
|
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 |
|
 |
bablack Beginner
Joined: 04 Dec 2002 Posts: 71 Topics: 0 Location: Little Falls, NJ
|
Posted: Tue Oct 17, 2006 8:54 am Post subject: |
|
|
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 |
|
 |
|
|