Can anyone tell me what sqlcode -192 is? I'm using ASA 8.02, Sybase
Central 4.1.1.1370.

Thanks!
Eric

Thanks, Willy.

I'm actually getting it in iSQL when I run a function. The line in
question looks like:

execute immediate 'update vwPopulateOCC set '||varExecSQL||' where
current of curTempTable';

vwPopulateOcc is a view to a temp table. The view and the temp table
all have granted all permissions to the dba user, which I log in as.

Any ideas?

Thanks again for your help!
Eric

willy_and_the_ci <member4473@dbforums.com> wrote in message news:<3236879.1060818962@dbforums.com>...
> From Error messages Guide:
>
> Item Value
> SQLCODE -192
>
>
> "Update operation attempted on non-updatable query
>
> Probable cause
> You attempted an insert, update, or delete operation on a query that is
> implicitly read-only. Queries that contain DISTINCT, GROUP BY, HAVING,
> or UNION, or that contain aggregate functions, or that involve a join,
> are implicitly read only. If the query references a view then the view
> may be non-updatable."
>
> If you are getting it in Sybase Central Central, most likely caused due
> to some internal problem that you can log with Sybase Support.
>
> Cheers,
>
> Willy