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.



#Automation


#Applicationintegration
#webMethods
#Integration
 View Only
  • 1.  Convert decimal value to Integer

    Posted 09/10/08 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 09/16/08 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