IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.

 View Only

inserting large numeric value

  • 1.  inserting large numeric value

    Posted Fri October 05, 2007 05:13 AM

    Hi,

    We need to insert large numeric value into database table.
    The inout value is numeric value but in databse it is defined as float datatype for soem reason with size 8. If we insert integervalu less than 8 digits it is working fine. but anything above this value it is storing in database with exponential value.
    Example if input is 3300000000000000 then in database it is storing it as 3.29999986982912E14 .
    One way is to increse the size in DB.

    Is there nay other way to work around this problem.
    Can anyone help me in finding what exactly the problem is and please let me knwo the solution for this…

    Thanks and regds,
    Kavitha


    #webMethods
    #Adapters-and-E-Standards
    #Integration-Server-and-ESB