IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

ALTSEQ in SORT


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ajayvamsee
Currently Banned

New User


Joined: 07 May 2008
Posts: 6
Location: Hyderabad

PostPosted: Wed Jun 04, 2008 2:37 pm
Reply with quote

Hi,
Please explain wat the below code reperesent
I am not aware of ALTSEQ is all about...if there is any example please help me with that...material i could not find useful.

Code:

//SYSIN DD *                         
     SORT FIELDS=COPY                 
     ALTSEQ CODE=(2840,2540)         
     OUTREC FIELDS=(1,525,TRAN=ALTSEQ)
/*
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Jun 04, 2008 2:52 pm
Reply with quote

Hi,

each (X'28') is changed to a space (X'40') &
each (X'25') is changed to a space (X'40').


Gerry
Back to top
View user's profile Send private message
ajayvamsee
Currently Banned

New User


Joined: 07 May 2008
Posts: 6
Location: Hyderabad

PostPosted: Wed Jun 04, 2008 3:05 pm
Reply with quote

you mean to say that at column 28 is replaced as space similarly column 25 ? please let me know if i am wrong can u give me soem explanation wat this altseq is ment for?
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne

PostPosted: Wed Jun 04, 2008 3:10 pm
Reply with quote

there is a sticky in the utilities forum which contains links to documentation.

you need to read.

Quote:

each (X'28') is changed to a space (X'40') &
each (X'25') is changed to a space (X'40').


to interpret the above as column 28 displays little understanding.

you need to read a few manuals.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Wed Jun 04, 2008 3:13 pm
Reply with quote

Hi,

no, whenever the value hex 28 is encountered change it to hex 40 and whenever hex 25 is encountered change it to hex 40.


Gerry
Back to top
View user's profile Send private message
ajayvamsee
Currently Banned

New User


Joined: 07 May 2008
Posts: 6
Location: Hyderabad

PostPosted: Wed Jun 04, 2008 3:16 pm
Reply with quote

Thanks gcicchet I got from ur words ...in simple instead of clicking the manual and killing the good time...for searching in it...
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Wed Jun 04, 2008 7:00 pm
Reply with quote

The fields are not changed permanently, only to set the sort key value on the records. The output will still have x'28', etc.

I use ALTSEQ for sorting a report of MVS unit addresses. For this, I want 'A' thru 'F' to sort after '0' thru '9' so I change the 'A' (x'C1') to x'FA' so it sorts after the '9' (x'F9'), etc.

00C1
00C2
00C3
:
00C9
00CA
00CB
:
00CF
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Wed Jun 04, 2008 9:16 pm
Reply with quote

Quote:
The fields are not changed permanently, only to set the sort key value on the records


Bill,

You are confusing SORT with AQ and INREC, OUTREC or OUTFIL with TRAN=ALTSEQ. The OP is using TRAN=ALTSEQ, so the field is changed permanently. If the OP was using AQ in SORT, then the field would not be changed permanently.

Quote:
Thanks gcicchet I got from ur words ...in simple instead of clicking the manual and killing the good time...for searching in it...


You would NOT be wasting time by reading the manual, and you would learn more than the limited question you asked allows for.

For complete information on DFSORT's ALTSEQ statement, see:

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA20/3.4?DT=20060615185603

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

Use [URL] BBCode for External Links
Back to top
View user's profile Send private message
Bill Dennis

Active Member


Joined: 17 Aug 2007
Posts: 562
Location: Iowa, USA

PostPosted: Wed Jun 04, 2008 9:55 pm
Reply with quote

Yes, Frank, my mistake for not reading the original question closely enough. The fields will be changed in the OUTREC file.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts Need to set RC4 through JCL SORT DFSORT/ICETOOL 5
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts JCL sort card - get first day and las... JCL & VSAM 9
No new posts Sort First/last record of a subset th... DFSORT/ICETOOL 7
No new posts how to calculate SUM value for VB fil... DFSORT/ICETOOL 1
Search our Forums:

Back to Top