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

Include records based on the Date


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

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Mon May 20, 2013 2:14 pm
Reply with quote

hi,

i my i/p file date field is in 4th position in the form julian date ieYYDDD.

i need to extract the todays date record.

below is sort card used,o/p is empty but still i/p has some records

INCLUDE COND=(04,05,CH,EQ,DATE3)
SORT FIELDS=COPY
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon May 20, 2013 2:19 pm
Reply with quote

Please show sample input, expected output, RECFM and LRECL, and sysout of step which did not give you what you want.
Back to top
View user's profile Send private message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Mon May 20, 2013 2:43 pm
Reply with quote

I/P

82C1314011010089907999922
82C1314027636066637999922
82C1314027636066637999922
82C1314071771203017999922
73C1213471771203017999922
73C1213471771203017999922
73C1213471771203017999922
73C1213471771203017999922

where the bolded ones are the date ,13140 is the todays julian i need the records which contains todays julian date.
record length is 110,recfm is FB
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon May 20, 2013 2:57 pm
Reply with quote

DATE3 has a four-digit year, so that is why your test does not work.

The DFSORT documentation is available online. Look at the section on "Date Comparisons".
Back to top
View user's profile Send private message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Mon May 20, 2013 2:59 pm
Reply with quote

we are using Syncsort
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon May 20, 2013 3:01 pm
Reply with quote

Hah.

See if you can guess my next response after telling you not to look at the DFSORT documentation but...

And 'Y' didn't you do it already...?
Back to top
View user's profile Send private message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Mon May 20, 2013 3:22 pm
Reply with quote

Bill,

I searched the forum and google it before posting it here... but not able to get the answer..
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon May 20, 2013 3:23 pm
Reply with quote

And your SyncSort documentation? Y'DATE3'?
Back to top
View user's profile Send private message
mf_karthik

New User


Joined: 26 Jul 2005
Posts: 55

PostPosted: Mon May 20, 2013 3:47 pm
Reply with quote

not able to get that document..if i get..i believe it will solve my problem..
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7310
Location: Inside the Matrix

PostPosted: Mon May 20, 2013 4:35 pm
Reply with quote

Did you try with Y'DATE3'?
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1586
Location: Andromeda Galaxy

PostPosted: Mon May 20, 2013 4:48 pm
Reply with quote

Hey kartik,

Bill wants you to try

Code:
INCLUDE COND=(04,05,CH,EQ,Y'DATE3')
SORT FIELDS=COPY
Back to top
View user's profile Send private message
Pandora-Box

Global Moderator


Joined: 07 Sep 2006
Posts: 1586
Location: Andromeda Galaxy

PostPosted: Mon May 20, 2013 5:05 pm
Reply with quote

Apologies

It should be

Code:
  INCLUDE COND=(4,5,Y2T,EQ,Y'DATE3')
  SORT FIELDS=COPY
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


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

PostPosted: Mon May 20, 2013 8:03 pm
Reply with quote

Hello,

If your organization is licensed to use Syncsort, all of the material is available (free) from Syncsort Support.
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 Add column to existing records using ... JCL & VSAM 2
No new posts Syncsort- Merging two records into on... SYNCSORT 3
This topic is locked: you cannot edit posts or make replies. A Rexx who changes date into a JCL?Po... CLIST & REXX 9
No new posts How to find orphaned MCDS D records. JCL & VSAM 15
This topic is locked: you cannot edit posts or make replies. include and copy COBOL Programming 4
Search our Forums:

Back to Top