классика :
DB2 UDB EEE 7.2 FP 10A SERVICE LEVEL WR21331
ХП 1:

CREATE PROCEDURE DATASCHEMA.MYSP1 ()
RESULT SETS 1
LANGUAGE SQL
BEGIN
...
DECLARE my_cursor CURSOR WITH RETURN FOR
мой запросишко ;
...
OPEN my_cursor ;
END

ХП 2:

CREATE PROCEDURE DATASCHEMA.MYSP2 ()
LANGUAGE SQL
BEGIN
...
DECLARE var_not_found SMALLINT DEFAULT 0 ;

DECLARE mynested RESULT_SET_LOCATOR VARYING ;

DECLARE CONTINUE HANDLER FOR NOT FOUND -- SQLSTATE '02000'
SET var_not_found = 1 ;
...
CALL SPGETBDAYMAP () ;
ASSOCIATE RESULT SET LOCATOR (mynested) WITH PROCEDURE
SPGETBDAYMAP;

ALLOCATE nestedsp_cursor CURSOR FOR RESULT SET mynested ;

fetch_loop :
-- вычитываем курсор nestedsp_cursor
END LOOP fetch_loop ;

CLOSE nestedsp_cursor ;

END ;

!!!
вызов CALL SPGETBDAYMAP (par_business_day, call_code, call_state) ;
влечет WARNING : SQLSTATE=0100E/SQLCODE=464

КОТОРЫЙ ПРИХОДИТЬСЯ ИГНОРИРОВАТЬ И ВСЕ ЛАДУШКИ ОТРАБАТЫВАЕТ, НО ОТКЕЛЯ ОН ??????????? ЭТОТ WARNING
ЧИТАЕМ ПАПИРУС :
SQL0464W
Procedure “<procedure-name>” returned “<generated-nbrresults>”
query result sets, which exceeds the defined limit “<max-nbr-results>”.

Explanation: The stored procedure named by “<procedure-name>” completed normally. However, the stored procedure exceeded the defined limit on the number of query result sets the procedure can return. generated-nbr-results identifies the number of query result sets returned by the stored procedure. max-nbr-results
identifies the defined limit on the number of query result sets for the stored procedure. Only the first “<max-nbr-results>” query result sets are returned to the SQL program that issued the SQL CALL statement.

The possible causes are as follows:
The stored procedure is unable to return “<generated-nbr-results>” result sets due to the DRDA limitations imposed by the client. The DRDA client establishes this limit with the MAXRSLCNT DDM code point. User Response: The SQL statement is
successful. The SQLWARN9 field is set to ’Z’.
sqlcode: +464
sqlstate: 0100E

МОЖЕТ КТО СТАЛКИВАЛСЯ С ДАННОЙ СИТУАЦИЕЙ?
СПАСИБО!!

Прошу прощения, в примере вместо имени ХП1 MYSP1 следует читать SPGETBDAYMAP