|
View previous topic :: View next topic
|
| Author |
Message |
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
Hi all
My query goes like this,
The i/p looks like
| Code: |
123456789 111
123456768 222
123465346 321
124346576 111
123243545 222 |
Where first field is employee number and second field is division code
I need to know the count of employees by division code. That is the O/p expected goes like this
The o/p contains the division and num of emploess under that division. |
|
| Back to top |
|
 |
krisprems
Active Member
Joined: 27 Nov 2006
Posts: 649
Location: India
|
|
|
|
i solved it my self, using sections.
| Code: |
OUTFIL NODETAIL,
SECTIONS=(11,3,
TRAILER3=(11,3,X,COUNT=(EDIT=(IIT))))
/*
|
Just had got stuck with syntax errors  |
|
| Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| You don't want REMOVECC? |
|
| Back to top |
|
|
|
|
