IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Using Decimal Points at the Include Cond.


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
ozgurseyrek

New User


Joined: 22 Feb 2008
Posts: 70
Location: Turkey

PostPosted: Fri Mar 25, 2011 9:23 pm
Reply with quote

I want to use PD numbers with decimal points at Inculde Conditions;

For example;
....
SORT FIELDS=COPY
INCLUDE COND=(1,9,PD,GT,11.50)
....

I Want to Include the numbers greater than 11,50 to the output dataset.
How can I achive that?
Thanks..
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2455
Location: Hampshire, UK

PostPosted: Fri Mar 25, 2011 10:04 pm
Reply with quote

In packed decimal decimal points are notional - they do not exist except in your head - so compare to 1150 instead of 11.50
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA

PostPosted: Fri Mar 25, 2011 11:41 pm
Reply with quote

ozgurseyrek,

Nic is correct. PD values do NOT have the decimal point stored internally, so the value would be stored as PL9'1150' = X'00000000000001150C'
and the constant to use in INCLUDE would be 1150, not 11.50.
Back to top
View user's profile Send private message
ozgurseyrek

New User


Joined: 22 Feb 2008
Posts: 70
Location: Turkey

PostPosted: Mon Mar 28, 2011 11:41 am
Reply with quote

Thanks you very much...
Back to top
View user's profile Send private message
prino

Senior Member


Joined: 07 Feb 2009
Posts: 1306
Location: Vilnius, Lithuania

PostPosted: Mon Mar 28, 2011 4:21 pm
Reply with quote

Nic Clouston wrote:
In packed decimal decimal points are notional - they do not exist except in your head - so compare to 1150 instead of 11.50


Or 11500, or 115...
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Need Help with Packed Decimal Signs DFSORT/ICETOOL 4
No new posts Select a DB2 value in a specific deci... DB2 4
No new posts String has hex character need to conv... COBOL Programming 3
Search our Forums:

Back to Top