Please Help on view update

Database
Enthusiast

Please Help on view update

I tried to insert a record in to a view and I got this messsage:
3823: view xxx may not be used for Help Index/constraint/statistics, update,delete or insert.
Would you please give me some hint about it? many thanks!
4 REPLIES
Senior Apprentice

Re: Please Help on view update

Hi yujing,

Messages manual
Chapter 6: Teradata Database Messages
3000-Series Messages

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.

Dieter
Enthusiast

Re: Please Help on view update

Thank you dieter. Would you please tell me Where did you get this messages manual. Is it online?
Senior Apprentice

Re: Please Help on view update

Hi yujing,
all manuals are available at www.info.ncr.com

Instead of seperate manuals, it's better to download the documentation CD, then you can search within all manuals.

Dieter

Re: Please Help on view update

Hi 

 this kind of issues can be solved by putting records in the base table then then trying updating over the table , then query shud wrk