IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Arithmetic operations in SYNCSORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Aravind_mf

New User


Joined: 06 Mar 2009
Posts: 13
Location: chennai

PostPosted: Wed Jul 01, 2009 2:14 pm
Reply with quote

Hi,
I have two files with 1 record in each file. The file is in the format CCYYMMDDHHMMSS. Starting position 1 and End position 14 in both files.

Ex: File1 contains 20090621152250 and file 2 contains 20090621112143

my requirement is to see if the time difference (time part in File1 - time part File2)is GE to 4 hours. ( i.e 152250 - 112143 should be >= 4 hours).
I would like to get a RC16 if the condition fails else RC0.

My shop will support only SYNCSORT. Please help me in acheiving this requirement.
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Wed Jul 01, 2009 7:41 pm
Reply with quote

Hello,

Suggest you proceed with program code.

Sort products are not designed to do date/time arithmetic.
Back to top
View user's profile Send private message
Aravind_mf

New User


Joined: 06 Mar 2009
Posts: 13
Location: chennai

PostPosted: Tue Jul 07, 2009 5:47 pm
Reply with quote

Thanks dick.

I completed the above requirement in a COBOL program
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue Jul 07, 2009 7:19 pm
Reply with quote

Good to hear it is working - thanks for the update icon_smile.gif

d
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Count Records with a crietaria in a f... DFSORT/ICETOOL 5
No new posts DFSORT/SYNCSORT/ICETOOL JCL & VSAM 8
No new posts Syncsort "Y2C" Function SYNCSORT 1
No new posts Arithmetic division using Syncsort SYNCSORT 6
Search our Forums:

Back to Top