|
View previous topic :: View next topic
|
| Author |
Message |
mf_karthik
New User
Joined: 26 Jul 2005
Posts: 55
|
|
|
|
hi,
i my i/p file date field is in 4th position in the form julian date ieYYDDD.
i need to extract the todays date record.
below is sort card used,o/p is empty but still i/p has some records
INCLUDE COND=(04,05,CH,EQ,DATE3)
SORT FIELDS=COPY |
|
| Back to top |
|
 |
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Please show sample input, expected output, RECFM and LRECL, and sysout of step which did not give you what you want. |
|
| Back to top |
|
|
mf_karthik
New User
Joined: 26 Jul 2005
Posts: 55
|
|
|
|
I/P
82C1314011010089907999922
82C1314027636066637999922
82C1314027636066637999922
82C1314071771203017999922
73C1213471771203017999922
73C1213471771203017999922
73C1213471771203017999922
73C1213471771203017999922
where the bolded ones are the date ,13140 is the todays julian i need the records which contains todays julian date.
record length is 110,recfm is FB |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
DATE3 has a four-digit year, so that is why your test does not work.
The DFSORT documentation is available online. Look at the section on "Date Comparisons". |
|
| Back to top |
|
|
mf_karthik
New User
Joined: 26 Jul 2005
Posts: 55
|
|
|
|
| we are using Syncsort |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
Hah.
See if you can guess my next response after telling you not to look at the DFSORT documentation but...
And 'Y' didn't you do it already...? |
|
| Back to top |
|
|
mf_karthik
New User
Joined: 26 Jul 2005
Posts: 55
|
|
|
|
Bill,
I searched the forum and google it before posting it here... but not able to get the answer.. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| And your SyncSort documentation? Y'DATE3'? |
|
| Back to top |
|
|
mf_karthik
New User
Joined: 26 Jul 2005
Posts: 55
|
|
|
|
| not able to get that document..if i get..i believe it will solve my problem.. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
|
|
|
|
| Did you try with Y'DATE3'? |
|
| Back to top |
|
|
Pandora-Box
Global Moderator
.jpg)
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Hey kartik,
Bill wants you to try
| Code: |
INCLUDE COND=(04,05,CH,EQ,Y'DATE3')
SORT FIELDS=COPY |
|
|
| Back to top |
|
|
Pandora-Box
Global Moderator
Joined: 07 Sep 2006
Posts: 1592
Location: Andromeda Galaxy
|
|
|
|
Apologies
It should be
| Code: |
INCLUDE COND=(4,5,Y2T,EQ,Y'DATE3')
SORT FIELDS=COPY |
|
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
If your organization is licensed to use Syncsort, all of the material is available (free) from Syncsort Support. |
|
| Back to top |
|
|
|
|
