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.

 View Only

Adapter service does not return result set

  • 1.  Adapter service does not return result set

    Posted Tue August 22, 2017 07:20 AM

    Good day, i am currently developing an adapter service in Software AG Designer (custom SQL template) which does not return even one result set in Result tab.

    Out of curiosity, i copy the SQL statement used in the adapter to SQL editor. Here i manage to obtain several result sets with the same SQL statement. Does anyone encounter such issue before? May i know how do you overcome this?

    SQL statement used:
    select * from t_lk_service_down where DownTimeTo > ‘2017-08-22’ order by DownTimeTo asc

    Table Structure
    CREATE
    TABLE t_lk_service_down
    (
    Service VARCHAR(20),
    DownTimeFrom DATETIME,
    DownTimeTo DATETIME,
    CreateUser VARCHAR(20) NULL,
    CreateDate DATETIME NULL,
    LastUpdateUser VARCHAR(20) NULL,
    LastUpdateDate DATETIME NULL,
    remarks VARCHAR(50) NULL,
    CONSTRAINT pk_t_lk_service_down PRIMARY KEY (Service, DownTimeTo)
    )

    Warmest regards,
    Ronnie She


    #webMethods
    #Integration-Server-and-ESB