Previous Topic: -504 - PLAN OPTION ERROR: error-stringNext Topic: -530 - PROC authid.name: msg-string


-505 - ON-CLAUSE ERROR: x NOT ALLOWED

Explanation

In the message above, x can be either NESTED QUERIES or COLUMN FUNCTIONS. An ON clause cannot contain a nested query, nor can column functions be used with an ON clause.

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

User Response

Remove the nested query or column function.