Page 1 of 1
Group records for Ouput in an IMS DB.
Posted: Fri Aug 08, 2014 2:57 pm
by Dark Fantasy
Hi,
In IMS DB is it possible for us to do a Group By, like DB2?
Re: Group records for Ouput in an IMS DB.
Posted: Fri Aug 08, 2014 4:34 pm
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?
Re: Group records for Ouput in an IMS DB.
Posted: Mon Aug 11, 2014 2:12 pm
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?