Troubleshooting UPDATE or DELETE operation errors on nicknames

By default, rows are not uniquely identified on Teradata data source tables. You might receive an SQL error message when you try to update or delete a nickname that is associated with a Teradata table or view.

Symptom

The SQL30090N, RC="21" error is returned when you try to update or delete a nickname that is associated with a Teradata table or view.

Cause

This problem is caused because rows are not uniquely defined on the Teradata source table.

Resolving the problem

To resolve the problem:
  1. Drop and recreate the nickname.
  2. Create at least one unique index on the Teradata table that is being updated or deleted, and try the operation again.