SORT OUTFIL HEADER Example

In this Mainframe Forum - You can post your queries on JCL, OS/390 JCL, MVS JCL, z/OS JCL, JES2 & JES3

Moderators: Frank Yaeger, DikDude, Moderator Group

Post Reply
murali gummadi
Member
Posts: 5
Joined: Thu May 11, 2006 3:59 pm

SORT OUTFIL HEADER Example

Post by murali gummadi » Thu May 11, 2006 5:49 pm

Hi every one,
I am happy to join with this family,and plz welcome me.

1.Can any one please give me codefor

"how do we include Header and Taylor in sort command?


2.How can i get the data from tape dataset?

3.what is exact difference b/w SYSLIB And JCLLIB?

4.I Have 10 files in a step and every time when i need to run this job i want to see 9,10 files out put first?how can code the jcl for thais?remember that every file excution depends on the previous file excution(it means all input files excution must be in order)?

5.I have faced the problem with dead lock,that is if dead lock occures to my program, so i want to know that who was trying to acess the same resources which are requested by me?

plz help me out in this regard

Warm Regards,
Murali gummadi

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

Post by Frank Yaeger » Thu May 11, 2006 8:40 pm

"how do we include Header and Taylor in sort command?
I think you mean Header and Trailer. You can use DFSORT's OUTFIL statement to include header and trailer records of various types. For example, you can use the HEADER1 parameter to include report header records and the TRAILER1 parameter to include report trailer records. For example:

Code: Select all

    OPTION COPY
    OUTFIL HEADER1=('This is line1 of the report header',/,
       'This is line2 of the report header'),
      TRAILER1=('This is line1 of the report trailer',/,
       'This is line2 of the report trailer')


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

User avatar
arrbee
Active Member
Posts: 144
Joined: Fri Feb 24, 2006 11:33 am

Post by arrbee » Mon May 15, 2006 7:27 am

2.How can i get the data from tape dataset?
Get the attributes (RECFM,LRECL etc) of the TAPE DSN. Use IDCAMS REPRO to create a flat file out of it.
5.I have faced the problem with dead lock,that is if dead lock occures to my program, so i want to know that who was trying to acess the same resources which are requested by me?
Use the Master job sysout info to find out the job or program causing the contention.
Arr Bee
-------------
?My joy in learning is partly that it enables me to teach? - Seneca(Roman philosopher, mid-1st century AD)

murali gummadi
Member
Posts: 5
Joined: Thu May 11, 2006 3:59 pm

Post by murali gummadi » Mon May 22, 2006 2:35 pm

Hi,
Thanks arrbee.... for your answer
My problem was solved

Thanks and Regards
Murali

Reshmi Remadevi
Member
Posts: 2
Joined: Fri Aug 11, 2006 12:17 pm

3.what is exact difference b/w SYSLIB And JCLLIB?

Post by Reshmi Remadevi » Fri Aug 11, 2006 12:53 pm

JCLLIB tells the system to look in system-procedure libraries,installation defined libraries as well as private libraries in the order given,

//lib JCLLIB ORDER(lib1,lib2,..)

Private libraries are specified using STEPLIB.It is a DD stmt.

//step1 STEPLIB DD DSN='DSNAME',DISP=SHR

Hope it cleared your doubt.
With Regards,
Reshmi Remadevi

academyindia4

Topic deleted by Admin

Post by academyindia4 » Mon Feb 01, 2016 11:01 pm

<< Content deleted By Admin >>

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