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
Back to discussions
Expand all | Collapse all

How to use LIKE SQL Operator in Adapter Service

  • 1.  How to use LIKE SQL Operator in Adapter Service

    Posted 07/16/18 04:08 PM

    Hi Experts,

    Could you please help me how to write SQL query with LIKE Operator, my SQL dynamic query is

    select line,groupnumber,groupdetails, roundnumber from XXX_EAM_DETAILS where “NameOfOperator” LIKE ‘?%’

    When I try with above query, I could not get result, it is throwing some error , means

    (72000/1006) ORA-01006: bind variable does not exist
    "
    ORA-01006: bind variable does not exist

    Please help me, how to use LIKE operator in AdapterService.

    Thanks,
    Varun


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


  • 2.  RE: How to use LIKE SQL Operator in Adapter Service

    Posted 07/17/18 08:25 AM

    Hi Varun,

    the question mark represents the input variable of the Adapter service.

    See JDBC Adapter Users Guide for further informations.

    Can you provide a sample with a complete Query (without variable) and the expected results?

    Regards,
    Holger


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


Related Content