Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Include records based on the Date

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: Include records based on the Date
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Mon May 20, 2013 2:19 pm    Post subject: Reply to: Include records based on the Date
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    Post subject: Reply to: Include records based on the Date
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Mon May 20, 2013 2:57 pm    Post subject: Reply to: Include records based on the Date
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    Post subject: Reply to: Include records based on the Date
Reply with quote

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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Mon May 20, 2013 3:01 pm    Post subject: Reply to: Include records based on the Date
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    Post subject: Reply to: Include records based on the Date
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Mon May 20, 2013 3:23 pm    Post subject: Reply to: Include records based on the Date
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    Post subject: Reply to: Include records based on the Date
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

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7228

PostPosted: Mon May 20, 2013 4:35 pm    Post subject: Reply to: Include records based on the Date
Reply with quote

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

Moderator


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

PostPosted: Mon May 20, 2013 4:48 pm    Post subject:
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

Moderator


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

PostPosted: Mon May 20, 2013 5:05 pm    Post subject:
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

Site Director


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

PostPosted: Mon May 20, 2013 8:03 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us