View previous topic :: View next topic
|
Author |
Message |
r23051984
New User
Joined: 24 May 2009 Posts: 10 Location: chennai
|
|
|
|
we have SYNCSORT FOR Z/OS 1.3.0.2R in our Shop!
I am using the below sort card to remove the headers (alwyas first record is the header ) ,
Code: |
//SYSIN DD *
SORT FIELDS=(483,9,CH,A,492,4,CH,A,496,11,CH,A),
SKIPREC=1,STOPAFT=145961001
OUTREC FIELDS=(1:1,6,PD,EDIT=(TTTTTTTTTTT),12:07,503)
OUTFIL FNAMES=SORTOUT
SUM FIELDS=NONE,XSUM
//* |
STOPAFT=145961001 (last record from the file.)
Now, without knowing the last record count, i.e . i dont know how many records present in the inpuit file. (A new file is created for our process this month)..how to specify this value |
|
Back to top |
|
|
Alissa Margulies
SYNCSORT Support
Joined: 25 Jul 2007 Posts: 496 Location: USA
|
|
|
|
Maybe I am misunderstanding your requirement, but if you want to process all the records except the header record, you do not need the STOPAFT parameter. (Or the OUTFIL statement in this case). Please clarify.
Regards, |
|
Back to top |
|
|
r23051984
New User
Joined: 24 May 2009 Posts: 10 Location: chennai
|
|
|
|
You are correct alissa!! Thanks for your clarification..now i realised that there is no need for that STOPAFT. |
|
Back to top |
|
|
r2k1984
New User
Joined: 21 Jun 2005 Posts: 69 Location: chennai
|
|
|
|
exlcude the header title alone in the sort card. all the records other than that will be processed. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
r2k1984 wrote: |
exlcude the header title alone in the sort card. all the records other than that will be processed. |
Now how does this relate to the OPs problem. |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
not really r2k1984 fault...
the ts put as subject of the topic ... How to find the last record
in the body showed some jcl skipping the first (header ) record,
and went on with that ( as per Alissa reply )
a bit of communication problem around |
|
Back to top |
|
|
|