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.  Parameters in WmDBexecSQL service

    Posted 08/20/02 04:44 PM

    Has anyone experienced this. Embedded question mark with quoted character literal confuses execSQL in thinking a parameter has not been supplied.


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Parameters in WmDBexecSQL service

    Posted 08/20/02 05:28 PM

    Hi,

    i had similar problem… i had to tweak it…
    before EexcSql step, add a map step with one string “sQue” and hard code its value with ? and in ur query u can substitute varaible as below:
    (%sQue%. %sQue%, …)

    HTH,
    AS


    #webMethods
    #Integration-Server-and-ESB
    #Flow-and-Java-services