i need a help in SORT utility

IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

i need a help in SORT utility

Postby vishnu8766 » Thu Jul 30, 2015 5:22 pm

select deptno, sum(sal)
from <table>
group by deptno;

how can we write this in JCL with the help of SORT utility?
Posts: 3
Joined: Wed Jul 29, 2015 11:15 am
Has thanked: 0 time
Been thanked: 0 time

Re: i need a help in SORT utility

Postby prino » Thu Jul 30, 2015 9:04 pm

Most certainly not by posting in the JCL forum...

And why the flipping 'ell would you want to write this with SORT????

Oh, sorry for asking, but I guess "that's the requirement"...
Robert AH Prins
robert.ah.prins @ the.17+Gb.Google thingy
User avatar
Posts: 636
Joined: Wed Mar 11, 2009 12:22 am
Location: Vilnius, Lithuania
Has thanked: 3 times
Been thanked: 28 times

Re: i need a help in SORT utility

Postby BillyBoyo » Thu Jul 30, 2015 9:39 pm

If you have SyncSORT, consult your manual.
Global moderator
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times



  • Related topics
    Last post