Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups 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 SORT to unpack a feild shr_amar DFSORT/ICETOOL 7 Fri Jul 07, 2017 4:32 am
No new posts How to write Specific Fields from Mul... Padhu SYNCSORT 6 Thu Jul 06, 2017 10:26 am
No new posts Optimize sort inrec parse vishwakotin DFSORT/ICETOOL 6 Mon Jun 26, 2017 11:15 pm
No new posts Reduce CPU Times for Join Sort santoshn SYNCSORT 12 Sat Jun 10, 2017 1:40 pm
No new posts Db2 load job abending in SORT mistah kurtz DB2 4 Mon Jun 05, 2017 3:58 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us