Creating Volatile Table

Database

Creating Volatile Table

I would like to create a volatile table "UTS" in a database named "ABC". The syntax used was

CREATE VOLATILE TABLE ABC.UTS
(
Sale_Date DATE
,Sum_Sale DECIMAL(9,2)
,Avg_Sale DECIMAL(7,2)
,Max_Sale DECIMAL(7,2)
,Min_Sale DECIMAL(7,2)
)
ON COMMIT PRESERVE ROWS ;

But when I execute this syntax, i get the following error:
"Database name if specified must be the login user name for a volatile table".

Can anyone explain how this could be solved ?

thanks,
newtera
1 REPLY
Teradata Employee

Re: Creating Volatile Table

Hello,

Volatile tables are created in a user's session (user space) not in database. So, removing the "ABC." from the DDL will solve the issue.

Regards,

Adeel