Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref

Author Message
ozgurseyrek

New User

Joined: 22 Feb 2008
Posts: 70
Location: Turkey

 Posted: Fri Mar 25, 2011 9:23 pm    Post subject: Using Decimal Points at the Include Cond. 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..

Nic Clouston

Global Moderator

Joined: 10 May 2007
Posts: 1982
Location: UK

 Posted: Fri Mar 25, 2011 10:04 pm    Post subject: In packed decimal decimal points are notional - they do not exist except in your head - so compare to 1150 instead of 11.50
Frank Yaeger

DFSORT Moderator

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

 Posted: Fri Mar 25, 2011 11:41 pm    Post subject: 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.
ozgurseyrek

New User

Joined: 22 Feb 2008
Posts: 70
Location: Turkey

 Posted: Mon Mar 28, 2011 11:41 am    Post subject: Thanks you very much...
prino

Senior Member

Joined: 07 Feb 2009
Posts: 1095
Location: Oostende, Belgium

Posted: Mon Mar 28, 2011 4:21 pm    Post subject:

 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...
 All times are GMT + 6 Hours
 Page 1 of 1

Search our Forum:

 Topic Author Forum Replies Posted Similar Topics How to group and sum the decimal value sakrat DFSORT/ICETOOL 2 Tue Mar 06, 2018 9:13 pm query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm Extend the decimal values in DIVISION Balaryan DFSORT/ICETOOL 3 Thu Oct 05, 2017 4:05 pm More than 1 Include criteria for sing... Roy Ware SYNCSORT 6 Wed Sep 13, 2017 11:45 pm Include/omit with "ALL" pa... mgl DFSORT/ICETOOL 6 Wed Jun 14, 2017 2:31 pm

 © 2003-2017 IBM MAINFRAME Software Support Division
 Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us