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 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 date and numeric fields and ... Rick Silvers DFSORT/ICETOOL 6 Thu May 11, 2017 6:51 pm
No new posts Check if any Detail records and extra... V S Amarendra Reddy SYNCSORT 19 Mon May 08, 2017 8:54 pm
No new posts READ A PACKED "NEGATIVE" FI... jdesouza CA Products 3 Tue May 02, 2017 11:43 pm
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts Alter &DATENS field in HEADER1 Angad DFSORT/ICETOOL 4 Mon Apr 24, 2017 11:49 am


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