Archives of the TeradataForum

Message Posted: Wed, 19 Mar 2003 @ 14:02:58 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

My procedure also has an input parm. I tried what you suggested and got a syntax error.

Here is the procedure:

replace procedure PRCOREREFRESH.spGenIDProc( IN incrnumb float, OUT
GenIDOut float )
  BEGIN
    DECLARE GID float;
    BEGIN TRANSACTION;
        LOCK TABLE PRCOREREFRESH.T_GenID FOR EXCLUSIVE
        SELECT GenIDInc INTO :GID FROM PRCOREREFRESH.T_GenID;
        UPDATE PRCOREREFRESH.T_GenID SET GenIDInc = GenIDInc + :incrnumb
;
        SET GenIDOut = GID;
    END TRANSACTION;
END;

	<Prev	Next>		<<First	<Prev	Next>	Last>>