Group records for Ouput in an IMS DB.

RDBMS from IBM and IBM's Hierarchical DBMS and Transaction Manager (IMS DC).
Post Reply
Dark Fantasy
New Member
Posts: 8
Joined: Sun Dec 08, 2013 12:54 am

Group records for Ouput in an IMS DB.

Post by Dark Fantasy »

Hi,

In IMS DB is it possible for us to do a Group By, like DB2?
nicc
Global Moderator
Global Moderator
Posts: 691
Joined: Wed Apr 23, 2014 8:45 pm

Re: Group records for Ouput in an IMS DB.

Post by nicc »

Did you check the manual? Unless it is recent then the answer is "no". IMS returns one segment at a time although it is possible that with a path call it will return the segments from the path (not sure on that). But it will return ONE target segment so what good would grouping it be?
Regards
Nic
Dark Fantasy
New Member
Posts: 8
Joined: Sun Dec 08, 2013 12:54 am

Re: Group records for Ouput in an IMS DB.

Post by Dark Fantasy »

Search manual on what? "GROUP BY" is not there, so I assume it's not applicable.

But your reply makes me think, if I need to group by some specific filed from the segment, I'm left to write a bit of program only?
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”