MVSFORUMS.com

ldushkin · Beginner Joined: 05 Apr 2006 Posts: 56 Topics: 20

I have a file with the VB. Is it possible by using any Utility to move the last record to the first record position?
For Example:
Input file:
111111
222222
3333333333
.................

00000000000

Output file:

00000000000
1111111
2222222
3333333333
................

Frank Yaeger · Posted: Tue Mar 20, 2007 5:51 pm Post subject:

With the example you show, you could just sort the records on the key and the 0 record would be first followed by the 1, 2 and 3 records. Are the keys really in that order by key? Or are they not necessarily in order? Is there anything unique about the last record (for example, it has 0 in postion 1) other than it being the last record?
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

ldushkin · Beginner Joined: 05 Apr 2006 Posts: 56 Topics: 20

I probably didn't show the correct example. There is no key in the record, i just need to make the last record in the file to be the first record. Only the last record should be effected. the sort is not required.

kolusu · Posted: Tue Mar 20, 2007 9:05 pm Post subject:

ldushkin,

Try this DFSORT/ICETOOL jcl

Frank Yaeger · Posted: Tue Jul 29, 2008 3:16 pm Post subject:

Here's another way to do this using the new SUBSET operator of DFSORT's ICETOOL available with z/OS DFSORT V1R5 PTF UK90013 (July, 2008):