Neoview Messages Manual (Volume 1) (R2.4)

SQL 4102
4102 The [FIRST/ANY n] syntax can be used only in an outermost SELECT
statement that is not contained in a UNION or INSERT.
Cause You attempted to use either a FIRST n or an ANY n clause in other than an outermost
SELECT statement.
Effect The operation fails.
Recovery Remove the FIRST n or ANY n clause and resubmit.
SQL 4104
4104 If a character literal was intended, you must use the single quote
delimiter: ‘literal’. The use of double quotes causes SQL/MX to interpret
column name as a delimited identifier column name.
column name is a delimited ANSI identifier, such as MYCOL.
Cause You attempted to select from a table using a character literal, but you used double
quotes as the delimiter instead of single quotes.
For example, if you enter this statement, in which "Lower" is a character literal: >>select
* from T050a where a="Lower";
you will receive this error:
*** ERROR[4001] Column "Lower" is not found. Tables in scope:
CAT.SCH.T050A. Default schema: CAT.SCH.
*** ERROR[4104] If a character literal was intended, you must use the
single quote delimiter instead of the double: 'Lower' instead of
"Lower".
Effect Nothing is selected.
Recovery Replace the double quotes with single quotes.
SQL 4105
4105 Translation name is not recognized.
Cause The HP Neoview database software does not recognize the translation name.
Effect The Neoview database software is unable to compile the statement.
Recovery Use one of the supported translation names.
SQL 4106
4106 The character set for the operand of function name1 must be name2.
Cause You specified an operand for function name1 with the wrong character set name2.
Effect The operation fails.
Recovery Correct the character set of the operand and resubmit.
SQL 4107
4107 Column name has no default value, so DEFAULT cannot be specified.
Cause In the source value list of INSERT, you specified DEFAULT for column name, but
there is no default value for that column.
Effect The operation fails.
Recovery Correct the syntax and resubmit.
142 Binder and Compilation Messages (4000 Through 4999)