Archives of the TeradataForum

Message Posted: Thu, 08 Oct 2009 @ 09:49:53 GMT

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

TD manual suggests

Version - v2r6

CREATE VOLATILE TABLE

If you include a CREATE VOLATILE TABLE statement in a stored procedure, the volatile table is created in your login database. If an object with the same name already exists in that database, the result is a runtime exception.

DML statements within a stored procedure referencing the volatile table must either have the user's login database as the qualifier, or not have any qualifying database name.

Not able to insert in the volatile table that I create from within a procedure.

Procedure compilation is a success when I comment out the insert statement. But when there is an insert statement it says cannot access the table.

Any idea ?

     CREATE PROCEDURE abc
     (
     )
     BEGIN

        CREATE VOLATILE TABLE abc_vt
        (
          Id1 INTEGER,
          Id2 INTEGER,
        )
        ON COMMIT PRESERVE ROWS;

        /*INSERT INTO abc_vt
        VALUES(1,1 );*/

     END;

Thanks

Rahul

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