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 only those records with a date LT current

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

New User


Joined: 21 Dec 2005
Posts: 19

PostPosted: Wed May 17, 2006 6:25 pm    Post subject: Include only those records with a date LT current
Reply with quote

HI FRANK

I WANT TO INCLUDE ONLY THOSE RECORDS WHICH ARE HAVING A DATE
LESS THAN THE CURRENT DATE.

THE DATE FORMAT IS "CCYMMDD" AND IT IS A PART OF THE RECORD.

IS THERE ANY WAY I CAN DO THIS EASILY??
Back to top
View user's profile Send private message

aditya_gorti

New User


Joined: 21 Dec 2005
Posts: 19

PostPosted: Wed May 17, 2006 6:50 pm    Post subject:
Reply with quote

HI FRANK,

SORRY, THE DATE FORMAT IS "CYYMMDD".

THANX
Back to top
View user's profile Send private message
rajandhla

Active User


Joined: 18 Oct 2005
Posts: 182
Location: Luton UK

PostPosted: Wed May 17, 2006 7:29 pm    Post subject:
Reply with quote

Hi,

Check the following link

http://www-03.ibm.com/servers/storage/support/software/sort/mvs/professor_sort/srtmaiod.html


Regards
jai
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed May 17, 2006 8:32 pm    Post subject:
Reply with quote

Quote:
SORRY, THE DATE FORMAT IS "CYYMMDD".


C - only one digit for the year? For CCYYMMDD, I would expect CC to be '19', '20', '21', etc. But with only one digit for the year, you need to tell me what values C can have.

What is the starting position, length and format of the date field?

What is the RECFM and LRECL of the input file?

BTW: Please don't use all uppercase - it's equivalent to shouting.
Back to top
View user's profile Send private message
aditya_gorti

New User


Joined: 21 Dec 2005
Posts: 19

PostPosted: Thu May 18, 2006 3:25 pm    Post subject:
Reply with quote

sorry Frank,

I wouldn't even think of shouting at you.

The date format is same as I mentioned. I guess that's what the requirement is!

RECFM: FBA
LRECL: 423
Starting pos: 218

Anyway I tried the following sort card

INCLUDE COND=(219,6,Y2T,LE,Y'DATE1')

it worked fine but im still confused abt the C thing...
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Thu May 18, 2006 9:10 pm    Post subject:
Reply with quote

I suspect the c is 0 for '19', 1 for '20', etc lor something like that. You're ignoring c and using Y2T for the yymmdd date. That may or may not always work depending on what c represents and what values the dates have for c. Run this DFSORT/ICETOOL job to display all of the values for c and post them:

Code:

//S1 EXEC PGM=ICETOOL
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=
//IN DD DSN=...  input file
//SHOW DD SYSOUT=*
//TOOLIN DD *
OCCUR FROM(IN) LIST(SHOW) ON(218,1,CH) BLANK
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 Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts TOT & DATE parameter in ICEMAN hemanthj642 DFSORT/ICETOOL 4 Mon Nov 14, 2016 5:19 am
This topic is locked: you cannot edit posts or make replies. How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm
No new posts How to split the records using the am... vnktrrd DFSORT/ICETOOL 24 Fri Oct 28, 2016 7:33 pm


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