MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

How to sort a VB length

 
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities
View previous topic :: View next topic  
Author Message
sankar narayanan
Beginner


Joined: 16 Oct 2007
Posts: 29
Topics: 12
PostPosted: Wed Oct 17, 2007 1:29 am    Post subject: How to sort a VB length Reply with quote
Hi,

I am trying to sort the input file which is of VB format and wants the output with few fields of input file....I am using Include COND & outrec for that....but I am getting an abend U0016 with sysout msg "OUTREC RDW NOT INCLUDED".... My JCL look like this......

//SORTIN DD DSN=TRGAA.TEST.TEST,DISP=SHR
//SORTOUT DD DSN=TRGBB.TEST1.TEST1,UNIT=TSTDA,
// DISP=(NEW,CATLG,DELETE),
// DCB=TRGAA.TEST.TEST,
// SPACE=(CYL,(100,10),RLSE)
//SYSOUT DD SYSOUT=*
//SYSPRINT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
OUTREC FIELDS=(1:6,7)
/*

and i even tried to increasing the LRECL by 4 byte and also tried the OUTREC as OUTREC FIELDS=(1:1,4,1:6,7)...still i am getting the same err.....Plz help me....


Regards
Sank....
Back to top
View user's profile Send private message
vkphani
Intermediate


Joined: 05 Sep 2003
Posts: 483
Topics: 48
PostPosted: Wed Oct 17, 2007 3:15 am    Post subject: Reply with quote
sankar narayanan,
Did you take RDW into consideration?
Change your sort card as below and try
Code:
OUTREC FIELDS=(5:6,7)
Back to top
View user's profile Send private message Send e-mail
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
PostPosted: Wed Oct 17, 2007 10:11 am    Post subject: Reply with quote
The correct statement would be:

Code:

   OUTREC BUILD=(1,4,6,7)


For VB records, you have to specify the RDW (1,4). You can specify the data bytes (6,7) after the RDW.

Code:

   OUTREC FIELDS=(1:1,4,1:6,7)


This won't work because you specified 1: after 1:1,4 which results in overlapping fields - 1:1,4,5:6,7 would work.

Code:

   OUTREC FIELDS=(5:6,7)


This won't work because the RDW is not specified.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
Back to top
View user's profile Send private message Send e-mail Visit poster's website
sankar narayanan
Beginner


Joined: 16 Oct 2007
Posts: 29
Topics: 12
PostPosted: Mon Oct 22, 2007 9:51 am    Post subject: Reply with quote
Hi Frank Yaeger;

Thanks a lot.....it helped me.....
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic   printer-friendly view    MVSFORUMS.com Forum Index -> Utilities All times are GMT - 5 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group