Can we generate a report using sort???

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
deepu
Member
Posts: 15
Joined: Fri Apr 24, 2009 10:40 am

Can we generate a report using sort???

Post by deepu » Tue Apr 28, 2009 4:00 pm

Hi,

My output file have some 100 records...let's assume the file contains student details...

Example:

SURESH 95 85 75 40 KUMAR XXXSCHOOL XXXCITY....
RAMESH 95 85 75 40 KUMAR XXXSCHOOL XXXCITY....
.
.
.
.i want to insert/put headers(headings) for each field...like

NAME ENGLISH MATHS COMMERCE LASTNAME

SURESH 95 85 75 KUMAR
RAMESH 95 85 75 KUMAR

is it possible to include/insert headings like above using sort/icetool/...

Thanks in Advance,
deepu.

maheshvamsi
Active Member
Posts: 52
Joined: Wed Mar 25, 2009 11:56 pm
Location: Banglore

Post by maheshvamsi » Tue Apr 28, 2009 4:44 pm

Try this sort solution:

Code: Select all

//SORT1    EXEC PGM=SORT                                               
//SYSPRINT   DD SYSOUT=*                                               
//SYSOUT     DD SYSOUT=*                                               
//SORTIN     DD *                                                      
SURESH 95 85 75 KUMAR                                                  
RAMESH 75 85 75 KUMAR                                                  
/*                                                                     
//SORTOUT    DD SYSOUT=*                                               
//SYSIN      DD *                                                      
    SORT FIELDS=COPY                                                   
    INREC FIELDS=(1:1,6,10:8,2,20:11,2,30:14,2,40:17,20)               
    OUTFIL HEADER1=(1:C'NAME',10:C'ENGLISH',20:C'MATHS',30:C'COMMERCE',
            40:C'LASTNAME')                                            
/*                                                                     
Output WIll be:

Code: Select all

NAME     ENGLISH   MATHS     COMMERCE  LASTNAME     
SURESH   95        85        75        KUMAR        
RAMESH   75        85        75        KUMAR        
Thanks

MaheshVamsi

User avatar
Frank Yaeger
Moderator
Posts: 812
Joined: Sat Feb 18, 2006 5:45 am
Location: San Jose, CA
Contact:

Post by Frank Yaeger » Tue Apr 28, 2009 8:32 pm

You can also do this with the DISPLAY operator of DFSORT's ICETOOL. For details and examples, see:

http://publibz.boulder.ibm.com/cgi-bin/ ... 0528171007

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

www.ibm.com/servers/storage/support/sof ... tmpub.html
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others