View previous topic :: View next topic
|
Author |
Message |
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi,
Yes, i have tried that one also failed.
Regards
Suneel |
|
Back to top |
|
|
gcicchet
Senior Member
Joined: 28 Jul 2006 Posts: 1702 Location: Australia
|
|
|
|
Hi,
what happens to records less than 61 bytes ?
Gerry |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi,
I want to strip out the records upto 60...i want to copy from 61 to end of the record.
Regards
Suneel |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Suneel,
We think that we know what you want to do, but unless you post the output showing the exact error messages and answer the questions that you have been asked you are not going to get any help.
Please post the output showing the error messages and text, and try to answer Gerry's question. |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi,
This is the control car i have used:
OPTION COPY
OUTREC BUILD=(1,4,65)
The following error i got
OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
SORTOUT HAS INCOMPATIBLE LRECL
CONVERT FEATURE CANNOT BE USED WITH OVERLAY OR IFTHEN
Regards
Suneel |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Quote: |
OUTPUT LRECL DIFFERS FROM SORTOUT LRECL |
Sysout will show you the Output LRECL as well as Sortout LRECL. Make it same.
Thanks,
Arun |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
This thread is Unnecessarily toooo long.. grin.. |
|
Back to top |
|
|
Arun Raj
Moderator
Joined: 17 Oct 2006 Posts: 2481 Location: @my desk
|
|
|
|
Suneel,
From whatever have been posted so far, i dont see your output file format. Is it an FB file or VB file? if your output is an FB file you need to use the CONVERT option in OUTREC.
Quote: |
This thread is Unnecessarily toooo long.. grin.. |
Anuj,
Sorry for making it much longer.
Thanks,
Arun |
|
Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
Quote: |
Sorry for making it much longer. |
Methinks that the above quote should have come from the OP |
|
Back to top |
|
|
suneelv
New User
Joined: 26 Aug 2008 Posts: 52 Location: inida
|
|
|
|
Hi Everyone,
Now i corrected all the things and working fine with below control card
//SYSIN DD *
OPTION COPY,
STOPAFT=1000
OUTREC BUILD=(1,4,65)
/*
Thanks & Rgds
Suneel |
|
Back to top |
|
|
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 |
|
|
|