Not able to add foreign keys through tmssqlrow component

[Anonymous]

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)

[manodwhb]

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

[Anonymous]

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

[vapukov · Accepted solution]

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)"