View previous topic :: View next topic
|
Author |
Message |
aditya_gorti
New User
Joined: 21 Dec 2005 Posts: 19
|
|
|
|
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 |
|
|
aditya_gorti
New User
Joined: 21 Dec 2005 Posts: 19
|
|
|
|
HI FRANK,
SORRY, THE DATE FORMAT IS "CYYMMDD".
THANX |
|
Back to top |
|
|
rajandhla
Active User
Joined: 18 Oct 2005 Posts: 182 Location: Luton UK
|
|
Back to top |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
aditya_gorti
New User
Joined: 21 Dec 2005 Posts: 19
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
|