All Forums Tools
shubh 16 posts Joined 09/07
15 Oct 2007
IGNORE DUPLICATE INSERT ROWS

Hi all,The command IGNORE DUPLICATE INSERT ROWS is used in miltiload to remove the duplicates. Can this command be used in Fastload? or is there a similar command in fastload which i can use?

Regards, Shubhangi
Fred 1096 posts Joined 08/04
15 Oct 2007

FastLoad ALWAYS quietly eliminates duplicate rows (even when the target table is defined as MULTISET). So there is no command to explicitly request this behavior.

You must sign in to leave a comment.