removing the duplicate record and picking up the last entery
Moderators: Frank Yaeger, DikDude, Moderator Group
-
- Member
- Posts: 1
- Joined: Wed Nov 01, 2006 4:01 pm
- Location: Kolkata
removing the duplicate record and picking up the last entery
There is a log file (ESDS) which will contain information records. When ever the information is updated online (CICS) one log entry created. I need to select the latest entry from the log file to prepare the extract file (sequential file). The information record does not contain any field that signifies the latest entry. So I need to pick up the last entry that has been entered. How I can do this using jcl? I don't have provision to write program.
Babu
-
- Member
- Posts: 3
- Joined: Sun May 21, 2006 11:26 pm
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
Babu,
If you want to write the last record in the VSAM input file to an output file, you can use a DFSORT job like this:
If you want to do something else, you need to explain more clearly what you want to do. An example of the input records and expected output records would help.
If you want to write the last record in the VSAM input file to an output file, you can use a DFSORT job like this:
Code: Select all
//S1 EXEC PGM=ICEMAN
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN=... input file (VB or VSAM)
//SORTOUT DD DSN=... output file (VB or VSAM)
//SYSIN DD *
* Reformat record to:
* |RDW|seqnum|data|
INREC BUILD=(1,4,5:SEQNUM,8,ZD,13:5)
* Sort descending on seqnum to get last record
* as first record.
SORT FIELDS=(5,8,ZD,D)
* Keep the last record and reformat record back to:
* |RDW|data|
OUTFIL ENDREC=1,BUILD=(1,4,5:13)
/*
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