1

Topic: DB2 stored procedure - Procedure Type Description: Does not return a result.

All greetings.
C DB2 up until that time did not work, therefore probably missed something absolutely obvious, - put on the right track .
DB2 v11.1.2.2, 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"?
Thanks.

2

Re: DB2 stored procedure - Procedure Type Description: Does not return a result.

wrote:

McCar;
If to replace RETURN on RETURN TO CLIENT it becomes better?

No.
Can from the driver or version DB2 depends?
The driver (for Squirrel and for Denodo identical) - JDBC, driver Class Name: com.ibm.db2.jcc. DB2Driver.
For another environment where all works, driver - com.ibm.as400.access. AS400JDBCDriver.

3

Re: DB2 stored procedure - Procedure Type Description: Does not return a result.

McCar;
C the same procedure on the server with AS400.
At it it is displayed proceduretype:0; procedureTypeDesctiption: May return a result
That all the same the reason in the driver?