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: 1868
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: 1048
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 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 Joinkeys with decimal scdinesh DFSORT/ICETOOL 3 Fri Feb 10, 2017 4:46 am Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm How to pass the previous month date i... Suganya87 DFSORT/ICETOOL 5 Mon Oct 31, 2016 4:13 pm

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