I am brand new to Teradata and I am trying to import a text file with 4 columns into a volatile table using Teradata SQL Assistant. I am going to file then I am selecting import data and trying to execute the below code. I am executing the create table in one query window then I am executing the insert into in a seperate query window. However it's not working.
CREATE VOLATILE TABLE TempTable(MemberId varchar(25),PhysicianNPI integer, Member_id varchar(25), MemberSrc varchar(2));
INSERT INTO TempTable values(?,?,?,?);
I figured it out I was missing the code below at the end of the create volatile table
on commit preserve rows;
Thanks for following up with me Dieter, I appreciate it.
Raj, For help with SQL Assistant, please post to the Tools Forum. If you are using Studio Express, you can right click on a table and choose, Data>Export and Data>Import to export and import data from a table.