"Select Into" can't be used in teradata?

Database

"Select Into" can't be used in teradata?

I found that "select into" function can't be used in teradata.
e.g.
SELECT * INTO Temp_Persons
SELECT name, gender, age
FROM Persons
WHERE age > 18;

Any method in teradata can be used instead?
3 REPLIES

Re: "Select Into" can't be used in teradata?

If u r intending to select the name gender and age fields of Persons and trying to insert them into temp_persons, U can use Insert-into clause.

Insert into Temp_Persons(name,gender,age)
select name,gender,age from persons where age>18;

Re: "Select Into" can't be used in teradata?

You can also create the result table "on the fly" with:

create table Temp_Persons as
(select name,gender,age from persons where age>18) with data
primary index(name);

Teradata Employee

Re: "Select Into" can't be used in teradata?

SELECT INTO is supported in Teradata stored procedures. V2R5 and above.