Sort File



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

Re: Sort File

Postby Vineet » Wed Dec 07, 2011 2:13 am

Yes No Space for Position 172,2. Its having Value like 16,19,20.... . No 'C' Character.
Vineet
 
Posts: 86
Joined: Tue Jun 19, 2007 11:38 am
Has thanked: 0 time
Been thanked: 0 time

Re: Re: Sort File

 

Re: Sort File

Postby skolusu » Wed Dec 07, 2011 2:46 am

vineet wrote:Yes No Space for Position 172,2. Its having Value like 16,19,20.... . No 'C' Character.


I wouldn't believe it unless I see it. Anyway I asked you another question about what the error was and what was that you corrected?

Run this job as is and show me output as well as the complete sysout

//STEP0100 EXEC PGM=SORT       
//SYSOUT   DD SYSOUT=*         
//SORTIN   DD  DSN=Your input FB 1200 byte fileB,DISP=SHR               
//SORTOUT  DD SYSOUT=*
//SYSIN    DD *                           
  INREC BUILD=(1,6,X,172,2,12:C'001')     
  SORT FIELDS=(1,9,CH,A),EQUALS           
  SUM FIELDS=(12,3,ZD)                     
  OUTFIL ENDREC=20                       
//*                                       
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

Re: Sort File

Postby BillyBoyo » Wed Dec 07, 2011 4:18 am

Vineet wrote:I am Getting Required O/P, I rectified my error. Thanks for Help. but I am getting one Extra Character 'C' Please Refer below. Here 16 is the Actual Value appearing in File B Position 172,2. Regarding C I am not Sure. How To Remove C.

0000000009 T     BOGO                      16
0000000009 T     Promoted Price            16
0000000001 J     Cents Off                C 
0000000001 J     Cents Off                C 
0000000001 J     Cents Off                C 
0000000001 J     Cents Off                C 
0000000001 J     Cents Off                C 
0000000001 J     Cents Off                C


If I put your data inside the Code tags, the "C" does not line up with the value of 16. If your spacing is accurate, it is not from File B 172,2, but is the last original character of File A. Did you check there?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Previous

Return to DFSORT/ICETOOL/ICEGENER

 


  • Related topics
    Replies
    Views
    Last post