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