CODEWITHSUNDEEP
teradatalarge-databteq
Neeraj Somani
Neeraj Somani

Reputation: 1

how can i download 200+ millions records from teradata using bteq?

Using below statement I am able to download 1 million records. But not getting how can i download 200+ millions records from the teradata table into pipe separated text file.

Below is the code that I am currently using.

.export reset

.set width 1048575

.SET RECORDMODE OFF

.SET FORMAT OFF

.SET SEPARATOR "|"

.export report file=test_file.txt

select * from test_schema.test_table

I found this link and understood that teradata could have some limitation on this. But I am sure there must be some other ways to download this large data set. Can you please share some examples on how can i do that?

Thanks.

Upvotes: 0

Views: 250

Answers (0)

Related Questions