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.
Hi I'm also trying to find a way to insert 39K rows of data into a volatile table (just 1 column) and it's not letting me do it.
Insert failed.  Total size of all parcels is greater that max message size.
Please help. I have no access to create a table that's why i'm trying to do this. I'm also new to Teradata.
Appreciate your help.