View previous topic :: View next topic
|
Author |
Message |
cvasu03
New User
Joined: 23 Mar 2007 Posts: 9 Location: USA
|
|
|
|
The VSAM file layout is mentiond below.
table number
emp id
address
SSN
I want the table number, emp id and SSN should be as part of my primary key. How I have to write my vsam define statement? Is it possible in VSAM? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Yes. . . It is possible.
However, they must all be contiguous. Usually, they would be placed at the front of the record layout. |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
So at a guess, you will need to reformat your file so that the fields that constitute the key are all contiguous. |
|
Back to top |
|
|
cvasu03
New User
Joined: 23 Mar 2007 Posts: 9 Location: USA
|
|
|
|
Thank you |
|
Back to top |
|
|
|