<< Click to Display Table of Contents >> Current:  Create Data Set > SQL Data Set > Data Set for Stored Procedure  POSTGRESQL Database Returning Data Set(Cursor)

The way of accessing the Postgresql database is the same as the way of accessing the DB2 database. If the SQL statements for the stored procedure created in the database are as follows:

CREATE OR REPLACE FUNCTION "public"."cursor_test"()

 RETURNS "pg_catalog"."refcursor" AS $BODY$

declare

 bound_param_cursor cursor for select "market","product","ID","sales" from coffee_chain order  by  "ID"  limit  10  ;

begin

 open bound_param_cursor;

 return bound_param_cursor;

end;

$BODY$

 LANGUAGE plpgsql VOLATILE

 COST 100

 

Then the call statement written at the Yonghong product's sql statement is {call "public"."cursor_test"(?{cursor})}, as shown below.

It is also necessary to configure the parameters, including their type, direction and default values, as follows.

The refreshed data is shown below.