Sorting Arabic data in right-to-left mode



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sorting Arabic data in right-to-left mode

Postby Ron Mascarenhas » Mon Nov 10, 2008 1:43 am

I am trying to find a DFSORT solution to sorting arabic data in Right-to-Left mode. For example to SORT a 5 bye arabic name field we do SORT FIELDS=(5,1,CH,A,4,1,CH,etc). Is there an easier way to do this for Arabic data using DFSORT (OR ICETOOL) with LOCALE ALTSEQ etc?

Thanks
Ron Mascarenhas
 
Posts: 15
Joined: Mon Nov 03, 2008 2:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sorting Arabic data in right-to-left mode

 

Re: Sorting Arabic data in right-to-left mode

Postby dick scherrer » Mon Nov 10, 2008 2:23 am

Hello,

Even when the file is in order by "right to left" sorting, i suspect that using the fields in code for matching or control breaks also presents challanges.

How are these fields used as keys/indexes in database tables and vsam files?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Sorting Arabic data in right-to-left mode

Postby Ron Mascarenhas » Mon Nov 10, 2008 10:37 am

The arabic data is stored in DB2 but the data that is being sorted is normal text mode data for reporting purposes. We just need to sort the data on the name fields to be passed to another program for reporting.
Ron Mascarenhas
 
Posts: 15
Joined: Mon Nov 03, 2008 2:04 am
Has thanked: 0 time
Been thanked: 0 time

Re: Sorting Arabic data in right-to-left mode

Postby Frank Yaeger » Mon Nov 10, 2008 10:00 pm

DFSORT offers LOCALE support - there might be an Arabic LOCALE available that does what you need or there might not. I doubt anyone here knows. I'd suggest you try to find somebody in your shop who is familiar with the situation you're trying to handle. You're probably not the first one to encounter this situation.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1080
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 14 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post