How to sort alternate records

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

How to sort alternate records

Postby coollearner » Mon Jun 06, 2011 7:36 pm

I have a file with a key. I want to extract alternate records and sort the those records for partcicular criteria.
Please let me know how to achieve this.
Knowledge is wealth
Posts: 33
Joined: Thu Jun 03, 2010 3:15 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to sort alternate records

Postby Robert Sample » Mon Jun 06, 2011 8:07 pm

It is not at all clear what you are talking about.

What "alternate records" do you mean? If you're referring to alternate indexes (not records), are you wanting to unload the alternate index records themselves (which consist of a 4-byte overhead area, the alternate index key, and 4-byte pointers to each primary record with the matching alternate index), or unload the base cluster in alternate index key order?

What are you having problems with? Being specific in forum posts gets you much better answers than generic statements, since the more specific you make things the clearer it is for those of us who have no idea about your application, your site, or your requirements to help you.
Robert Sample
Global moderator
Posts: 3718
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times

Re: How to sort alternate records

Postby dick scherrer » Mon Jun 06, 2011 8:21 pm


You need to post some sample input data and the output you want when this input data is processed.

Mention the recfm and lrecl of all files along with anu "rules" that are needed to process the data.
Hope this helps,
User avatar
dick scherrer
Global moderator
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times



  • Related topics
    Last post