Hi,
can somebody help me to see if this "DYNAMIC RESULT SETS " is a TD version 12. feature?
I am executing a cut and paste from TD books and am getting the following result:-
CREATE PROCEDURE Sample_p (INOUT c INTEGER)
DYNAMIC RESULT SETS 2
BEGIN
DECLARE cur1 CURSOR WITH RETURN ONLY FOR
SELECT * FROM m1;
DECLARE cur2 CURSOR WITH RETURN ONLY FOR
SELECT * FROM m2 WHERE m2.a > c;
SET c = c +1;
OPEN cur1;
OPEN cur2;
END;
THe results I get are:-
SPL1048:E(L2), Unexpected text 'RESULT' in place of SPL statement.
SPL1008:E(L2), Unexpected text 'RESULT' in place of literal or system variable.
SPL1027:E(L2), Missing/Invalid SQL statement'E(3707):Syntax error, expected something like ';' between the word 'RESULT' and the 'SETS' keyword.'.
Can somebody help? Regards. Ram.