Re: Problem with SET_ROUTINE_OPTS() How about this?
------------------------------ Commands Entered
------------------------------
--#SET TERMINATOR !
CALL SET_ROUTINE_OPTS('ISOLATION RR')!
CREATE PROCEDURE TEST (OUT outVALUE INT)
LANGUAGE SQL
BEGIN
SET outVALUE = 1;
END!
------------------------------------------------------------------------------
CALL SET_ROUTINE_OPTS('ISOLATION RR')
Return Status = 0
CREATE PROCEDURE TEST (OUT outVALUE INT)
LANGUAGE SQL
BEGIN
SET outVALUE = 1;
END
DB20000I The SQL command completed successfully. |