Command codes in IMS DB

d_ezhil · New User Joined: 28 Apr 2005 Posts: 11 Location: chennai

Hi,

Can any one tell me how to use command code 'DP' in GU call to DB

Thanks,
Ezhil.

tsantosh · New User Joined: 03 Aug 2006 Posts: 8

suppose ur GU call is getting a segment 3 level down the hierarchy. Now you are giving 3 qualified SSAs for it. One for the root, second for the parent of the segment being fetched and third for the segment being fetched. If you use a plain GU without command codes, you get only the 3rd level segment in your IO Area and the parentage is set at the 3rd level. But if you want to establish parentage at the root level or at the 2nd level, then you can use a command code (*DP after segment name) in the corresponding SSA, and you will get the 3rd level segment along with the one or two extra levels that you want. Also the parentage will be established at the level whose SSA has the P command code. Make sure not to use the P command code in more than one SSAs. You can use the D command code in both upper levels though.

d_ezhil · New User Joined: 28 Apr 2005 Posts: 11 Location: chennai

you mean to say command code DP is the combination of command codes D and P. i.e. it's a path call and also set's parentage at the segment where command code is given.

Thanks a lot

tsantosh · New User Joined: 03 Aug 2006 Posts: 8

yes.. thats correct

er.manishawasthii · New User Joined: 24 Oct 2008 Posts: 6 Location: Pune

But what is the use of P . Like if I'm setting a p on second level.. What is the adavntage of it..............

Suthagar · New User Joined: 01 Jul 2005 Posts: 26 Location: Chennai

Once you set your parentage at the second level that will give you the freedom of getting all the occurences in the level 3 segment types by using the set of GN calls.