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 Innovations in Your Mainframe Sort Arun Raj PC Guides & IT News 4 Wed Mar 15, 2017 10:38 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts SORT requirement sjiraga COBOL Programming 6 Thu Mar 09, 2017 9:11 pm
No new posts SORT to append Month and YEAR in MMYY... tisamf DFSORT/ICETOOL 1 Wed Mar 08, 2017 4:46 pm
No new posts DFSORT MUL FIELDS tspr52 DFSORT/ICETOOL 16 Fri Mar 03, 2017 11:53 pm


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