Unable to determine association between statement parameters

[Developer9]

Hi ,

I am getting the following error while updating data in SQL server database using ODBC connector stage

Code: Select all

UPDATE 
   SCHEMA.TABLE
 SET
	  EMP  = ORCHESTRATE.EMP ,  COLC  = 'N'
 WHERE
	EMP = 1
	AND COLA = ORCHESTRATE.COLA
	AND COLB = ORCHESTRATE.COLB
	AND COLC  = ORCHESTRATE.COLC

Warning message :

Code: Select all

TABLE: 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

Please let me know any issues with the SQL I used in the job

Thank you

[kduke]

Have it generate the SQL then modify it.

[chulett]

Exactly, so you can get an idea how you should have crafted the SQL based on your column metadata. I suspect the first cause noted here.