View previous topic :: View next topic |
Author |
Message |
Nancy Beginner
Joined: 23 May 2003 Posts: 77 Topics: 26
|
Posted: Mon Aug 25, 2003 4:15 am Post subject: TSO SORT !!! |
|
|
Hi,
My input file looks like ...
jobname : cols 17-25
grade : cols 30-40, g1, g2, g3 etc
I have to sort this file in a way that all the jobnames should display in ascending order of a particular grade together.
eg
all the jobs of g1 in ascending order
all the jobs of g2 in ascending order
all the jobs of g3 in ascending order...
I would appreciate if you could provide a TSO command instead of using JCL.
Thanks |
|
Back to top |
|
 |
Dibakar Advanced

Joined: 02 Dec 2002 Posts: 700 Topics: 63 Location: USA
|
Posted: Mon Aug 25, 2003 7:10 am Post subject: |
|
|
TSO sort is another is same old sort (DFSORT, SYNCSORT etc). It seems there will be more work with TSO sort as u have to allocate sortin, sortout, sysin etc. If u don't want to use batch sort then u can write a similar Rexx. |
|
Back to top |
|
 |
prakal Beginner
Joined: 14 Mar 2003 Posts: 22 Topics: 1
|
Posted: Mon Aug 25, 2003 10:08 am Post subject: |
|
|
We can do a SORT in ISPF. Open the file in EDIT/VIEW mode in ISPF and type the follwing command
Code: |
SORT start-at-column end-at-column Asending/Descending
|
on the command line. |
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Tue Aug 26, 2003 12:04 am Post subject: |
|
|
Prakal,
I believe Nancy is looking for a Multi-level sort. Not just on a single field.
Thanks |
|
Back to top |
|
 |
coolman Intermediate
Joined: 03 Jan 2003 Posts: 283 Topics: 27 Location: US
|
Posted: Tue Aug 26, 2003 12:48 am Post subject: |
|
|
Phantom,
Prakal's method can be extended to Multi-level sort.
Cheers,
Coolman.
________
Honda C77
Last edited by coolman on Sat Feb 05, 2011 1:26 am; edited 1 time in total |
|
Back to top |
|
 |
Phantom Data Mgmt Moderator

Joined: 07 Jan 2003 Posts: 1056 Topics: 91 Location: The Blue Planet
|
Posted: Tue Aug 26, 2003 7:07 am Post subject: |
|
|
Thanks coolman,
I didn't try that option until today. Thanks a lot for the info. Its working gr8 |
|
Back to top |
|
 |
|
|