why there is no need of SSA while ISRT, DLET or REPL?

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
Jatin Singh
Registered Member
Posts: 20
Joined: Fri Nov 01, 2013 11:31 pm

why there is no need of SSA while ISRT, DLET or REPL?

Post by Jatin Singh »

Hi,

I'm learning IMS and got to know that without using the SSAs we can insert, delete replace the segments in IMS? Can you please help to learn this concept.
User avatar
Anuj Dhawan
Founder
Posts: 2802
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: why there is no need of SSA while ISRT, DLET or REPL?

Post by Anuj Dhawan »

You, usually, don't use ANY SSAs on a DLET call because a DLET will always delete the segment you just retrieved with a GET HOLD call. If you have retrieved more than one segment that' the time when you need an SSA to tell IMS that what segment you want to delete. This applies to a path call.

For an ISRT you'll use at least one unqualified SSA, naming the segment you are inserting. If there are no other SSAs, which parent(s) the new segment gets under depends on database position before the ISRT call. This way you can implicitly establish where a new segment goes by previous calls. However, it's recommended to tell IMS exactly where the new segments should go by including qualified SSAs for all the higher level segments when you do an ISRT.

For REPL you do not use SSAs. When the preceding GET HOLD only got one segment, program knows what segment is to be replaced, so no SSA is needed.

If the preceding GET HOLD was a path call, you might need SSAs for a REPL is , if it retrieves more than one segment.

Hope this helps.
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Jatin Singh
Registered Member
Posts: 20
Joined: Fri Nov 01, 2013 11:31 pm

Re: why there is no need of SSA while ISRT, DLET or REPL?

Post by Jatin Singh »

Thanks Anuj - got it.
User avatar
Anuj Dhawan
Founder
Posts: 2802
Joined: Sun Apr 21, 2013 7:40 pm
Location: Mumbai, India
Contact:
India

Re: why there is no need of SSA while ISRT, DLET or REPL?

Post by Anuj Dhawan »

You're welcome! :)
Thanks,
Anuj

Disclaimer: My comments on this website are my own and do not represent the opinions or suggestions of any other person or business entity, in any way.
Post Reply

Create an account or sign in to join the discussion

You need to be a member in order to post a reply

Create an account

Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute

Register

Sign in

Return to “IBM DB2 and IMS DB/DC”