hi,
i have one file with date. i need to read the date and increment by 1 and write output file. is this possible in sort card
Sort on date
Moderators: Frank Yaeger, Moderator Group
jairam baju,
what kind of date are we talking in here? Is it a current date? If it is current date then it is very easy
If it is any other date , then it would be tricky.
At any rate I need the following details.
1. what is the lrecl and recfm of the input and output files?
2. What is the position and format of the date field
what kind of date are we talking in here? Is it a current date? If it is current date then it is very easy
If it is any other date , then it would be tricky.
At any rate I need the following details.
1. what is the lrecl and recfm of the input and output files?
2. What is the position and format of the date field
-
- Member
- Posts: 10
- Joined: Thu Jul 30, 2009 8:11 pm
- Location: Bangalore
-
- Member
- Posts: 25
- Joined: Tue Apr 28, 2009 10:53 pm
- Location: USA
- Contact:
- Frank Yaeger
- Moderator
- Posts: 812
- Joined: Sat Feb 18, 2006 5:45 am
- Location: San Jose, CA
- Contact:
DFSORT does not have built-in functions for arithmetic on date/time fields either.
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
Jairam_baju,
With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct, 2010), DFSORT can now add days to a given date quite easily like shown below.
The output from this job is
For complete details on the new DFSORT and ICETOOL functions available with the Oct, 2010 PTF, see:
http://www.ibm.com/support/docview.wss? ... g3T7000242
With z/OS DFSORT V1R10 PTF UK90025 or z/OS DFSORT V1R12 PTF UK90026 (Oct, 2010), DFSORT can now add days to a given date quite easily like shown below.
Code: Select all
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD *
----+----1----+----2----+----3----+----4----+----5
20101029
//SORTOUT DD SYSOUT=*
//SYSIN DD *
SORT FIELDS=COPY
INREC OVERLAY=(10:1,8,Y4T,ADDDAYS,+1,TOGREG=Y4T)
//*
The output from this job is
Code: Select all
20101029 20101030
http://www.ibm.com/support/docview.wss? ... g3T7000242
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