View previous topic :: View next topic
|
Author |
Message |
ozgurseyrek
New User
Joined: 22 Feb 2008 Posts: 70 Location: Turkey
|
|
|
|
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 |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
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 |
|
|
Frank Yaeger
DFSORT Developer
Joined: 15 Feb 2005 Posts: 7129 Location: San Jose, CA
|
|
|
|
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 |
|
|
ozgurseyrek
New User
Joined: 22 Feb 2008 Posts: 70 Location: Turkey
|
|
|
|
Thanks you very much... |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
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 |
|
|
|