|
|
|
Forum Newbie
Group: Forum Members
Last Login: Yesterday @ 12:37:58 AM
Posts: 1,
Visits: 6
|
|
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));
',
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
Which operator are you using?
Update?
Stream?
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
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.
|
|
|
|