Re: The target for a numeric operation is too small to hold the resul t (C G D F)

 In response to Scott Klement with Rob Berendt's additional comment:

 What Rob said I guess?!  I just don't want to have to go to each db that has 
the field that is smaller in size and have to make it bigger.  Did Z-ADD just 
drop all digits to the left of decimal that wouldn't fit?  I guess I'm looking 
for some easier solution to EVAL.  What would most folks do in this situation, 
without having to change database field sizes?


 Rob Berendt wrote:

 Isn't there an hspec option to respect decimal positions that will beat
 that into submission?

 Rob Berendt
 --
 Group Dekko Services, LLC
 Dept 01.073
 PO Box 2000
 Dock 108
 6928N 400E
 Kendallville, IN 46755
 http://www.dekko.com

   Scott Klement wrote:

 Hi Ted,

  

 I have a similar situation where I have two different database fields.
 The result field is 10, 4 and the other is 11,4. Obviously too small,
 but what if you don't want to go around changing all of the database
 fields? Is there a routine anyone knows of to handle getting the result
 you want without having to change the db?
    

 Are you asking for a routine that will allow you to fit an 11-digit number
 into a 10-digit field?  If so, there's no routine for that...

 If not, what would you like to happen when you try to assign an 11-digit
 number to a 10-digit field?  I'm not clear on what the desired result is.
 --
 This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
 To post a message email: RPG400-L@xxxxxxxxxxxx
 To subscribe, unsubscribe, or change list options,
 visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
 or email: RPG400-L-request@xxxxxxxxxxxx
 Before posting, please take a moment to review the archives
 at http://archive.midrange.com/rpg400-l.


  

   [IMG] has notified the sender that this message has been received.