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
 

 

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 Limit duplicate records in the SORT pshongal SYNCSORT 6 Mon Nov 21, 2016 12:54 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm
No new posts Sort records based on numeric field. Alks SYNCSORT 2 Wed Oct 19, 2016 10:14 pm
No new posts How to delete second instance from Fl... Gunapala CN DFSORT/ICETOOL 6 Tue Oct 18, 2016 11:42 pm
No new posts abend sort based on count records in ... anatol DFSORT/ICETOOL 5 Mon Oct 17, 2016 10:10 pm


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