Syntax errors are generated by SQL statements that contain
unterminated comments, implicit datatype conversions not supported
by Adaptive Server or other incorrect syntax.
Access rule violations are generated when a user tries to
access an object that does not exist or one for which he or she
does not have the correct permissions.
Table 6-6: Syntax
errors and access rule violations
Message
|
Value
|
Description
|
command permission
denied on object object_name, database database_name,
owner owner_name.
|
42000
|
Occurs when a user tries to access an
object for which he or she does not have the proper permissions.
|
Implicit
conversion from datatype ‘datatype’ to ‘datatype’ is
not allowed. Use the CONVERT function to run this query.
|
42000
|
Occurs when the user attempts to convert
one datatype to another but Adaptive Server cannot do the conversion implicitly.
|
Incorrect
syntax near object_name.
|
42000
|
Occurs when incorrect SQL syntax is found
near the object specified.
|
Insert
error: column name or number of supplied values does not match table
definition.
|
42000
|
Occurs during inserts when an invalid
column name is used or when an incorrect number of values is inserted.
|
Missing
end comment mark ‘*/’.
|
42000
|
Occurs when a comment that begins with
the /* opening delimiter does not also have the */ closing
delimiter.
|
object_name not
found. Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of
output).
|
42000
|
Occurs when a user tries to reference
an object that he or she does not own. When referencing an object
owned by another user, be sure to qualify the object name with the name
of its owner.
|
The
size (size) given to the object_name exceeds
the maximum. The largest size allowed is size.
|
42000
|
Occurs when:
|