Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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 How to change the logon screen info o... sakthikumarT TSO/ISPF 4 Fri Dec 29, 2017 6:44 pm
No new posts Change NULL indicator in UNLOAD utility Khadhar Basha DB2 2 Fri Dec 15, 2017 3:01 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Partial color change of a field in CI... waseem0424 CICS 5 Fri Sep 29, 2017 7:56 pm
No new posts How to change a string containing the... chong.zhou TSO/ISPF 6 Tue Aug 29, 2017 4:54 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us