Unable to unpack PD field of a VB file



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Unable to unpack PD field of a VB file

Postby sreerangesh » Mon Sep 03, 2012 7:47 pm

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 ****************************
sreerangesh
 
Posts: 10
Joined: Fri Oct 17, 2008 7:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to unpack PD field of a VB file

Postby BillyBoyo » Mon Sep 03, 2012 8:28 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Unable to unpack PD field of a VB file

Postby sreerangesh » Tue Sep 04, 2012 12:37 pm

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
sreerangesh
 
Posts: 10
Joined: Fri Oct 17, 2008 7:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to unpack PD field of a VB file

Postby bodatrinadh » Tue Sep 04, 2012 1:38 pm

It should be ...
SORT FIELDS=COPY
OUTREC FIELDS=(1:1,4,
5:5,3,PD,EDIT=(TTTTT),
...
...
...
Thanks
-3nadh
User avatar
bodatrinadh
 
Posts: 67
Joined: Thu Jan 12, 2012 9:05 pm
Has thanked: 0 time
Been thanked: 4 times

Re: Unable to unpack PD field of a VB file

Postby BillyBoyo » Tue Sep 04, 2012 2:04 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Re: Unable to unpack PD field of a VB file

Postby sreerangesh » Tue Sep 04, 2012 5:37 pm

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
sreerangesh
 
Posts: 10
Joined: Fri Oct 17, 2008 7:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to unpack PD field of a VB file

Postby sreerangesh » Tue Sep 04, 2012 5:43 pm

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
sreerangesh
 
Posts: 10
Joined: Fri Oct 17, 2008 7:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to unpack PD field of a VB file

Postby enrico-sorichetti » Tue Sep 04, 2012 5:48 pm

what is that You do not understand about using the bbcode tags

plain

cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 3003
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 164 times

Re: Unable to unpack PD field of a VB file

Postby sreerangesh » Tue Sep 04, 2012 5:59 pm

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
sreerangesh
 
Posts: 10
Joined: Fri Oct 17, 2008 7:58 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Unable to unpack PD field of a VB file

Postby BillyBoyo » Tue Sep 04, 2012 6:25 pm

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.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 265 times

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post