Topic: DB2 stored procedure - Procedure Type Description: Does not return a result.
C DB2 up until that time did not work, therefore probably missed something absolutely obvious, - put on the right track .
DB2 v188.8.131.52, Fix_Pack 2. The client for development - Squirrel.
Created certain -
CREATE OR REPLACE PROCEDURE FSTEST01.TEST (IN par INTEGER) DYNAMIC RESULT SETS 1 LANGUAGE SQL BEGIN DECLARE c1 CURSOR WITH RETURN FOR SELECT LETTER, NUMBER FROM (VALUES (' A ', 1), (' B ', 2), (' A C ', 2)) AS TEMP (LETTER, NUMBER); OPEN c1; END
Checked up, - returns .
The task - to make for this a wrapper in Denodo (it is such for integration).
At attempt to make it it is clarified that Denodo does not understand this as returning resultset.
Thus for others - from another DB2 servers, - all is normal.
Started to research in what a difference - paid attention that for new in properties it is displayed
Procedure Type: 1.
Procedure Type Description: Does not return a result.
Question, - what not so made? What it is necessary to register in meta data that for an external world it would be displayed as that, what "return a result"?