|
View previous topic :: View next topic
|
| Author |
Message |
ayapatsr
New User
Joined: 01 Apr 2009
Posts: 14
Location: pune
|
|
|
|
Hi Frnds,
I have one VSAM file with fields below.
Telephone Number, Countr code, City Code,City Name. Telephone Number is the key. Key length is 10. Due to the business requirements, the Phone Number lenght changed from 10 to 15. Now i need to update this in my VSAM file.
Is it possible to update the lentth of a KEY field in VSAM file? |
|
| Back to top |
|
 |
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007
Posts: 10872
Location: italy
|
|
|
|
why not ?
unload the old vsam to a sequential dataset,
carry on all the record changes you need, ( layout and content )
delete the old vsam
define the new vsam with the new parameters ( record and key lengths )
reload the new vsam
all this if You want to keep the old name
I would recommend , if possible, to change the name in order not to clobber all the backup/restore logic
the process can also be shortened
define the new vsam
read the old vsam and load the new vsam! |
|
| Back to top |
|
|
|
|
