I would like to have the SPinner() to return the cursor (cc) to
SPouter, which returns it to caller (client).

My simple procedures is as follows:

CREATE PROCEDURE SPinner ()
 LANGUAGE SQL
 result sets 1
BEGIN
 declare cc cursor with return TO CALLER for
 select mytable.col1, mytable.col2 from mytable;
 open cc;
END

CREATE PROCEDURE SPouter ()
 LANGUAGE SQL
 result sets 1
BEGIN
 call SPinner();
END

... but this doesn't get the cc-cursor into SPouter(). I've then been
looking at "allocate cursor" in conjunction with "associate" like
this:

CREATE PROCEDURE SPouter ()
   LANGUAGE SQL
   result sets 1
BEGIN
   DECLARE loc RESULT_SET_LOCATOR VARYING;
   call SPinner();
   ASSOCIATE RESULT SET LOCATOR(loc) WITH PROCEDURE SPinner;
   ALLOCATE C1 CURSOR FOR RESULT SET loc;
   open C1;
END

... but it returns SQLSTATE: 51030 upon runtime.