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 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 sort records based on length exceeds ... maxsubrat DFSORT/ICETOOL 7 Wed Oct 04, 2017 4:48 pm
No new posts Addition of two records on 2 fields amar143 SYNCSORT 8 Tue Oct 03, 2017 11:14 am
No new posts Compare yesterday's date to the one o... migusd SYNCSORT 11 Fri Sep 22, 2017 11:35 pm
No new posts Comparing 2 Files using Current time arunsoods SYNCSORT 9 Fri Sep 22, 2017 6:00 pm
No new posts Validate the Date girishb2 DFSORT/ICETOOL 9 Tue Sep 19, 2017 1:12 am

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