Archives of the TeradataForum
Message Posted: Thu, 08 Oct 2009 @ 09:49:53 GMT
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;
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|