Teradata_Connector_95: Unable to determine association between statement parameters and table columns. The connector will not be able to obtain external schema and only limited schema reconciliation will be performed
The Query used
Code: Select all
UPDATE
XXXXXXX_WORK_STND_TBL
SET
XXXXXXX_LAST_UPDT_PROC_R=ORCHESTRATE.XXXXXXX_LAST_UPDT_PROC_R,
XXXXXXX_LAST_UPDT_S=ORCHESTRATE.XXXXXXX_LAST_UPDT_S,
XXXXXXX_STRING1_X=ORCHESTRATE.XXXXXXX_STRING1_X,
XXXXXXX_EFF_OUT_Y=ORCHESTRATE.XXXXXXX_EFF_OUT_Y,
XXXXXXX_EFF_IN_Y=ORCHESTRATE.XXXXXXX_EFF_IN_Y
WHERE
XXXXXXX_ABCDE_C=ORCHESTRATE.XXXXXXX_ABCDE_C AND
XXXXXXX_DEPQRSMENT_C=ORCHESTRATE.XXXXXXX_DEPQRSMENT_C AND
XXXXXXX_PQRS_BASE_R=ORCHESTRATE.XXXXXXX_PQRS_BASE_R AND
XXXXXXX_PQRS_PREFIX_R=ORCHESTRATE.XXXXXXX_PQRS_PREFIX_R AND
XXXXXXX_PQRS_SUFFIX_R=ORCHESTRATE.XXXXXXX_PQRS_SUFFIX_R AND
XXXXXXX_PQRS_CONTROL_R=ORCHESTRATE.XXXXXXX_PQRS_CONTROL_R AND
XXXXXXX_CAUSAL_GEN_C=ORCHESTRATE.XXXXXXX_CAUSAL_GEN_C AND
XXXXXXX_SERIAL_R=ORCHESTRATE.XXXXXXX_SERIAL_R AND
XXXXXXX_SRC_SYS_C=ORCHESTRATE.XXXXXXX_SRC_SYS_C AND
XXXXXXX_SRC_CREATE_S=ORCHESTRATE.XXXXXXX_SRC_CREATE_S
AND XXXXXXX_EFF_OUT_Y = '9999-12-31';
1. Can i use same column as both Update column and condition column as here XXXXXXX_EFF_OUT_Y
2. Can i hardcode a value in where condition.
Any help is mostly appriciated.