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.  Error in the Dynamic SQL query

    Posted 07/15/10 09:40 AM

    Hi all,

    i am trying to delete some records from the DB by using an adapter service, which has an dynamic SQL statement.

    delete from EVENTS where ${where}

    AND i have the following error,
    [ADA.1.316] Cannot execute the SQL statement “delete from EVENTS where ORDERID=10 AND REASON=mk”. "
    (17003) Invalid column index"
    Invalid column index.

    I am building a where clause, where it will take orderid and reason… and reason is an optional value.

    Does anyone has idea on this ? please help me.:confused:


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


  • 2.  RE: Error in the Dynamic SQL query

    Posted 08/26/10 10:19 PM

    Hello

    Is this working when you do it in any other SQL editor?.

    thanks
    Anil


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


  • 3.  RE: Error in the Dynamic SQL query

    Posted 08/27/10 03:36 PM

    Shouldn’t there be single quotes around mk?


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