Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 7312

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: 7312

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: 7312

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: 7312

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: 7312

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: 1568
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: 1568
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: 19254
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 DFSMShsm Dataset Recovery with B and ... Joerg.Findeisen JCL & VSAM 0 Sat Oct 05, 2019 10:01 pm
No new posts Mainframe datasets without any last r... rajatbagga All Other Mainframe Topics 1 Tue Sep 24, 2019 8:47 am
No new posts Duplicating records in a PDS memebr/I... imcoolleo COBOL Programming 5 Mon Sep 16, 2019 3:32 pm
No new posts Need to fetch data from database base... Satandale COBOL Programming 8 Sun Sep 08, 2019 12:01 am
No new posts Select based on a range from a differ... sergeyken SYNCSORT 2 Fri Aug 16, 2019 12:37 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us