Sort in VB format file



IBM's flagship sort product DFSORT for sorting, merging, copying, data manipulation and reporting. Includes ICETOOL and ICEGENER

Sort in VB format file

Postby rajaranganathan » Fri Nov 15, 2013 12:41 am

Hi All,

I'm trying to reformat a VB format file using sort. but i am getting RDW not found error. Please help regarding this

//SORTIN   DD DSN=TTEST.FTP.LSOUTPUT,DISP=SHR
//SORTOUT  DD DSN=TTEST.FTP.DELETE,
//            DISP=(NEW,CATLG,DELETE),
//            SPACE=(CYL,(10,05),RLSE),
//            UNIT=APPLTA,
//            DCB=(RECFM=VB,LRECL=1028,BLKSIZE=6144)
//SYSIN    DD *
  SORT FIELDS=COPY
  OUTREC FIELDS=(01:C'DELETE',
                 10:001,15,
                 26:56X)
/*
rajaranganathan
 
Posts: 27
Joined: Thu Oct 10, 2013 6:44 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sort in VB format file

 

Re: Sort in VB format file

Postby dick scherrer » Fri Nov 15, 2013 1:23 am

Hello,

Please post the messages generated by the problem run including the message ids.

Also, you need to use the "code" tag to preserve alignment and improve readability.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Sort in VB format file

Postby NicC » Fri Nov 15, 2013 3:07 pm

You are also not providing the RDW on the output record - it starts at position 1 for 4 bytes so your data starts at position 5.
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: Sort in VB format file

Postby skolusu » Fri Nov 15, 2013 8:05 pm

rajaranganathan,

If your intention is to create a 80 byte file with DELETE control cards, remove the hardcoded DCB properties in your JCL and use the following control cards
//SYSIN    DD *
  SORT FIELDS=COPY
  OUTFIL VTOF,BUILD=(C'DELETE ',5,15,80:X)
/*
Kolusu - DFSORT Development Team (IBM)
DFSORT is on the Web at:
www.ibm.com/storage/dfsort
skolusu
 
Posts: 586
Joined: Wed Apr 02, 2008 10:38 pm
Has thanked: 0 time
Been thanked: 39 times


Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post