Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create Volatile Table in Teradata is showing 0 rows being processed

Status
Not open for further replies.

jholl

Technical User
Feb 21, 2015
1
0
0
US
Hello All

I am taking someone else code and running the below. This should process a row of data. I'm not getting any. Any ideas?


create volatile table Volatile_Date_Range as
(
Select
'2017-01-01' as From_Date,
'2017-02-01' as To_Date
)
WITH DATA
PRIMARY INDEX (From_Date)
ON COMMIT PRESERVE ROWS;
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top