tdboutput with reserved word

[MBourassa1682971203]

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

[Xiaodi_Shi]

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

[MBourassa1682971203]

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.

[Shicong_Hong]

Hi 

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

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

or 

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