topic Re: tdboutput with reserved word in Talend Studio

tdboutput with reserved word

MBourassa1682971203 — Fri, 02 Jan 2026 14:45:42 GMT

Hi,

I do a tbdinput with this query:

select AA_ID
,DIAGNOSISCLASSCODE
,'GROUP'
,ALLOWEDFUNCIONALCLASS
from XXX

And I have linked this to a tdboutput,

I get this error: BatchUpdateException: Incorrect syntax near 'GROUP'.

I have tried with "GROUP" -> BatchUpdateException: Incorrect syntax near the keyword 'GROUP'.

Is there a way to do this ?

N.B.: I use a dynamic schema.

Thank you

Re: tdboutput with reserved word

Xiaodi_Shi — Thu, 14 Mar 2024 01:53:14 GMT

Hello,

Is this an actual column in your DB?

For code generation, the "reserved" keyword is used for that process; and should not be used as a row column name for the schema. This doesn't apply to the "db column", which can be kept with the name at this time.

Best regards

Sabrina

Re: tdboutput with reserved word

MBourassa1682971203 — Thu, 21 Mar 2024 20:11:43 GMT

Hi Sabrina,

Thank you for your help.

At the source there is a column named "GROUP" and I can change this, I'm not the owner.

I get this error when I want to insert this in mssql in a table already created.

Re: tdboutput with reserved word

Shicong_Hong — Sun, 24 Mar 2024 14:41:09 GMT

Maybe this link is helpful, change the query to be as below:

"select AA_ID
,DIAGNOSISCLASSCODE
,\"GROUP\"
,ALLOWEDFUNCIONALCLASS
from XXX"

"select AA_ID
,DIAGNOSISCLASSCODE
,\\[GROUP\\"
,ALLOWEDFUNCIONALCLASS
from XXX"