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: 8619
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: 8619
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: 355
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 ISSUE IN copying Sequential file reco... thesumitk JCL & VSAM 2 Wed Dec 13, 2017 3:07 pm
No new posts Merging 2 records at multiple rows wi... Bijesh DFSORT/ICETOOL 2 Wed Dec 06, 2017 1:50 am
No new posts Fetching data from JHS as per the cur... arunsoods All Other Mainframe Topics 4 Wed Nov 22, 2017 1:54 pm
No new posts Date in where clause - Windows Karthikeyan Subbarayan DB2 9 Wed Nov 15, 2017 9:07 pm
No new posts Split files upto certain limit based ... bubbu75 DFSORT/ICETOOL 5 Tue Nov 14, 2017 11:11 pm

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