SQL Server MEREG Statement Before SQL Error
Posted: Mon Jun 17, 2013 8:54 am
Hi All,
We r on DS 8.7 on Winddows 2008 R2
We are using a Row Generator stage to generate 1 Single record and then using the SQL Server MERGE statement to load data from Staging to Final table. This works fine when I use a 1-Node Configuraion and use this MERGE in the Before SQL (node) statement .
But when I put this same MERGE in Before SQL statement (NOT at node level) in a 2 Node Config file with only 1 Input record from the RG stage, as above, it Fails with Error saying a semi colon is needed at the end of the MERGE statement..I have this ; but it still fails here?
Error Code = 10,713: Msg = [Microsoft][SQL Server Native Client 10.0][SQL Server]A MERGE statement must be terminated by a semi-colon (;). (CC_OdbcAdapter::preRun, file CC_OdbcAdapter.cpp, line 434)
Any thoughts Why?
Thanks,
NV
We r on DS 8.7 on Winddows 2008 R2
We are using a Row Generator stage to generate 1 Single record and then using the SQL Server MERGE statement to load data from Staging to Final table. This works fine when I use a 1-Node Configuraion and use this MERGE in the Before SQL (node) statement .
But when I put this same MERGE in Before SQL statement (NOT at node level) in a 2 Node Config file with only 1 Input record from the RG stage, as above, it Fails with Error saying a semi colon is needed at the end of the MERGE statement..I have this ; but it still fails here?
Error Code = 10,713: Msg = [Microsoft][SQL Server Native Client 10.0][SQL Server]A MERGE statement must be terminated by a semi-colon (;). (CC_OdbcAdapter::preRun, file CC_OdbcAdapter.cpp, line 434)
Any thoughts Why?
Thanks,
NV