|
View previous topic :: View next topic
|
| Author |
Message |
som_infotech
New User
Joined: 25 Feb 2006
Posts: 38
Location: chennai-india
|
|
|
|
Hi All,
In fileaid we have BT operator to get the values between a range.
For example in column 11 if we have values between 20 & 25 then we can split by providing BT 20:25. Is there similar method in sort to do it ?? |
|
| Back to top |
|
 |
sqlcode1
Active Member
Joined: 08 Apr 2010
Posts: 577
Location: USA
|
|
|
|
som_infotech,
Nothing in DFSort like BETWEEN as a keyword but similar logic can be written in sort. What exactly you are trying to do? Please show us sample input, expected output along with LRECL and RECFM of the input file.
Meanwhile RANGE gives you count of values between in a specified range, if that is what you are looking for.
Thanks, |
|
| Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix
|
|
|
|
Hello,
As mentioned, it is best to post some sample data and the output you want from the sample data. Mention the recfm and lrecl of the files and all of the processing rules.
One way to do what you want is to use INCLUDE or OMIT. |
|
| Back to top |
|
|
|
|
