Neoview SQL Reference Manual (R2.3)

• OCTET_LENGTH
• POSITION
• SUBSTRING
• SUM
• TRIM
• UPPER
All other functions are Neoview SQL extensions.
Neoview SQL Error Messages
Neoview SQL reports error messages and exception conditions When an error condition occurs,
Neoview SQL returns a message number and a brief description of the condition. For example,
Neoview SQL might display this error message:
*** ERROR[1000] A syntax error occurred.
The message number is the SQLCODE value (without the sign). In this example, the SQLCODE
value is 1000.
To view detailed cause, effect, and recovery information for Neoview SQL and other errors, see
the Neoview Messages Manual.
Neoview SQL Error Messages 39