Re: Compare files - with different date fields

2008-06-03 Thread Reda, John
work with you if you experience any problems. John Reda Syncsort, Inc. -Original Message- From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On Behalf Of Schneiderwent, Craig Sent: Tuesday, June 03, 2008 11:53 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Re: Compare files - with diff

Re: Compare files - with different date fields

2008-06-03 Thread Galambos, Robert
MAIL PROTECTED] On Behalf Of Howard Brazee Sent: Tuesday, June 03, 2008 10:11 AM To: IBM-MAIN@BAMA.UA.EDU Subject: Compare files - with different date fields I'd like to create a compare job that will compare two files. One file should have the current date (MMDD) in columns 72-79 o

Re: Compare files - with different date fields

2008-06-03 Thread Schneiderwent, Craig
I would use SyncSort's JOIN feature (I don't have DFSORT.) //SORT1EXEC PGM=SORT //SORTJNF1 DD DISP=SHR,DSN=input.file.1 //SORTJNF2 DD DISP=SHR,DSN=input.file.2 //SYSINDD * JOINKEYS FILE=F1, FIELDS=(001,072,A,080,326,A) JOINKEYS FILE=F2, FIELDS=(001,072,A,080,326,A)

Re: Compare files - with different date fields

2008-06-03 Thread Farley, Peter x23353
> -Original Message- > From: IBM Mainframe Discussion List [mailto:[EMAIL PROTECTED] On > Behalf Of Howard Brazee > Sent: Tuesday, June 03, 2008 10:11 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Compare files - with different date fields > > I'd like to create a

Re: Compare files - with different date fields

2008-06-03 Thread McKown, John
> -Original Message- > From: IBM Mainframe Discussion List > [mailto:[EMAIL PROTECTED] On Behalf Of Steven Conway > Sent: Tuesday, June 03, 2008 9:38 AM > To: IBM-MAIN@BAMA.UA.EDU > Subject: Re: Compare files - with different date fields > > You could run ISRSUPC

Re: Compare files - with different date fields

2008-06-03 Thread Scott Barry
I have this challenge, sometimes with using SAS and its PROC COMPARE. Pre- process (copy) the BEFORE and AFTER files before the comparison, replacing the variable (date) column with a constant string in both files. Scott Barry SBBWorks, Inc. -

Re: Compare files - with different date fields

2008-06-03 Thread Steven Conway
IBM Mainframe Discussion List To IBM-MAIN@BAMA.UA.EDU cc Subject Compare files - with different date fields I'd like to create a compare job that will compare two files. One file should have the current date (MMDD) in columns 72-79 of a 406 column record, but the other shou

Compare files - with different date fields

2008-06-03 Thread Howard Brazee
I'd like to create a compare job that will compare two files. One file should have the current date (MMDD) in columns 72-79 of a 406 column record, but the other should have a different current date in the same format. My user would like to not just ignore these dates, but have somethin