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.


#TechXchangePresenter
 View Only
Back to discussions
Expand all | Collapse all

Convert decimal value to Integer

  • 1.  Convert decimal value to Integer

    Posted Wed September 10, 2008 02:25 PM

    Hi Guys,
    I have a DB2 Column as integer but i get data as String (OriginallyDecimal value) , i thought there wil be implicit conversion but its giving an error saying cannot insert 1.000 value.so what should i do.

    Thanks
    Chinna


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


  • 2.  RE: Convert decimal value to Integer

    Posted Tue September 16, 2008 01:09 AM

    You can do several things. One option would be to use WmPublic/pub.string:numericFormat to transform the value before inserting.

    • Percio

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


Related Content