Previous Topic: -205 - INVALID DATATYPE xx FOR SCALAR FUNCTION nnNext Topic: -207 - RESULT DATATYPES IN CASE/COALESCE/NULLIF EXPRESSION ARE INCOMPATIBLE


-206 - OP2 NOT ALLOWED IF OP1 IS A TIMESTAMP FOR SCALAR FUNCTION CHAR

Explanation

You have issued a query with scalar function CHAR whose first operand is a TIMESTAMP and who specifies a second operand. This is illegal. See the CA Datacom/DB SQL User Guide for scalar functions.

The SQLSTATE that equates to this SQL return code is 53S22.

User Response

Correct the query to use the CHAR scalar function with the proper operands.