Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
how to code sumfields

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
Author Message
veera
Warnings : 1

New User


Joined: 24 Nov 2004
Posts: 21
Location: chennai

PostPosted: Tue Dec 07, 2004 1:30 pm    Post subject: how to code sumfields
Reply with quote

hi,
any one plse tell me,
I HAVE ONE FILE WHICH IS HAVING RECORDS,
EATCH RECORD HAVING 80 CHAR.I WANT TO ELIMINATE DUPLECATES
FROM 1-10,30-40.
EXAMPLE:
1-10 11-20 30-40...................ETC


AAAA BBB CCC

AAAA ASD CCC

I WANT TO ELIMINATE DUPLICATE IN 1-10,&30-40.

REGARDS,
VEERABABU.P
Back to top
View user's profile Send private message
References
PostPosted: Tue Dec 07, 2004 1:30 pm    Post subject: Re: how to code sumfields Reply with quote

lramani

New User


Joined: 03 Nov 2004
Posts: 22
Location: NOIDA, India

PostPosted: Tue Dec 07, 2004 5:49 pm    Post subject:
Reply with quote

Hi veera,

Use SUM FIELDS=NONE by having the sort on the required field.

so SORT on from 1 to 10 and 30 to 40 and use SUM FIELDS=NONE.

That should solve ur problem.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1