SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001
6-26
Recovery. See the Operator Messages Manual for information on EMS event
messages.
SQL 4104
Where 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
Cause. NonStop SQL/MX does not recognize the translation name.
Effect. NonStop SQL/MX is unable to compile the statement.
Recovery. Use one of the supported translation names.
SQL 4106
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.
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.
4105 Translation name is not recognized.
4106 The character set for the operand of function name1 must
be name2.