Server error messages 4500 - 4599 – Sybase 11.9.x-12.5 User Manual

Page 269

Advertising
background image

CHAPTER 6 Adaptive Server Error Messages

943

Server Error Messages 4500 - 4599

4423

16

View `%.*s' cannot be updated since view is the inner table of an outer join.

Explanation:

Command failed due to invalid or illegal request. Check syntax,

semantics, and permissions. Take any corrective action indicated by message.

4424

16

View `%.*s' contains a table being updated, and this table is referenced elsewhere in the
query which is not allowed if create view WITH CHECK OPTION is used.

Explanation:

Command failed due to invalid or illegal request. Check syntax,

semantics, and permissions. Take any corrective action indicated by message.

4425

16

View `%.*s' cannot have WITH CHECK OPTION applied since it contains subqueries.

Explanation:

Command failed due to invalid or illegal request. Check syntax,

semantics, and permissions. Take any corrective action indicated by message.

4426

16

This query cannot be processed because it contains TEXT, IMAGE or off-row Java
columns and references a view defined with a subquery, an outer join, or a distinct clause.

Explanation:

You cannot use view materialization for a query having TEXT/IMAGE

columns. View materialization needs to create a work table to store the result, and what
is copied to the work table is only the TEXT pointer. Forbiding queries that require view
materilization and select text columns from that view avoids stackstaces.

4427

16

View ’%.*s’ cannot be updated since the view definition contains a UNION operator.

Explanation:

You cannot update view definitions that contain UNION.

Number

Severity

Text and Explanation

Number

Severity

Text and Explanation

4501

16

View `%.*s' has more columns defined than column names given.

Explanation:

Command failed due to invalid or illegal request. Check syntax,

semantics, and permissions. Take any corrective action indicated by message.

4502

16

View `%.*s' has more column names specified than columns defined.

Explanation:

Command failed due to invalid or illegal request. Check syntax,

semantics, and permissions. Take any corrective action indicated by message.

4503

20

The create view tree has a resdom with no right hand side. View `%.*s', resdom `%.*s'.

Explanation:

Adaptive Server encountered an internal error affecting the current

process. Reconnect to Adaptive Server. Report the error to your System Administrator so
dbcc diagnostics can be run.

Advertising