|
View previous topic :: View next topic
|
| Author |
Message |
royalchm
New User
Joined: 15 Nov 2007
Posts: 29
Location: Bangalore
|
|
|
|
My requirment is need to create a report. But if i am using Outrec then i am getting following error.
| Code: |
WER276B SYSDIAG= 906423, 2008239, 2008239, 2293500
WER164B 9,280K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,408K BYTES USED
WER146B 128K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=FB ; LRECL= 80; BLKSIZE= 800
WER257I INREC RECORD LENGTH = 11
WER110I SORTOUT : RECFM=FB ; LRECL= 11; BLKSIZE= 11
WER110I REPORT01 : RECFM=FB ; LRECL= 80; BLKSIZE= 800
WER247A REPORT01 HAS INCOMPATIBLE LRECL
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
edited to take away the annoying color
My jcl is shown below
| Code: |
SORT FIELDS=(1,3,CH,A)
OUTREC FIELDS=(1,3,10:14,2)
OUTFIL FNAMES=REPORT01,
SECTIONS=(1,3,SKIP=3L,
HEADER3=(1:'COURSE',6X,'NAME',1X,'REG NO.',1X,'DEGREE',
/,1:6'*',6X,4'*',1X,7'*',1X,6'*'),
TRAILER3=(/,1:'TOTAL REC PER COURSE: ',COUNT,//,
20:'******** END OF COURSE *********',/,72'.',/)),
HEADER2=(1:'TIME: ',&TIME,30:'PAGE:',&PAGE,59:'DATE: ',&DATE,
/,72'-'),
HEADER1=(25:'EMPLOYEE EDUCATION INFORMATION'),REMOVECC,
TRAILER2=(/,1:'TOTAL NUMBER OF RECORDS IN PAGE',&PAGE,':',COUNT,
60://,
18:'******* END OF PAGE ********',/,72'*',/),
TRAILER1=(18:'******* END OF THE REPORT ********') |
Without using OUTREC it's working fine.
Please advise me |
|
| Back to top |
|
 |
superk
Global Moderator
Joined: 26 Apr 2004
Posts: 4652
Location: Raleigh, NC, USA
|
|
|
|
WER110I REPORT01 : RECFM=FB ; LRECL= 80; BLKSIZE= 800
WER247A REPORT01 HAS INCOMPATIBLE LRECL
Are you for some reason trying to force an override of the LRECL of REPORT01, or are you letting Syncsort determine what it should be? |
|
| Back to top |
|
|
royalchm
New User
Joined: 15 Nov 2007
Posts: 29
Location: Bangalore
|
|
|
|
| My intension is in the input file NAMEs are placed in 14th position. i want to move that data to 10th position of output file. i am not sure how can i use OUTREC along with OUTFIL. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
How about changing your OUTREC like this
| Code: |
| OUTREC FIELDS=(1,3,10:14,2,80:X) |
BTW, whats the expected LRECL of your report? Are you mentioning it in your JCL? |
|
| Back to top |
|
|
royalchm
New User
Joined: 15 Nov 2007
Posts: 29
Location: Bangalore
|
|
|
|
in my report the output field should come based on Header3. i tried the following JCl also.
JCL
SORT FIELDS=(1,3,CH,A)
OUTFIL FNAMES=REPORT01,
SECTIONS=(1,3,SKIP=3L,
HEADER3=(1:'COURSE',6X,'NAME',1X,'REG NO.',1X,'DEGREE',
/,1:6'*',6X,4'*',1X,7'*',1X,6'*'),
TRAILER3=(/,1:'TOTAL REC PER COURSE: ',COUNT,//,
20:'******** END OF COURSE *********',/,72'.',/)),
OUTREC=(1,3,10:14,2),
HEADER2=(1:'TIME: ',&TIME,30:'PAGE:',&PAGE,59:'DATE: ',&DATE,
/,72'-'),
HEADER1=(25:'EMPLOYEE EDUCATION INFORMATION'),REMOVECC,
TRAILER2=(/,1:'TOTAL NUMBER OF RECORDS IN PAGE',&PAGE,':',COUNT,
60://,
18:'******* END OF PAGE ********',/,72'*',/),
TRAILER1=(18:'******* END OF THE REPORT ********')
This time i am creating a new PS file while running iwth paramenter as follows
// DISP=(NEW,CATLG,DELETE),
// UNIT=SYSDA,
// SPACE=(TRK,(12,3),RLSE),
// DCB=(RECFM=FB,LRECL=132)
Then also i am getting
WER276B SYSDIAG= 403635, 1787437, 1787437, 2318250
WER164B 9,280K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 1,408K BYTES USED
WER146B 128K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=FB ; LRECL= 80; BLKSIZE= 800
WER110I SORTOUT : RECFM=FB ; LRECL= 80; BLKSIZE= 800
WER110I REPORT01 : RECFM=FB ; LRECL= 132; BLKSIZE= 27984
WER247A REPORT01 HAS INCOMPATIBLE LRECL
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
|
| Back to top |
|
|
Joel.B
New User
Joined: 13 Oct 2007
Posts: 5
Location: India
|
|
|
|
| When creating report thru Sort it should be FBA instead of FB. |
|
| Back to top |
|
|
royalchm
New User
Joined: 15 Nov 2007
Posts: 29
Location: Bangalore
|
|
|
|
| Joel.B wrote: |
| When creating report thru Sort it should be FBA instead of FB. |
i am using REMOVECC for that and withoout OUTREC report has generated correctly. this problem is coming only if i am including OUTREC. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Did you try what I posted earlier? Also make it to 132 if your LRECL is 132. |
|
| Back to top |
|
|
Joel.B
New User
Joined: 13 Oct 2007
Posts: 5
Location: India
|
|
|
|
REMOVECC is DFsort option, check it once by removing REMOVECC, from FB to FBA.
Thnx,
jb. |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
| Joel.B wrote: |
| REMOVECC is DFsort option |
Joel.B,
What makes you think that REMOVECC does not work with Syncsort? Is n't it better NOT to comment on something which you're not aware of. |
|
| Back to top |
|
|
royalchm
New User
Joined: 15 Nov 2007
Posts: 29
Location: Bangalore
|
|
|
|
| Arun Raj wrote: |
How about changing your OUTREC like this
| Code: |
| OUTREC FIELDS=(1,3,10:14,2,80:X) |
BTW, whats the expected LRECL of your report? Are you mentioning it in your JCL? |
Arun,
Thanks, It's working. if you don't mind can u please tell me what was the prob
Thanks once again for the help.
How can we give OUTREC inside the OUTFIL? |
|
| Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006
Posts: 2482
Location: @my desk
|
|
|
|
You're welcome.
| Quote: |
WER247A ddname HAS INCOMPATIBLE LRECL
EXPLANATION: The ddname will be SORTOUT, SORTOFxx,SORTOFx or the ddname provided by an OUTFIL FNAMES parameter.There is a conflict between the LRECL specification for the indicated output file and either the post-OUTFIL or post-OUTREC record length. Padding of records is not permitted after OUTFIL processing, so the LRECL may not be greater than the post-OUTFIL record length. Alternately, truncation of records is not permitted after the OUTREC statement or the OUTFIL OUTREC processing, so the LRECL may not be less than the post-OUTREC record length. |
|
|
| Back to top |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
