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 

Format problem with TRAILER3

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


Joined: 25 May 2005
Posts: 59
Topics: 20

PostPosted: Wed Apr 18, 2007 6:31 am    Post subject: Format problem with TRAILER3 Reply with quote

Hi Guys,

I'm using SORT to sum fields of a record, where teh key is the same. The sum should be left aligned, but it give me allways a right alignement. can you help me?

Here is the code I use:

Code:

  SORT   FIELDS=(1,47,CH,A)                           
  RECORD TYPE=F                                       
  OUTFIL REMOVECC,NODETAIL,                           
     SECTIONS=(1,49,                                     
       TRAILER3=(1,49,X,TOT=(50,15,UFF,EDIT=(IIIIIIT.TT)), 
           65,200,201,240))       


so at position 50 I obtrain always something like:

Code:

      50.00
      50.00
       2.71
     100.00
     100.00


I would like:

Code:

50.00
50.00
2.71
100.00
100.00


What do you think about that?

Thanks 4 all help!
_________________
Maxisnowhere
Back to top
View user's profile Send private message
kolusu
Site Admin
Site Admin


Joined: 26 Nov 2002
Posts: 12378
Topics: 75
Location: San Jose

PostPosted: Wed Apr 18, 2007 7:59 am    Post subject: Reply with quote

Maxisnowhere,

You need to run another step to justify the data to the left.

Code:

 //SYSIN    DD *                             
  OPTION COPY                               
  OUTREC IFTHEN=(WHEN=INIT,                 
        OVERLAY=(51:51,10,JFY=(SHIFT=LEFT)))
/*   


Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu
Back to top
View user's profile Send private message Send e-mail Visit poster's website
maxisnowhere
Beginner


Joined: 25 May 2005
Posts: 59
Topics: 20

PostPosted: Wed Apr 18, 2007 8:52 am    Post subject: Reply with quote

Hy Kolusu,

as always ... I have still some problem. I get a RC=16 :
Code:

BLOCKSET     COPY  TECHNIQUE SELECTED                                         
VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AND MORE   
- CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 15:49 ON WED APR 18, 2007
   OPTION COPY                                                                 
   OUTREC IFTHEN=(WHEN=INIT,                                                   
   OVERLAY=(51:51,10,JFY=(SHIFT=LEFT)))                                       
                     $                                                         
OPERAND DEFINER ERROR                                                         
C5-K05352 C6-Q95214 C7-K90000 C8-K05352 E7-K90000                             
END OF DFSORT


I think is allways because we have a lach of ptf here, but they doesn't listen at my alert Sad
_________________
Maxisnowhere
Back to top
View user's profile Send private message
Frank Yaeger
Sort Forum Moderator
Sort Forum Moderator


Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose

PostPosted: Wed Apr 18, 2007 11:10 am    Post subject: Reply with quote

Yes, you need z/OS DFSORT V1R5 PTF UK90007 (April, 2006) in order to use DFSORT's JFY function. The error message indicates you don't have the PTF applied.
_________________
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
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