Syntax needed

UDA
Highlighted
Teradata Employee

Syntax needed

What is the proper syntax for using the "Insert ...not exists" code?

Is there a pdf or some other documentation floating around that I can get that would be a good reference for these types of questions?

I have a large table that I defined in the ddl as MultiSet. The table loads much faster now, but I still need to handle possible duplicate records (not just key because it is a NUPI, but entire record dups). What would be the best way to do this duplicate checking?

Thanks!

Paul
1 REPLY
Enthusiast

Re: Syntax needed