Use of BTQ Insert Using with a PACK factor

Database
N/A

Use of BTQ Insert Using with a PACK factor

I recently changed some existing BTEQ Insert Using queries to use a PACK factor on thte repeat clause. This greqtly reduced the run time for the queries. Several months after changeing the queries I tried to load a file that contained duplicate unique primary keys. When this happened none of the rows in the group that contained the duplicate loaded to the table. What is the best way to handle this situation?
Tags (1)
2 REPLIES
Senior Apprentice

Re: Use of BTQ Insert Using with a PACK factor

Not using PACK ;-)

A PACKed group of inserts is processed exactly as a Multistatement Request, i.e. all or nothing.

Dieter
Teradata Employee

Re: Use of BTQ Insert Using with a PACK factor

did you tried to make it with 2 phases :
use bteq import with pack option to load your data to a table with a NUPI, and
then populate the target by an insert/select.