Are there any restrictions using MERGE via ODBC? I have MERGE statement which returns an error:
"[NCR][ODBC Teradata Driver][Teradata Database] The search condition must fully specify the Target table primary index and partition column(s) and expression must match INSERT specfication primary index and partition column(s)."
But when I replaced placeholders with any values (e.g. "ON id = ?" replaced with "ON id = 1") then it works.
The error appears to be from the Teradata SQL parser, so it is probably not specific to ODBC. Prior to 12.0, the syntax of the merge statement was rather limited. If you post the complete merge statement that you attempted and indicate which Teradata version you are using, I may be able to tell you more.