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?
vishnu8766
 
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

 

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
prino
 
Posts: 536
Joined: Wed Mar 11, 2009 12:22 am
Location: Oostende, Belgium
Has thanked: 3 times
Been thanked: 21 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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post