Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums 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: 7315

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

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

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

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

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: 1542
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: 1542
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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Execute JCL step based on the content... sprikitik JCL & VSAM 2 Tue Oct 03, 2017 10:03 am
No new posts How to insert a value on specific pos... Poha Eater DFSORT/ICETOOL 9 Sun Oct 01, 2017 3:04 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm

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