Page 1 of 3
Unable to unpack PD field of a VB file
Posted:
Mon Sep 03, 2012 7:47 pm
by sreerangesh
Hi,
I am facing an issue with unpacking PD fields of a VB file .can you please help me. Your help is appreciated.
I am getting the follwoing error
OUTREC RDW NOT INCLUDED
below is the jcl
-----------------
//STEP01 EXEC PGM=SORT
//SORTIN DD DSN=TEST.SORTED, VB file with 462 length(458+4)
// DISP=SHR
//SORTOUT DD DSN=TEST.SORTED.UNPK,
// DISP=(,CATLG,DELETE),UNIT=(TSODSK,15),
// SPACE=(CYL,(150,100),RLSE),
// DCB=(RECFM=VB,LRECL=479)
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(5:5,3,PD,EDIT=(TTTTT),
10:8,3,PD,EDIT=(TTTTT),
15:11,2,
17:13,2,PD,EDIT=(TTT),
20:15,2,PD,EDIT=(TTT),
23:17,2,
25:19,5,
30:24,2,
32:26,3,
35:29,10,
45:39,5,PD,EDIT=(STTTTTTT.TT),SIGNS=(+,-),
56:44,419)
/*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//*
**************************** Bottom of Data ****************************
Re: Unable to unpack PD field of a VB file
Posted:
Mon Sep 03, 2012 8:28 pm
by BillyBoyo
You must always specify the RDW with BUILD/FIELDS for a variable-length record file. This comes from the input record, and DFSORT then amends to the correct value as per the size of the output record.
SORT FIELDS=COPY
OUTREC FIELDS=(1,4,
5:5,3,PD,EDIT=(TTTTT),
10:8,3,PD,EDIT=(TTTTT),
15:11,2,
17:13,2,PD,EDIT=(TTT),
20:15,2,PD,EDIT=(TTT),
23:17,2,
25:19,5,
30:24,2,
32:26,3,
35:29,10,
45:39,5,PD,EDIT=(STTTTTTT.TT),SIGNS=(+,-),
56:44,419)
I'm not personally keen on columns for BUILD/FIELDS when data is consecutive. Just creates a maintenance headache when one of the early ones changes.
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 12:37 pm
by sreerangesh
Thanks for you reply, getting syntax error. I did not see any mistake in this.Can some body help me.
SORT FIELDS=COPY
OUTREC FIELDS=(1:4,
5:5,3,PD,EDIT=(TTTTT),
*
10:8,3,PD,EDIT=(TTTTT),
15:11,2,
17:13,2,PD,EDIT=(TTT),
20:15,2,PD,EDIT=(TTT),
23:17,2,
25:19,5,
30:24,2,
32:26,3,
35:29,10,
45:39,5,PD,EDIT=(STTTTTTT.TT),SIGNS=(+,-),
56:44,419)
WER268A OUTREC STATEMENT : SYNTAX ERROR
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 1:38 pm
by bodatrinadh
It should be ...
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,
5:5,3,PD,EDIT=(TTTTT),
...
...
...
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 2:04 pm
by BillyBoyo
I have "code'd" your post to preserve the spacing. If you want to see how, click on Quote. Note that the Code button will put the tags around an area that you highlight with the cursor.
You have Syncsort, indicated by the WER message. Your topic will be moved to that part of the forum shortly.
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 5:37 pm
by sreerangesh
you are right !, I am using sync sort. I have tried as adviced above.
still facing the same error :
WER235A OUTREC RDW NOT INCLUDED
SORT FIELDS=COPY
OUTREC FIELDS=(1:4,4,
5:5,3,PD,EDIT=(TTTTT),
10:8,3,PD,EDIT=(TTTTT),
15:11,2,
17:13,2,PD,EDIT=(TTT),
20:15,2,PD,EDIT=(TTT),
23:17,2,
25:19,5,
30:24,2,
32:26,3,
35:29,10,
45:39,5,PD,EDIT=(STTTTTTT.TT),SIGNS=(+,-),
56:44,419)
WER276B SYSDIAG= 4192067, 5641935, 5641935, 5640375
WER164B 8,876K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 12K BYTES RESERVE REQUESTED, 1,004K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 462; BLKSIZE= 27998
WER235A OUTREC RDW NOT INCLUDED
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 5:43 pm
by sreerangesh
I am sorry, it was a typo by me.corrected at
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,
...
...)
Facing the following error. I have given 474+4 as LRECL but still..
WER108I SORTIN : RECFM=VB ; LRECL= 462; BLKSIZE= 27998
WER237I OUTREC RECORD LENGTH = 474
WER110I SORTOUT : RECFM=VB ; LRECL= 478; BLKSIZE= 27998
WER462I OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
WER410B 7,848K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16MEG LINE,
WER410B 0 BYTES RESERVE REQUESTED, 2,264K BYTES USED
WER244A OUTREC - SHORT RECORD
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 5:48 pm
by enrico-sorichetti
what is that You do not understand about using the
bbcode tags
plain
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 5:59 pm
by sreerangesh
bb code was correct. now facing different issue with length.
56+419 = 474 being VB I have given LRECL as 474+4 = 478 , getting following error <"WER462I OUTPUT LRECL DIFFERS FROM SORTOUT LRECL">
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,
5:5,3,PD,EDIT=(TTTTT),
10:8,3,PD,EDIT=(TTTTT),
15:11,2,
17:13,2,PD,EDIT=(TTT),
20:15,2,PD,EDIT=(TTT),
23:17,2,
25:19,5,
30:24,2,
32:26,3,
35:29,10,
45:39,5,PD,EDIT=(STTTTTTT.TT),SIGNS=(+,-),
56:44,419)
WER276B SYSDIAG= 2976075, 4632659, 4632659, 5640375
WER164B 8,876K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 12K BYTES RESERVE REQUESTED, 2,408K BYTES USED
WER146B 20K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 462; BLKSIZE= 27998
WER237I OUTREC RECORD LENGTH = 474
WER110I SORTOUT : RECFM=VB ; LRECL= 478; BLKSIZE= 27998
WER462I OUTPUT LRECL DIFFERS FROM SORTOUT LRECL
Re: Unable to unpack PD field of a VB file
Posted:
Tue Sep 04, 2012 6:25 pm
by BillyBoyo
I have again
Code'd your post.
"bbcode" is not in any way related to me, it is the name for "marking up" a piece of text to appear on a "bulletin board".
As enrico has already tried to show you:
what is that You do not understand about using the bbcode tags
This is plain with no bbcode tags to preserve formatting through the use of a fixed-font
This is code'd with bbcode tags to preserve formatting through the use of a fixed-font
Please click on Quote to see how it is done and try to use it in the future. It makes your posts much more readable, and therefore much more likely to get a correct answer. It also shows you are at least putting some effort into into, not just dumping a mess and leaving someone else to sort everything out.
In Sorts, you specify each field position as
already including the RDW. If you add four for the RDW you will be "out" by four bytes. It is also best to leave DCB info off your dataset and let Sort put there what it is actually using.