Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

can we change a key in vsam

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
rajrohith

New User


Joined: 15 Apr 2005
Posts: 54
Location: chennai

PostPosted: Mon Dec 25, 2006 10:31 pm    Post subject: can we change a key in vsam
Reply with quote

hi
i have doubt that can we change a key in vsam file
can we change a key by alter command?

by
raj
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon Dec 25, 2006 10:37 pm    Post subject:
Reply with quote

You should have doubt, what you are asking is not possible.
Back to top
View user's profile Send private message
rajrohith

New User


Joined: 15 Apr 2005
Posts: 54
Location: chennai

PostPosted: Mon Dec 25, 2006 10:45 pm    Post subject:
Reply with quote

i know not possible to change a key
but some peoples saying we can change a key by alter command
isit possible
by
raj
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Mon Dec 25, 2006 11:55 pm    Post subject:
Reply with quote

William Thompson wrote:
You should have doubt, what you are asking is not possible.
Oh, my bad icon_redface.gif
A little research with the fine manual proved me wrong icon_redface.gif
Quote:
3.2.2 ALTER Parameters
3.2.2.2 Optional Parameters
KEYS(length offset)
specifies the length and offset of the object's key. If the entry being altered defines an alternate index, offset applies to the alternate key in the data records in the base cluster.

Restrictions: KEYS can be specified only if all the following are true:

The object whose entry is being altered is an alternate index, a path, a key-sequenced cluster, or a data component of a key-sequenced cluster or alternate index.
The object whose entry is being altered contains no data records.
The values for KEYS in the object's catalog entry are default values. For default values, see the DEFINE command that defines the object.

If the values for KEYS in the object's catalog entry are not default values, and ALTER KEYS specifies the same nondefault values, processing continues for any other parameters specified on the command, and no error message is issued.
The new values for KEYS do not conflict with the control interval size specified when the object was defined.
The key fits within the record whose length is specified by the RECORDSIZE parameter.
The key fits in the first record segment of a spanned record.
Not real useful with the restrictions and seems unuseable against an established dataset, but, yes Virginia, keys can be altered.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Fail to change physical VSAM filename... jacobdng CICS 1 Fri Jan 20, 2017 12:36 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am
No new posts BWO option in VSAM blayek CICS 3 Sat Nov 05, 2016 10:47 am
No new posts VSAM define for large file jerryte JCL & VSAM 9 Wed Oct 05, 2016 1:51 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us