In TPT UPSERT on a table with an Identity Column primary index is illegal

Tools & Utilities

In TPT UPSERT on a table with an Identity Column primary index is illegal

Hi

While using TPT M getting below error message in upsert

UPSERT on a table with an Identity Column primary index is illegal

My Query is like below :
APPLY
( 'UPDATE EIWStageTB.CoorsPointInventoryChange
SET SuspenseFlag = :SuspenseFlag
WHERE DistributorCd = :DistributorCd (DECIMAL(18,0))
AND MaterialNo = :MaterialNo (DECIMAL(18,0))
AND SeqNbr = :SeqNbr (INTEGER)
AND WeekNo = :WeekNo (DECIMAL(18,0));
',
2 REPLIES
Teradata Employee

Re: In TPT UPSERT on a table with an Identity Column primary index is illegal

Which operator are you using?
Update?
Stream?
-- SteveF
Teradata Employee

Re: In TPT UPSERT on a table with an Identity Column primary index is illegal

Looking in the Teradata Messages manual, you will see this:

5790 UPSERT on a table with an Identity Column primary index is illegal.

Explanation: If the UPSERT table has an identity column as its primary index, then the UPSERT would be disallowed as it may no longer be a single-AMP operation.

Generated By: OPT module.

For Whom: End User.

Remedy: Do not re-submit the request on the same table.

-- SteveF