I'm new to JCL programming. I have a clarification in JCL; again I don't know whether I could ask the question here, In JCL,
Question 1:
I have created a program to extract information from a set of dataset(s). I tried with 1 dataset with some condition and it gives me the output size of 10 megabytes and tried with 10 dataset(s) with the same condition in one JCL program and it gives me the output size of 10 megabytes. Is there a size limit for JCL output file. If yes, how could I increase from 10megabytes to 20megabytes? and what is maximum limit I could increase.
Question 2:
If I want to filter the records using a JCL include condition, how should I specify the condition for my specific need. Please refer the below example records.
e.g:
20060320 B6J8 PK E2156B 04 0PK74 0009 2
20060320 B6J8 PK E2156B 04 0PK74 0012 1
20060320 B6J8 PK E2156B 29 *I+ 0014 1
20060320 B6J8 PK E2156B 34 QC/+ 0016 1
In the above records column position 30,2 I want to filter the 2bytes from the position 30-31 and it should be alphabets or numeric (both 2 bytes should be alphabets or numeric)
Thanks in advance. Bala
JCL - INCLUDE Condition - SORT INCLUDE COND
Moderators: Frank Yaeger, DikDude, Moderator Group
-
- Member
- Posts: 2
- Joined: Fri Mar 31, 2006 7:54 am
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
1. The size of the output data set depends on the space you allocated for it. For example, if you specify SPACE=(CYL,(5,5)), you'll get a primary of 5 cylinders and secondaries of 5 cylinders as needed. To increase the size of the output data set, increase the space you allocate for it.
2. You can use a DFSORT job like this to do what you want. I'm assuming by alpahabetic you mean 'A'-'Z' and by numeric you mean '0'-'9'.
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
2. You can use a DFSORT job like this to do what you want. I'm assuming by alpahabetic you mean 'A'-'Z' and by numeric you mean '0'-'9'.
Code: Select all
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file
//SORTOUT DD DSN=... output file
//SYSIN DD *
OPTION COPY
INCLUDE FORMAT=SS,
COND=(30,1,EQ,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789',AND,
31,1,EQ,C'ABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789')
/*
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
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
-
- Member
- Posts: 2
- Joined: Fri Mar 31, 2006 7:54 am
JCL - INCLUDE Condition
Hi,
First, I have no idea how the cylinder definition work, how many do I need to define as the primary and how many as the secondary in order to capture all the data I need. Secondly, do I have a limit on how many cylinders I can define in our JCL?
how do I decide how many primary/secondary cylinders to define.
Thanks in advance.
Bala
First, I have no idea how the cylinder definition work, how many do I need to define as the primary and how many as the secondary in order to capture all the data I need. Secondly, do I have a limit on how many cylinders I can define in our JCL?
how do I decide how many primary/secondary cylinders to define.
Thanks in advance.
Bala
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
That's something you have to determine based on the amount of data you'll be writing to the output data set and the capacity of the devices you're using for output. There are formulas for how much data fits on a track, cylinder, etc for each type of device.
If your output data set size will be equal to your input data set size, you can just look at the space information for the input data set and allocate the same amount for the output data set. One way to check the space used for the input data set is with ISPF 3.2.
This is pretty basic JCL stuff. I'd suggest doing some reading or taking a class.
If your output data set size will be equal to your input data set size, you can just look at the space information for the input data set and allocate the same amount for the output data set. One way to check the space used for the input data set is with ISPF 3.2.
This is pretty basic JCL stuff. I'd suggest doing some reading or taking a class.
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
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
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
- Cobol Interview Questions
50+ Interview Questions - JCL Interview Questions
50+ Interview Questions - DB2 Interview Questions
100+ Interview Questions - CICS Interview Questions
70+ Interview Questions - VSAM Interview Questions
27 Interview Questions
Other References
Mainframe Tools and others
- XPEDITER Reference
Explains how we can debug a program - FILEAID Reference
Explains how to browse , edit and delete datasets - Change Man Reference
Quick Start tutorial on Changeman - Abend Reference
Important Abend codes explained - FaceBook Page
MainframeGurukul FaceBook Page - LinkedIn Page
MainframeGurkul Linkedin Page