15.00 - 3823 VIEW '%VSTR' may not be used for Help Index/Constraint/Statistics, Update, Delete or Insert. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

3823 VIEW '%VSTR' may not be used for Help Index/Constraint/Statistics, Update, Delete or Insert.

Explanation:

The view specified can only be used for retrievals. The user cannot use this view for INSERT, UPDATE, or DELETE statements, nor can the user ask for index/statictics/constraint information on a view that is not on a single table.

Generated By:

RES modules.

For Whom:

End User.

Notes:

A view that contains any expressions, joins, or aggregates cannot be used for manipulating the data in the underlying table. The HELP INDEX, HELP STATISTICS, HELP CONSTRAINT statements will also not work on such views.

Remedy:

Redefine the view or do not use a view.