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

Function of key word EQUALS in DFSORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
prav_06
Warnings : 1

Active User


Joined: 13 Dec 2005
Posts: 154
Location: The Netherlands

PostPosted: Tue Feb 12, 2008 2:57 pm
Reply with quote

Hi All,

Can any one explain about the use of EQUALS in a sort card

SORT FIELDS=(6,5,CH,A,22,8,ZD,D,4,2,ZD,A),EQUALS

What does the key word exactly do

Thamilzan.
Back to top
View user's profile Send private message
ashwinreddy

Active User


Joined: 16 Sep 2004
Posts: 106
Location: Hyderabad

PostPosted: Tue Feb 12, 2008 3:24 pm
Reply with quote

Hi,

Check this link

uts.sc.edu/ars/handouts/sort.shtml


Cheers
Ashwin
Back to top
View user's profile Send private message
Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Tue Feb 12, 2008 10:47 pm
Reply with quote

prav_o6,

Code:

    EQUALS
        specifies that the original sequence must be preserved.

    NOEQUALS
        specifies that the original sequence need not be preserved.

    For sort applications, the sequence of the output records depends upon the order of:

        * The records from the SORTIN file
        * The records inserted by an E15 user exit routine
        * The E15 records inserted within input from SORTIN.

    For merge applications, the sequence of the output records depends upon the order of:

        * The records from a SORTINnn file. Records that collate identically are output in the order of their file increments. For example, records from SORTIN01 are output before any records that collate identically from SORTIN02.

        * The records from an E32 user exit routine for the same file increment number. Records that collate identically from E32 are output in the order of their file increments. For example, records from the file with increment 0 are output before any records that collate identically from the file with increment 4.

    Notes:

    1. When EQUALS is in effect, the total number of bytes occupied by all control fields must not exceed 4088.

    2. Using EQUALS can degrade performance.

    3. When EQUALS is in effect with SUM, the first record of summed records is kept. When NOEQUALS is in effect with SUM, the record to be kept is unpredictable.

    If a technique other than Blockset is selected, NOEQUALS is forced if SUM is specified.

    4. Do not specify EQUALS if variable-length records are sorted using tape work files and the RDW is part of the control field.

    5. The number of records to be sorted cannot exceed 4294967295 (4 gigarecords minus 1); if the number of records exceeds this number, message ICE121A is issued and DFSORT terminates.

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 PARSE Syntax for not fix length word ... JCL & VSAM 7
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Search two or more word with FILEAID Compuware & Other Tools 15
No new posts Replace Multiple Field values to Othe... DFSORT/ICETOOL 12
No new posts Calling DFSORT from Cobol, using OUTF... DFSORT/ICETOOL 5
Search our Forums:

Back to Top