HP NonStop SQL/MX, Messages Manual

Page: 212 / 752

Binder and Compilation Messages (4000 through
4999)
HP NonStop SQL/MX Messages Manual —640324-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 .