Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
josessegura

New User

Joined: 12 Feb 2015
Posts: 6

Posted: Fri Feb 13, 2015 5:08 am    Post subject: Diferencias ordenamiento CA vs dfsort a nivel record

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

Senior Member

Joined: 14 Mar 2007
Posts: 10626
Location: italy

 Posted: Fri Feb 13, 2015 5:19 am    Post subject: Reply to: Diferencias ordenamiento CA vs dfsort a nivel reco 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

DFSORT Moderator

Joined: 09 Mar 2011
Posts: 7312

 Posted: Fri Feb 13, 2015 1:13 pm    Post subject: Reply to: Diferencias ordenamiento CA vs dfsort a nivel reco 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).
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics Need help in parsing record in VBA file guptae DFSORT/ICETOOL 4 Fri Oct 11, 2019 2:31 pm Concatenate two files of variable rec... Thiru S DFSORT/ICETOOL 3 Wed Aug 21, 2019 11:53 pm ALTERNATE RECORD KEY usage for KSDS AIX sophia.lee COBOL Programming 1 Thu Jul 25, 2019 7:28 am Removing duplicate record based on th... Nilanjan Sikdar DFSORT/ICETOOL 4 Mon Jul 22, 2019 8:29 pm how to add date & timestamp to th... dharmaraok DFSORT/ICETOOL 5 Thu Apr 18, 2019 2:45 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us