04 Nov 2009
Which operator are you using?
Update?
Stream?
04 Nov 2009
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.
You must sign in to leave a comment.
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));
',