topic Re: Not able to add foreign keys through tmssqlrow component in Talend Studio

Not able to add foreign keys through tmssqlrow component

Anonymous — Tue, 12 Mar 2019 12:18:32 GMT

I am trying to add constraints through tmssqlrow component using below statement but it is failing with below error. But there is no "}" symbol in my query.

Any help is greatly appreciated!

Error:

Error Line: 1175
Detail Message: Syntax error on token "}", delete this token
There may be some other errors caused by JVM compatibility. Make sure your JVM setup is similar to the studio.

Flow:tPrejob --> tmssqlrow

Statement:

alter table POLICY.Tx_Account WITH CHECK ADD CONSTRAINT FK1_Tx_ACCOUNT_Tx_POLICYBENEFIT FOREIGN KEY (Tx_Policy_Benefit_ID)
REFERENCES POLICY.Tx_PolicyBenefit (Tx_Policy_Benefit_ID)

Re: Not able to add foreign keys through tmssqlrow component

manodwhb — Tue, 12 Mar 2019 12:38:21 GMT

@harsh_kothari , have you specified that query between double quotes?

Re: Not able to add foreign keys through tmssqlrow component

Anonymous — Tue, 12 Mar 2019 13:02:05 GMT

I did gave it in double quotes but as soon as i hit ok, the double quote vanishes.

Re: Not able to add foreign keys through tmssqlrow component

vapukov — Tue, 12 Mar 2019 13:09:02 GMT

Hi,

does your statements enquired by ""?

"alter table POLICY.Tx_Account WITH CHECK ADD CONSTRAINT FK1_Tx_ACCOUNT_Tx_POLICYBENEFIT FOREIGN KEY (Tx_Policy_Benefit_ID)
REFERENCES POLICY.Tx_PolicyBenefit (Tx_Policy_Benefit_ID)"