|
View previous topic :: View next topic
|
| Author |
Message |
rmd3003
New User
Joined: 03 Jul 2006
Posts: 55
|
|
|
|
Does anybody know if I can sort within "DISPLAY with count"?
For example if I have this code:
| Code: |
DISPLAY FROM(IN) LIST(RPT) BLANK -
BTITLE('CLIENT: ') BREAK(17,4,CH) -
BCOUNT('TOTAL ITEMS PRE CLIENT: ') EDBCOUNT(U08) -
HEADER('ITEMS:') ON(6,10,CH) -
COUNT('TOTAL ITEMS:') EDCOUNT(U15) |
I have to pre-sort it by CLIENT before running it otherwise it doesn't work correctly. Is there anywhere I can insert "SORT" here or it has to be separate step? |
|
| Back to top |
|
 |
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
It has to be a separate DFSORT/ICETOOL operator.
| Code: |
//TOOLIN DD *
SORT FROM(IN) TO(T1) USING(CTL1)
DISPLAY FROM(T1) LIST(RPT) ...
//CTL1CNTL DD *
SORT FIELDS=(...)
|
where T1 is a temporary data set.
If you want to sort and produce a report in one pass, you can use OUTFIL for that but you have to do more work to set up the report. |
|
| Back to top |
|
|
|
|
