View previous topic :: View next topic
|
Author |
Message |
avaneendra_linga
New User
Joined: 13 Dec 2006 Posts: 73 Location: Hyderabad
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
avaneendra_linga
New User
Joined: 13 Dec 2006 Posts: 73 Location: Hyderabad
|
|
|
|
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 |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
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 |
|
|
|