Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Volatile table in procedure
 
From:   Rahul Shashidhar Phadnis

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016