MVSFORUMS.com

kanitha-mvs · Beginner Joined: 17 May 2006 Posts: 26 Topics: 17

Hi,

I want to construct the sort card to extract records in current date.
INCLUDE COND=(65,10,CH,EQ,C'02/02/2009')
Here the date needs to be changed based on current date.
Is it possible to do it in jcl itself? or do i need to write a cobol program to construct this sort card?

Thanks,
K.anitha

oneofspace · Beginner Joined: 18 Nov 2008 Posts: 33 Topics: 14

Hi

You can use the following job

kolusu · Posted: Mon Feb 02, 2009 11:18 am Post subject:

kanitha-mvs,

You really dont have to generate the control cards for the date. You can use system symbols as a system symbol string in DFSORT and generate the date.

Pickdate will have current date in mm/dd/ccyy format and we can use that to include the records we need

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Try this,

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

Oh..Is this (PICKDATE) new feature?

Do we have link to IBM website?

Frank Yaeger · Posted: Mon Feb 02, 2009 11:38 am Post subject:

It's not a new feature. PICKDATE is a DFSORT Symbol created from system symbols for the parts of the date (mon, day, year) using an S-constant. The use of S-constants for DFSORT Symbols has been available since April, 2006. It's fully documented in "z/OS DFSORT Application Programming Guide" available at:

www.ibm.com/systems/support/storage/software/sort/mvs/srtmpub.html
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort

ranga_subham · Intermediate Joined: 31 Jan 2006 Posts: 255 Topics: 72

Sqlcode, what is the purpose of below in OUTREC Overlay?

kanitha-mvs · Beginner Joined: 17 May 2006 Posts: 26 Topics: 17

Thanks all of you for your time & help in this..

Thanks a lot kolusu. It works.
Also, is there any S constant available for time?

My requirement is to filter records having "current time - 1 hour " in the time field of the record. In the input record, time field is in "HH:MM" format.(E.G 22.10, 07.10)

From the ibm link provided by Frank, I could see the reserved words TIME1, TIME1P etc.. but am not able to find out the usage of those keywords.. Please help me in this..

kolusu · Posted: Tue Feb 03, 2009 11:09 am Post subject:

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

ranga_subham

If you check input file, I have

Sqlcode · Intermediate Joined: 15 Dec 2006 Posts: 157 Topics: 38

ranga_subham,
Correction in the earlier post,

Even if you don't code

kanitha-mvs · Beginner Joined: 17 May 2006 Posts: 26 Topics: 17

Hi Kolusu,

This job would be scheduled in OPCE in one hour interval. So it would run exactly at 00.00 and 01.00. In 00.00 run, I would need to check the records with value in time column between 11.00 PM and 00.00 AM. Is this possible to do in JCL? or should I write cobol program to accomplish this task? Please give me suggestion..

Thanks a lot for your help in this

kolusu · Posted: Thu Feb 05, 2009 11:50 am Post subject:

kanitha-mvs,

The following JCL will give you the desired results. I assumed that your input file is 80 bytes LRECL and FB format. The date in the file begins at pos 65 and the time at pos 75 for 5 bytes.

This job picks the records in range hh.00 - hh.59

Phantom · Posted: Fri May 01, 2009 4:31 pm Post subject:

Hi,

Its been quite a while since I posted a message in MVSFORUMS. I got a bit out of date on several topics.

I am using SYNCSORT for z/OS 1.2.3.1R. Can someone let me know if syncsort has any operator equivalent to the 'S'-constants in DFSORT ?

thanks
Phantom