How to bulk insert into teradata tables via a single insert statement

Database

How to bulk insert into teradata tables via a single insert statement

Hi

I need to insert data into a table by a single insert statement.

means i have an insert script insert into dbtest.test values ('abc')

Now in need to run this query million times for bulk testing, how do i do it.

I do not want to use a procedure to do this stuff.

I am using TD13

1 REPLY
Enthusiast

Re: How to bulk insert into teradata tables via a single insert statement

If you want to execute a single insert at a time then use BTEQ and looping to achive this, If you want to just load the data from a file to table means use any of the utilities Fload, Mload...