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 Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm
No new posts SORT VSAM file with each field one by... maxsubrat DFSORT/ICETOOL 6 Tue Mar 14, 2017 1:07 pm
No new posts JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS DB-How to update a record (a sing... Nic Clouston IMS DB/DC 9 Thu Mar 09, 2017 4:38 pm
No new posts Join giving more records than expected Danielle.Filteau SYNCSORT 2 Thu Mar 09, 2017 3:28 am


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