SYNCSORT Adding date in Sort step

sreerocks · New User Joined: 18 Jun 2008 Posts: 9 Location: chennai

Hi,

I wanted to add one offset value to a date parameter in a sort step.
Is it possible to use something like (&DATE,ADD,1...) in OUTREC ?

Could someone help me out with the correct syntax

Thanks
sree

Arun Raj · Posted: Thu Dec 04, 2008 1:02 pm

sreerocks,

What offset you want to add? Please post some examples of input and output records.

sreerocks · New User Joined: 18 Jun 2008 Posts: 9 Location: chennai

for example: I want to add 1 day to 2008-12-05

Thanks
sree

Arun Raj · Posted: Thu Dec 04, 2008 5:16 pm

sreerocks,

Offset to current date can be obtained using the below format. I cant test this feature now as it is available only in Syncsort for z/OS Release 1.3 or above.

&DATE [{±}nnnn] where '+' indicates a date after the current date and '–' indicates a date before the current date. 'nnnn' is the date offset. The range is 0 to 9999, which represents the number of days to be added or subtracted from the current date.

sreerocks · New User Joined: 18 Jun 2008 Posts: 9 Location: chennai

Thanks arun..

I was wondering whether we can add some offset to a date other than
current date.

Thanks
sree

Arun Raj · Posted: Thu Dec 04, 2008 6:58 pm

sreerocks,

I believe there are no built-in functions in Syncsort or DFSORT to do such arithmetic on a date field. Alissa/Frank might be able to explain further.

Alissa Margulies · Posted: Thu Dec 04, 2008 10:05 pm

(post removed)

gcicchet · Posted: Fri Dec 05, 2008 3:22 am

Hi,

for DFSORT check this out

ibmmainframes.com/viewtopic.php?t=35250&highlight=y2w+gt+y

Gerry

Arun Raj · Posted: Fri Dec 05, 2008 7:20 am

Gerry,

Thanks for the link. But the topic discusses about date comparison with an offset of current-date. Here, we talk about how to generate an offset of an input date field .

gcicchet · Posted: Fri Dec 05, 2008 8:19 am

Hi Arun,

thanks for spotting my failure to read the thread correctly

Gerry

Arun Raj · Posted: Fri Dec 05, 2008 9:28 am

Alissa,

I tried executing the Syncsort job suggested by you; but ended up in the below syntax error. Is this a feature included in Syncsort for z/OS Release 1.3?

srinivas_cog · New User Joined: 05 Jun 2008 Posts: 17 Location: chennai

Arun,

It is working fine for SYNCSORT FOR Z/OS 1.3

Arun Raj · Posted: Fri Dec 05, 2008 12:40 pm

Kasu,

Thanks for letting me know.

Arun Raj · Posted: Fri Dec 05, 2008 8:51 pm

Frank Yaeger · Posted: Fri Dec 05, 2008 11:25 pm

Alissa Margulies · Posted: Sat Dec 06, 2008 12:25 am

Based on Frank's statements, I ran some additional tests. My previous example will not work properly for all dates. (I will remove the incorrect code).

Arun's original statement is correct. Sreerocks, I would recommend finding an alternative solution for this requirement since SORT does not have an easy solution for your requirement at this time.

Arun Raj · Posted: Sun Dec 07, 2008 5:35 pm

Frank Yaeger · Posted: Mon Dec 08, 2008 6:18 am

Ok, I guess that's a valid reason why you care. But, in general, if you want to know something about DFSORT, I'd prefer that you ask the question in the DFSORT Forum. I tend not to participate in discussions specifically about Syncsort (although I may do so to correct or question something when appropriate, as in this case).