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 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 SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts LISTIDR compiled date/time jerryte IBM Tools 3 Thu Apr 20, 2017 7:37 pm
No new posts SUBSTR for Date functions Shaheen Shaik DB2 4 Thu Apr 06, 2017 2:14 pm


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