MVSFORUMS.com

manojagrawal · Beginner Joined: 25 Feb 2003 Posts: 124 Topics: 29

Hi,

I have an IMS DB.

As we can do in other databases such as DB2 or Oracle, is it possible for us to do a Group By on an IMS DB.

How it is done, i.e., thru PL/I or JCL would not matter. Any Idea's?

Regards,
Manoj. Rolling Eyes

Bithead · Posted: Wed Mar 19, 2003 10:32 am Post subject:

No. You can only perform GU or GN or variations. Criteria are set in the SSA similar in function to the WHERE clause but the fields are limited. You cannot ORDER BY.

manojagrawal · Beginner Joined: 25 Feb 2003 Posts: 124 Topics: 29

Hi!

Do we have something like Cursors in IMS?

Can we work on a group of records in IMS at a time while using an Application Language such as PLI. After working on the group of records, i wold like to replace it back to the DB. Is this possible!!! Comments Please.

Regards,
Manoj.

Bithead · Posted: Wed Mar 26, 2003 3:20 pm Post subject:

There are no cursors. Look at setting parentage (command code D) then using GNP to retrieve the records. Do your work then use either GHNP followed by replace or GHU followed by a replace.

You will also want to look at potential locking problems and checkpoint / restart.