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 field

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
tanguduk
Warnings : 1

New User


Joined: 29 Aug 2005
Posts: 14

PostPosted: Tue Sep 30, 2008 3:03 pm    Post subject: Include records based on the date field
Reply with quote

Hi ,

I wanted to include records based on the date field like, I want the records which are less than '1995-01-01'. How to achieve this . Please suggest.

Regards
kiran
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Sep 30, 2008 3:06 pm    Post subject:
Reply with quote

What record format is the input file.
Where in the input file are the date records.
What format are the date records stored in.
What happens to the records omitted from the sort.
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Tue Sep 30, 2008 3:12 pm    Post subject:
Reply with quote

Hi,

is file VB or FB ?

what is LRECL ?

is the date field in a set position ?

is the date field in the format of YYYY-MM-DD ?

Some data examples would not go astray.


Gerry
Back to top
View user's profile Send private message
tanguduk
Warnings : 1

New User


Joined: 29 Aug 2005
Posts: 14

PostPosted: Tue Sep 30, 2008 3:18 pm    Post subject: sort on date criteria
Reply with quote

Hi,

Its a FB format , and record length is 125, and the postion of the date positon in the file is 56 format is yyyy-mm-dd. I want the records which are less than '1995-01-01' this date

Regards
Kiran
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Sep 30, 2008 3:20 pm    Post subject:
Reply with quote

What have you coded and what were the results ?
Back to top
View user's profile Send private message
ksk

Active User


Joined: 08 Jun 2006
Posts: 356
Location: New York

PostPosted: Tue Sep 30, 2008 4:33 pm    Post subject:
Reply with quote

Code the following condition.

Code:

   OPTION COPY
   INCLUDE COND=(56,10,CH,LT,C'1995-01-01')
Back to top
View user's profile Send private message
tanguduk
Warnings : 1

New User


Joined: 29 Aug 2005
Posts: 14

PostPosted: Tue Sep 30, 2008 5:50 pm    Post subject: Reply to: Sort the records based on the date field
Reply with quote

i have got the results thank you
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 -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am
No new posts More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Remove leading spaces from numeric field rexx77 SYNCSORT 6 Wed Sep 06, 2017 2:15 am
No new posts JES2 job size field matching Windows ... SRICOBSAS All Other Mainframe Topics 4 Tue Sep 05, 2017 5:49 pm

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