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
 
SORT FAILING...

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
eileena4732

New User


Joined: 26 Mar 2006
Posts: 0

PostPosted: Fri Mar 24, 2006 10:52 pm    Post subject: SORT FAILING...
Reply with quote

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.
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: Fri Mar 24, 2006 11:28 pm    Post subject:
Reply with quote

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.
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 JOINKEYS Paired and Unpaired Sort MFwhiz DFSORT/ICETOOL 4 Fri Sep 29, 2017 1:48 am
No new posts Difference in SORT & ICETOOL Mohan Kothakota DFSORT/ICETOOL 5 Fri Sep 22, 2017 4:56 pm
No new posts OC4 in SORT Mohan Kothakota DFSORT/ICETOOL 2 Tue Sep 12, 2017 6:30 pm
No new posts SORT Trailer Count - LRECL Output co... amorante DFSORT/ICETOOL 5 Tue Aug 29, 2017 8:57 pm

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