Teradata Database Message 5760 - 5760 - Analytics Database - Teradata Vantage

Message

The SELECT subquery from the table reference must fully specify either a UPI value or else a USI value.

Explanation

The SELECT subquery from the table reference must either specify a Unique Primary Index or Unique Secondary Index. OR The SELECT subqury in the Merge-Into statement contains a SELECT AND CONSUME statement.

Generated By

Opt module.

For Whom

End User.

Notes

None

Remedy

Re-submit the Merge-Into statement with a Select subquery in the table reference that contains either a UPI value or USI value. If SELECT AND CONSUME statemnt is used in the Select subquery, we will need to correct the query.