How to compare two ps files having millions of records ?
Moderators: Frank Yaeger, DikDude, Moderator Group
-
- Member
- Posts: 25
- Joined: Sun Feb 05, 2012 10:59 pm
- Location: Bangalore
How to compare two ps files having millions of records ?
hi,
i have two sequential files having millions of records. how can i compare both the files ?
i tried with x3.13 but it gave space abend.
could anyone help me in this ?
i have two sequential files having millions of records. how can i compare both the files ?
i tried with x3.13 but it gave space abend.
could anyone help me in this ?
- dbzTHEdinosauer
- Moderator
- Posts: 981
- Joined: Mon Oct 02, 2006 8:31 pm
when using the batch option,
i believe you have the option to EDIT the JCL before submitting the job.
you can then copy the jcl to your own 'JCL' pds,
so that you will have a working JOB which you can then edit
and modify for any SUPERC, thus negating the need to go thru the 3.xx panels.
something to keep in mind:
if the record length is larger than 133, you will not have the complete record as output.
so, unless you are using the output (of a million record compare)
as input to something else (and the record length is less than 134)
why don't you use the summary output format (giving you totals)
since i don't know what you are going to do with 100's of thousands,
if not millions of output records.....
i believe you have the option to EDIT the JCL before submitting the job.
you can then copy the jcl to your own 'JCL' pds,
so that you will have a working JOB which you can then edit
and modify for any SUPERC, thus negating the need to go thru the 3.xx panels.
something to keep in mind:
if the record length is larger than 133, you will not have the complete record as output.
so, unless you are using the output (of a million record compare)
as input to something else (and the record length is less than 134)
why don't you use the summary output format (giving you totals)
since i don't know what you are going to do with 100's of thousands,
if not millions of output records.....
Dick Brenholtz
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
JCL, SQL and code in programs have an irritating habit of doing what you say,
not what you meant.
-
- Member
- Posts: 25
- Joined: Sun Feb 05, 2012 10:59 pm
- Location: Bangalore
i have got the solution..
i used below ICETOOL toolin
i gave two files on INDD like
//INDD DD DSN=file1,DISP=SHR
// DD DSN=file2,DISP=SHR
//OUTDD DD DSN=file,DIPS=(,CATLG,) ..
..
//TOOLIN DD*
COPY FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*
it gave MAX CC=12 as both files are same.. OUTDD dsn is empty..
thnks for you suggestion too..
i used below ICETOOL toolin
i gave two files on INDD like
//INDD DD DSN=file1,DISP=SHR
// DD DSN=file2,DISP=SHR
//OUTDD DD DSN=file,DIPS=(,CATLG,) ..
..
//TOOLIN DD*
COPY FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*
it gave MAX CC=12 as both files are same.. OUTDD dsn is empty..
thnks for you suggestion too..
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
That syntax is NOT valid for the ICETOOL COPY operator. The cc=12 would be the result of the syntax error. It would have nothing to do with whether the files were the same.
For complete details on correct DFSORT/ICETOOL syntax, see:
http://www.ibm.com/support/docview.wss? ... g3T7000080
For complete details on correct DFSORT/ICETOOL syntax, see:
http://www.ibm.com/support/docview.wss? ... g3T7000080
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: 25
- Joined: Sun Feb 05, 2012 10:59 pm
- Location: Bangalore
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
Ok. The syntax for a job to get RC=12 for an empty data set would be quite different (SELECT? COUNT?) so hopefully you got it right.
In the future, please don't post syntax guesses as it just confuses people.
In the future, please don't post syntax guesses as it just confuses people.
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: 25
- Joined: Sun Feb 05, 2012 10:59 pm
- Location: Bangalore
it was not COPY.. it is SELECT..nareshv_99 wrote: //TOOLIN DD*
COPY FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*
it gave MAX CC=12 as both files are same.. OUTDD dsn is empty..
thnks for you suggestion too..
//TOOLIN DD*
SELECT FROM(INDD) to(OUTDD) ON(1,7,P,8,2,BI,10,1,CH) NODUPS
/*
Frank, sorry for posting wrong syntax..i can't post anything from my office thats why i posted what i remembered..
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
That syntax is still invalid - it should be:
SELECT FROM(INDD) TO(OUTDD) ON(1,7,PD) ON(8,2,BI) ON(10,1,CH) NODUPS
http://www.ibm.com/support/docview.wss? ... g3T7000080
So you could look up the correct syntax even from home.
SELECT FROM(INDD) TO(OUTDD) ON(1,7,PD) ON(8,2,BI) ON(10,1,CH) NODUPS
All of the DFSORT books are available at:Frank, sorry for posting wrong syntax..i can't post anything from my office thats why i posted what i remembered.
http://www.ibm.com/support/docview.wss? ... g3T7000080
So you could look up the correct syntax even from home.
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