Page 1 of 1

i need a help in SORT utility

PostPosted: Thu Jul 30, 2015 5:22 pm
by vishnu8766
select deptno, sum(sal)
from <table>
group by deptno;


how can we write this in JCL with the help of SORT utility?

Re: i need a help in SORT utility

PostPosted: Thu Jul 30, 2015 9:04 pm
by prino
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"...

Re: i need a help in SORT utility

PostPosted: Thu Jul 30, 2015 9:39 pm
by BillyBoyo
If you have SyncSORT, consult your manual.