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!
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.