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
 

 

How to change the key value in IMS DB

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IMS DB/DC
View previous topic :: :: View next topic  
Author Message
rohit4u

New User


Joined: 06 Oct 2006
Posts: 6

PostPosted: Mon Oct 29, 2007 7:37 pm    Post subject: How to change the key value in IMS DB
Reply with quote

Hi,

I want to change the key value in a segment. Suppose PART MASTER is the parent segment and part number is the key and I want to change the first 6 characters of the part number. under that parent there are some child segments also...

So it would be great if some body could tell me how to achieve this?

Thanks in advance.

Regards,
Rohit.
Back to top
View user's profile Send private message

Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Mon Oct 29, 2007 7:54 pm    Post subject:
Reply with quote

You cannot "change" a key value. You would need to save all the information from the parent and all child segments. Then you would create new segments. Then you would go back to the original segment and issue delete for the root - all segments beneath that root would be deleted automatically.
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Mon Oct 29, 2007 9:20 pm    Post subject:
Reply with quote

Quote:
want to change the key value in a segment

Segment Key - CANNOT be CHANGED.
Back to top
View user's profile Send private message
Sandy Zimmer

Active Member


Joined: 13 Jun 2007
Posts: 826
Location: Wilmington, DE

PostPosted: Tue Oct 30, 2007 2:36 am    Post subject:
Reply with quote

IMS functions with "pointers". Twin forward - twin backward - twin backward forward. When you are inserting segments, IMS keeps track of where and who you belong with. The main thing - as I have always said - is positioning. IMS knows where you are based on your position in the database - and the internal "pointers". If you try to rewrite a key value - you would be lost - IMS will not allow that. It's a lot like VSAM - VSAM is a grandparent of IMS.
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 -> IMS DB/DC 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 5 Fri Jan 20, 2017 12:36 pm
No new posts Change date (DD/MM/YY) in 2nd record ... uday kiran DFSORT/ICETOOL 12 Wed Sep 07, 2016 10:57 pm
No new posts How to change dataset attributes of m... ignich7 JCL & VSAM 3 Thu Jul 21, 2016 9:17 pm
No new posts GDG vsersion number change Raghu navaikulam JCL & VSAM 5 Fri May 27, 2016 4:49 pm
No new posts Change Data Capture Ron Klop DFSORT/ICETOOL 14 Fri Apr 15, 2016 2:56 pm


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