Need help on SORT

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
Navajyoti Baruah
Member
Posts: 2
Joined: Wed Apr 04, 2018 5:06 pm

Need help on SORT

Post by Navajyoti Baruah » Wed Apr 04, 2018 9:58 pm

Hi All,

I need a help from you to sort data from an input file based on the reference date present in it from column 55 to 62. My requirement is to sort out data which has been last referenced within 3 months.

Please note that the reference date is present in the format YY/DD/MM (e.g: 18/03/14 etc).

I have tried the below sort code but it works only when the date format is YYYY/MM/DD. But my requirement is to sort data from the input file which is in the format YY/DD/MM. So can anyone please help me
--------------------------------------------------------------------------------
//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,CH,GT,DATE1(-)-90)
/*
--------------------------------------------------------------------------------[/img]

Pk
Member
Posts: 2
Joined: Fri Apr 06, 2018 3:35 pm
Location: Mumbai

Post by Pk » Fri Apr 06, 2018 6:55 pm

Hi Navajyoti Baruah

Try this code and let me know if it is working for you ?

//SYSIN DD *
SORT FIELDS=COPY
INCLUDE COND=(55,8,Y2W,GT,Y'DATE1'-90)

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