IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SORT on long control fields to eliminate duplicates


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
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
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: 3156
Location: Tucson AZ

PostPosted: Fri Apr 20, 2007 1:32 pm
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
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: 3156
Location: Tucson AZ

PostPosted: Fri Apr 20, 2007 2:26 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Using Dynamic file handler in the Fil... COBOL Programming 2
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
Search our Forums:

Back to Top