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

  • 1.  NULL values in incoming IDOC are replaced by a space

    Posted Tue April 16, 2002 04:46 AM

    I am using the ALE_Server adapter for webMethods enterprise 4.1.1 on windows NT.
    In the IDOC that is sent from SAP there are some fields that have NULL values, however when I debug the adapter and it receives the IDOC these NULL values are replaced by a space. This is creating problems when inserting records in a database since for these fields a space is not an allowed value. I also set the flag allow unset values on the integration component but this doesn’t make a difference.

    How can I fix this? Thanks!


    #Integration-Server-and-ESB
    #webMethods
    #webMethods-General


  • 2.  RE: NULL values in incoming IDOC are replaced by a space

    Posted Wed April 17, 2002 09:37 AM

    How about writing a common operation that is a Java script which trimes white space using java.lang.String.trim() ???


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 3.  RE: NULL values in incoming IDOC are replaced by a space

    Posted Fri April 19, 2002 05:35 AM

    is there a way to clear the spaces from the complete idoc at once? or would this have to be done field by field?
    is this “normal behaviour” of the adapter that null values are replaced by spaces?


    #webMethods
    #webMethods-General
    #Integration-Server-and-ESB


  • 4.  RE: NULL values in incoming IDOC are replaced by a space

    Posted Fri May 03, 2002 12:19 PM

    If you are using insert statement to insert data into say Orcale , you can use decode and NVL functions so that the insert does not fail.


    #webMethods-General
    #Integration-Server-and-ESB
    #webMethods


Related Content