View previous topic :: View next topic
|
Author |
Message |
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
so what happens to the remainder of records ?
and why stop at 1000 ?
Gerry |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi Gerry,
The file contains Millions of records just for try i copied only first 1000 records.
Regards
Suneel |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
but the same statement failed earlier ????? without the STOPAFT parameter.
So how is it going to work now ?
Gerry |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi,
Earlier there is mismatch in the LRECL in the OUTPUT and SORTOUT LRECL. I made it same.
Regards
Suneel |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
There are some options in DFSORT that allow for short records.
I suggest that you take a look at the SYNCSORT manual and see if the equivilent exists and use them. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Well, post the SYSOUTs from both the JOBs- one which was executed & other which was not.. |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Anju,
Below is Sysout for the abended job:
SYSIN :
OPTION COPY
OUTREC BUILD=(1,4,65)
WER276B SYSDIAG= 0, 689181, 689181, 1740143
WER164B 8,880K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 100K BYTES RESERVE REQUESTED, 1,008K BYTES USED
WER146B 16K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 4004; BLKSIZE= 27998
WER237I OUTREC RECORD LENGTH = 3944
WER110I SORTOUT : RECFM=VB ; LRECL= 3943; BLKSIZE= 27998
WER462I OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
WER247A SORTOUT HAS INCOMPATIBLE LRECL
WER425A CONVERT FEATURE CANNOT BE USED WITH OVERLAY OR IFTHEN
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
Sysout for Sucessful job:
SYSIN :
OPTION COPY,
STOPAFT=1000
OUTREC BUILD=(1,4,65)
WER276B SYSDIAG= 193573, 689181, 689181, 1715754
WER164B 8,880K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 100K BYTES RESERVE REQUESTED, 1,009,512 BYTES USED
WER146B 16K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 4004; BLKSIZE= 27998
WER237I OUTREC RECORD LENGTH = 3944
WER110I SORTOUT : RECFM=VB ; LRECL= 4004; BLKSIZE= 27998
WER462I OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
RCD IN 1000, OUT 1000
Rgds
Suneel |
|
Back to top |
|
|
sampathkmn Warnings : 1 New User
Joined: 12 Dec 2005 Posts: 31 Location: bangalore
|
|
|
|
If the i/p file is VB, in ur jcl above o/p file DCB parameters are not mentioned, and the job can't create a FB file.
code DCB parameter with RECFM=FB, and code control card as below:
SORT FIELDS=COPY
OUTREC BUILD=(5:65,3943) |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
sampathkmn wrote: |
If the i/p file is VB, in ur jcl above o/p file DCB parameters are not mentioned, and the job can't create a FB file.
code DCB parameter with RECFM=FB, and code control card as below:
SORT FIELDS=COPY
OUTREC BUILD=(5:65,3943) |
If you bother to look at the posted output you might notice that both input and output are VB. |
|
Back to top |
|
|
Shankerraghu
New User
Joined: 19 Nov 2008 Posts: 1 Location: Chennai
|
|
|
|
Please try the below code
OUTFIL FNAMES=SORTOUT,VTOF,
OUTREC=(1:25,7,2X,10:32,7,4X)
The outrec and inrec position can be chaged according to your need.
:) |
|
Back to top |
|
|
meenal_mainframes Warnings : 1 New User
Joined: 07 Jul 2006 Posts: 9 Location: USA
|
|
|
|
Hi,
I tried the following Code post by gcicchet and it worked
OPTION COPY
OUTREC BUILD=(1,4,65)
Thanks a lot gcicchet! |
|
Back to top |
|
|
babuz87
New User
Joined: 03 Mar 2017 Posts: 1 Location: Italy
|
|
|
|
can anyone explain why STOPAFT=1000 resolves RDW problems? thx |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
Do not resurrect old topics. |
|
Back to top |
|
|
|