# Diferencias ordenamiento CA vs dfsort a nivel record

Author Message
josessegura

New User

Joined: 12 Feb 2015
Posts: 6

Posted: Fri Feb 13, 2015 5:08 am

Hello,

I'm trying to migrate from CA (7.1) to DFSORT (V1R12), but the result of both is different record level, happens when the keys for those ordered are equal, eg:

instructions in CA
 Code: DATA NAMES = (ONE, 01.14, CH)             (TWO, 15.10, CH) SORT FIELDS = (ONE, A, TWO, A)

When I migrate to DFSORT, is as follows:

 Code: SORT FIELDS = (01.14, CH, A,               15.10, CH, A)

the SORTIN the process is as follows:

 Code: AAAAAAAAAAAAAADDDDDDDDDD4 BBBBBBBBBBBBBBCCCCCCCCCC2 AAAAAAAAAAAAAAFFFFFFFFFFFF3 AAAAAAAAAAAAAAEEEEEEEEEEE1 AAAAAAAAAAAAAAEEEEEEEEEEE2

The result in CA is:
 Code: AAAAAAAAAAAAAADDDDDDDDDD4 [b]AAAAAAAAAAAAAAEEEEEEEEEEE1 AAAAAAAAAAAAAAEEEEEEEEEEE2[/b] AAAAAAAAAAAAAAFFFFFFFFFFFF3 BBBBBBBBBBBBBBCCCCCCCCCC2

DFSORT the result is:
 Code: AAAAAAAAAAAAAADDDDDDDDDD4 [b]AAAAAAAAAAAAAAEEEEEEEEEEE2 AAAAAAAAAAAAAAEEEEEEEEEEE1[/b] AAAAAAAAAAAAAAFFFFFFFFFFFF3 BBBBBBBBBBBBBBCCCCCCCCCC2

The system logic is correct in both cases, but the system level record is not the same.

that differences should be?
how I can match the results?
thx

Code'd
enrico-sorichetti

Superior Member

Joined: 14 Mar 2007
Posts: 10782
Location: italy

 Posted: Fri Feb 13, 2015 5:19 am when using DFSORT or any smart sort program for keys the order is unpredictable, the workaround for DFSORT is to use OPTION EQUALS which will for keys preserve the original relative sequence speak to Your support to find out the defaults for each product, and You will find the why for the different behavior.
Bill Woodger

Moderator Emeritus

Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

 Posted: Fri Feb 13, 2015 1:13 pm A couple of things to add. Talk to IBM. If you are migrating to DFSORT, the DFSORT team will be happy to assist with questions that arise. It looks like CA-Sort can define symbols. So can DFSORT. Have a look at SYMNAMES in the documentation, and SYMNOUT which shows the generated symbol table. (I hope that ONE and TWO are only examples for this post...). All the DFSORT manuals are available online. 1.12 is somewhat dated, you may want to check with IBM about support (or your boss should want to).
 View Bookmarks All times are GMT + 6 Hours

 Topic Forum Replies Similar Topics COBOL Table data to a flat file with ... COBOL Programming 5 Write a current record plus previous ... DFSORT/ICETOOL 4 DFSORT to add 6 hours to time(tdate-t... DFSORT/ICETOOL 16 Error while fetching the record from ... COBOL Programming 3 Print report for each record from mul... CA Products 1
Search our Forums: