Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2014 @ 22:47:43 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If the WHERE clause for the UPDATE matches no rows, then INSERT will be attempted. The WHERE clause must specify equality constraints on values for all PI (and PPI) columns, and values in those columns cannot be changed. The same values must be specified in the corresponding columns for INSERT.

See the relevant reference manuals for other details on TPT UPDATE operator (or MultiLoad) and STREAM operator (or TPump).

If using DML and not a Teradata utility, review both single-row UPDATE (Upsert form) and MERGE statements.

	<Prev	Next>		<<First	<Prev	Next>	Last>>