You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by Laura Stewart <sc...@gmail.com> on 2006/09/08 07:39:07 UTC

SQL State 42Y62 " ' is not allowed on '' because it is a view. "

Is the second variable in SQL State 42Y62 really a value... or should
it be <viewName> ???

The current text is:

SQL State 42Y62 " <value>' is not allowed on '<value>' because it is a view. "

-- 
Laura Stewart

Re: SQL State 42Y62 " ' is not allowed on '' because it is a view. "

Posted by Andrew McIntyre <mc...@gmail.com>.

On 9/7/06, Laura Stewart <sc...@gmail.com> wrote:
> Is the second variable in SQL State 42Y62 really a value... or should
> it be <viewName> ???
>
> The current text is:
>
> SQL State 42Y62 " <value>' is not allowed on '<value>' because it is a view. "

The first value is a DDL statement, e.g. ALTER TABLE, DROP TABLE,
CREATE INDEX, etc., the second is the name of a view (a view-Name SQL
identifier). A real example would be:

ERROR 42Y62: 'CREATE INDEX' is not allowed on 'MYSCHEMA.MYVIEW'
because it is a view.

andrew