how to split a file into two files based on a date

sreenatha · New User Joined: 21 Dec 2005 Posts: 7

hi ,

i have a file which has to be split into two files based on a date which is in the format 'mm-dd-yyyy' .. how can i do it??

sree

rajandhla · Posted: Tue Feb 14, 2006 5:36 pm

can you pls give the details like ,
one file contains the records which matches the given date (date is current date/?) and
the other file contains the records that doesn't match the date.

please let know the exact details

regards,
jai

sreenatha · New User Joined: 21 Dec 2005 Posts: 7

suppose the contents are as follows in the input file

details date

detail 1 02-12-2006
detail 2 02-01-2006
detail 3 12-10-2005
detail 4 01-04-2006
detail 5 05-02-2005

my requirement is as follows;

all the records which are having date greater than (current date - 3 months) must be seperated from other records

the output will be as fllows ;

detail date

detail 1 02-12-2006
detail 2 02-01-2006
detail 4 01-04-2006

other file should have the remaining records

superk · Posted: Tue Feb 14, 2006 8:57 pm

I do know enough about DFSORT to know that you will have to provide the value for (current date - 3 months) as a symbolic to DFSORT program via the SYMNAMES DD statement. Will that be possible?

rajandhla · Posted: Tue Feb 14, 2006 8:58 pm

Hope this link helps.(in this post trying to include the records between the date ranges but your requirement requires omit and include).

ibmmainframes.com/viewtopic.php?t=7537

regards,
jai

pzmohanty · New User Joined: 17 Feb 2006 Posts: 1 Location: Hyderabad

Hi,

Hope this code will solve ur problem

rajandhla · Posted: Fri Feb 17, 2006 4:01 pm

Hi Mohanthy,

Thanks it helps alot, but before i would like to clarify a question

Suppose in the temp file the record looks as
Cutoffdate , '20051105' that temp file is used in the step0200 with the dd name sysnames.

My question is when i use cutoffdate in the sort control card, will it treat as symbol name or will it take what ever the value that come after cutoffdate that start and end with codes(replaced) in the record in the temp file available at dd name sysnames.
is the sysnames is the predefined dd name.

please clarify

jai

Frank Yaeger · Posted: Fri Feb 17, 2006 9:34 pm

SYMNAMES (not sysnames) is the ddname used for DFSORT Symbol statements. The Symbol statement:

CUTOFFDATE,'20051105'

tells DFSORT to substitute C'20051105' for CUTOFFDATE wherever CUTOFFDATE is found in DFSORT or ICETOOL control statements.

DFSORT changes:

INCLUDE=(601,08,CH,GE,CUTOFFDATE)

to

INCLUDE=(601,08,CH,GE,C'20051105')

Since the job creates the CUTOFFDATE statement dynamically using the current date, the constant in the CUTOFFDATE statement will change each day.

For complete information on DFSORT Symbols, see Chapter 7 in "z/OS DFSORT Application Programming Guide":

publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/ICE1CA10/7.0?DT=20050222160456

If you're not familiar with DFSORT and DFSORT's ICETOOL, I'd suggest reading through "z/OS DFSORT: Getting Started". It's an excellent tutorial, with lots of examples, that will show you how to use DFSORT, DFSORT's ICETOOL and DFSORT Symbols. You can access it online, along with all of the other DFSORT books, from:

Use [URL] BBCode for External Links

rajandhla · Posted: Fri Feb 17, 2006 11:01 pm

Thanks Frank for the clarification.