eileena4732
New User
Joined: 26 Mar 2006
Posts: 0
|
|
|
|
I am doing a sort on the date and time fields in a syslog. Consistently produces no data in the outfile.
What is wrong with this sort?
SORT FIELDS=(20,5,CH,D,26,5,CH,D,66,4,CH,D)
INCLUDE COND=((20,5,CH,LE,C'TODAT',AND,
26,2,CH,LE,C'TH',AND,
29,2,CH,LE,C'TM',AND,
20,5,CH,GE,C'FMDAT',AND,
26,2,CH,GE,C'FH',AND,
29,2,CH,GE,C'FM')
I tried it wout the enclosed parenthesis and still no results. The constants are converted to the numeric (julien) dates and times, two digit hours and minutes. |
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
|
|
|
|
| Quote: |
| What is wrong with this sort? |
Two possibilities come to mind:
1) Your input file is VB, but you didn't take the RDW into account for the starting positions. With VB, the RDW is in positions 1-4, so the first data byte starts in position 5. If your file is VB and you specified the starting positions without taking the RDW into account, you need to add 4 to each starting position.
2) None of the records satisfies your INCLUDE conditions. Since your using AND between the conditions, every condition must be true in order for a record to be included. Given that we don't have your data or even the values you actually used in the INCLUDE statement, we can't tell you if that's the case. Try using the only the first condition and see if you get any records. If not, something's wrong with your conditions. If so, try using the first two conditions and so on. That might tell you if the problem lies with your conditions. |
|
