MVSFORUMS.com

gps_94 · Beginner Joined: 03 Aug 2018 Posts: 4 Topics: 2

Hi,

I have a below requirement:

File Length: 160

Start Date field starts at position 81 (YYYY-MM-DD) and stop date starts at position 101 (YYYY-MM-DD)

I need to extract the records for data missed for 21st Nov 2018

So conditions would be :

Records which has Start Date as 2018-11-21 or
Records which has Stop Date as 2018-11-21 or
Records with this date (2018-11-21) which can fall between any date range for example

Start date 2018-01-01 and Stop Date 2018-12-05

How can I achieve it through DFSORT.
_________________
Mainframe Developer

gps_94 · Beginner Joined: 03 Aug 2018 Posts: 4 Topics: 2

Below is the data looks like from position 75.

+----8----+----9----+----0----+----1----+----2----+----3
********************************* Top of Data **********
,TEST,2006-11-06,06:00:00,2006-11-06,09:20:00, 1, 0
,TEST,2006-11-06,06:00:00,2006-11-06,09:58:00, 1, 0
,TEST,2006-11-06,06:00:00,2006-11-06,12:08:00, 1, 0
,TEST,2006-11-06,06:00:00,2006-11-06,12:19:00, 1, 0
,TEST,2006-11-06,06:00:00,2006-11-06,13:05:00, 1, 0
_________________
Mainframe Developer

Nic Clouston · Posted: Tue Feb 05, 2019 6:23 am Post subject:

Please do not post on multiple forums at the same time. Your topic on another forum will be deleted.
_________________
Utility and Program control cards are NOT, repeat NOT, JCL.

Terry_Heinze · Posted: Tue Feb 05, 2019 9:12 am Post subject:

gps 94,
Please code tags for readability:

kolusu · Posted: Tue Feb 05, 2019 12:15 pm Post subject:

gps_94,

Please do not post the questions across multiple helpboards. Pick a board of your choice (I don't care if it is a competitor board) and if you do not get the answer within reasonable time (8 hours min) then only you can post on this board.

Please use code tags which makes the data readable and retains the spacing. Terry Heinze has shown you how to use code tags. Also check this link which explains in detail about using code tags

https://www.mvsforums.com/helpboards/viewtopic.php?p=19031#19031

Assuming your start and stop dates are all Valid dates then you can use UFF format to filter the records. If you have invalid stop dates (ex: 20180230) then those records will also be picked. However you can perform validation on such records and remove them in the same pass. You just need to use INREC or OUTREC and then have another INCLUDE on OUTFIL to filter the invalid records.