teradata connection delete issue

bikan · Post by **bikan** » Fri Oct 31, 2008 1:08 am

Hi,

I have am using teradata connector stage as target and i am deleting record table based on below condition
ELETE
FROM test
WHERE (A = ORCHESTRATE.A
AND C = ORCHESTRATE.C
AND S = ORCHESTRATE.S
AND S = ORCHESTRATE.S
AND G = ORCHESTRATE.G
AND CRA = ORCHESTRATE.CRA)

I am getting below warning
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

there are no record for deletion but I want to know why this warning is coming.
the access ethod is immediate.
primary index of table test is on col A

hamzaqk · Post by **hamzaqk** » Mon Nov 03, 2008 4:29 am

there is a schema reconciliation option in the connector stage. try setting it to ignore......

toshea · Post by **toshea** » Thu Nov 06, 2008 12:28 pm

The schema reconcilation options won't get rid of that warning. That warning occurs when you specify the SQL yourself without using the Build button. The warning is harmless. You can ignore it.

toshea · Post by **toshea** » Tue Apr 10, 2012 10:06 am

You can use the DataStage message handler to suppress warnings.