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.
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.
This problem is caused because rows are not uniquely defined on the Teradata source table.
Resolving the problem
To resolve the problem:
- Drop and recreate the nickname.
- Create at least one unique index on the Teradata table that is being updated or deleted, and try the operation again.