Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
SORT on long control fields to eliminate duplicates

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Fri Apr 20, 2007 12:09 pm    Post subject: SORT on long control fields to eliminate duplicates
Reply with quote

I HAVE TO SORT A FILE WHOSE LRECL=15543.AND BLKSIZE=15543..
I WANT TO SORT ON THE ENTIRE FILE TO ELIMINTAE DUPLICATES...
WHILE I GIVEN CONTROL FILED LENGTH MORE THAN 4000...I AM GETTING THE FOLLOWING ERROR...CAN ANYBODY HELP ON THIS...

CARD:

Code:

//SYSIN    DD  *                   
  OPTION SDB=LARGE                   
  SORT FIELDS=(01,15000,CH,A),EQUALS
  SUM FIELDS=NONE                   
/*                               '

ERROR:

SORT FIELDS=(01,15000,CH,A),EQUALS
$
ICE017A C CONTROL FIELD DISPLACEMENT OR LENGTH VALUE ERROR
Back to top
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Apr 20, 2007 1:32 pm    Post subject: Re: SORT ON LONG CONTORL FIELDS
Reply with quote

LOOKAT wrote:
ICE017A CONTROL FIELD DISPLACEMENT OR LENGTH VALUE ERROR
Explanation: Critical. The message was issued for one of the following reasons:
The length or position of a control field was specified incorrectly.


The Fine Manual wrote:
The collected control fields (comprising the control word) must not exceed 4092 bytes (or 4088 bytes when EQUALS is in effect).
Back to top
View user's profile Send private message
avaneendra_linga

New User


Joined: 13 Dec 2006
Posts: 73
Location: Hyderabad

PostPosted: Fri Apr 20, 2007 2:10 pm    Post subject:
Reply with quote

yes thompson..you are correct...
but my requirement is to elimintae duplicates based on complete record....
so is there any other way to elimintae the duplicates....by assuming toal record as KEY........
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Apr 20, 2007 2:26 pm    Post subject:
Reply with quote

You need to analyze the record's data structure to find as much as 4k worth of fields to do a primary sort on, those fields most likely to change. Once so sorted, you can programmaticly compare the key equal records to each other checking the rest of the record. Not particularly easy, but not totally impossible.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Subtract the ZD fields to provide neg... Balaryan DFSORT/ICETOOL 4 Wed Oct 11, 2017 10:51 pm
No new posts sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us