Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
How to accomodate 11 DP's

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries
View previous topic :: :: View next topic  
Author Message
bsk_sukku

New User


Joined: 07 Mar 2007
Posts: 7
Location: hyderabad

PostPosted: Mon Nov 17, 2008 12:57 pm    Post subject: How to accomodate 11 DP's
Reply with quote

we have requirement to accomodate 11 DP's but natural supports only 7 dp's. Please help how to full fill this requirement.

storing in database can be done in any form but at the time of display it should accomodate for 11 DP's.


Regards
Sukumar
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Mon Nov 17, 2008 8:49 pm    Post subject:
Reply with quote

Hello,

Please describe what is a "DP". Even if someone does not work with Natural, they may be able to make a suggestion if they understand what the requirement is and "7" limitation.

I mention this as it has been 8 hours and no replies icon_smile.gif
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Nov 18, 2008 2:04 am    Post subject:
Reply with quote

I'm working with Natural for 11 years, and I don't know what do you mean by "dp"... icon_confused.gif

O.
Back to top
View user's profile Send private message
bsk_sukku

New User


Joined: 07 Mar 2007
Posts: 7
Location: hyderabad

PostPosted: Tue Nov 25, 2008 2:21 pm    Post subject: Reply to: How to accomodate 11 DP's
Reply with quote

Requirement is : right now system is accomodating only 7 decimal points now we are required to expand to 11 decimal points.

example:

Taxrate (N2.7) can store upto 7 decimal points now we are required to store upto 11 decimals for this variable.
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Tue Nov 25, 2008 2:54 pm    Post subject:
Reply with quote

Using Numeric or Packed variables - it can't be done.

However, you may use a Floating Point (F8) variable, which allows a precision of 16 decimal points, and then move the result to an alphanumeric variable, for display purposes only.

O.
Back to top
View user's profile Send private message
bsk_sukku

New User


Joined: 07 Mar 2007
Posts: 7
Location: hyderabad

PostPosted: Wed Nov 26, 2008 2:11 pm    Post subject: Reply to: How to accomodate 11 DP's
Reply with quote

Apart from declaring as F8 are there any other solutions?
Back to top
View user's profile Send private message
ofer71

Global Moderator


Joined: 27 Dec 2005
Posts: 2360
Location: Israel

PostPosted: Wed Nov 26, 2008 3:29 pm    Post subject:
Reply with quote

No other options that I'm aware of...

O.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10310
Location: italy

PostPosted: Wed Nov 26, 2008 3:59 pm    Post subject: Reply to: How to accomodate 11 DP's
Reply with quote

Quote:
Apart from declaring as F8 are there any other solutions?

if there were they would have been proposed to You
are there any reasons that You are not satisfied with the proposed solution?
it' s a lack of respect to object to a solution posted by an expert!

anyway just out of curiosity I checked a few national sites concerned with tax calculations

the general approach for amounts is to use 4 decimals digits for computations and display 2 decimal digits

when calculating average pergentages is to use 6 decimals digits for computations and 4 decimal digits for the final result

sometimes when the currency has also cents the digits for amounts become 6 and 4 ( rarely )

in order to yield also hundredths of cents
but normally it' s a useless precision
Back to top
View user's profile Send private message
bsk_sukku

New User


Joined: 07 Mar 2007
Posts: 7
Location: hyderabad

PostPosted: Wed Nov 26, 2008 4:35 pm    Post subject: Reply to: How to accomodate 11 DP's
Reply with quote

I doesn't mean to hurt any one by asking other solutions. My sincere apologies.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Java & MQSeries All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Number of Conditions that SYNCSORT ca... sprikitik JCL & VSAM 1 Tue Sep 23, 2008 11:52 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us