How to handle double quote in Column Name (Teradata)
Posted: Thu Sep 07, 2017 9:41 pm
Hi,
I have a requirement to handle double quote in the teradata column name. Since teradata does not accept column which are same as reserved words so it has been created as "TITLE".
I have a RCP enabled job, where source and target table have this kind of column ("TITLE").
While I read this column as "TITLE" (in SELECT query) the output column name coverts to TITLE (double quote gets removed).
But I get error while loading into such kind of table. Since double quote is removed from column name.
Before loading I tried to convert back/rename to have this column as "TITLE" using modify stage but not able to do.
Any suggestion how I can handle this INSERT or rename back to have double quote.
Thanks,
Rohit
I have a requirement to handle double quote in the teradata column name. Since teradata does not accept column which are same as reserved words so it has been created as "TITLE".
I have a RCP enabled job, where source and target table have this kind of column ("TITLE").
While I read this column as "TITLE" (in SELECT query) the output column name coverts to TITLE (double quote gets removed).
But I get error while loading into such kind of table. Since double quote is removed from column name.
Before loading I tried to convert back/rename to have this column as "TITLE" using modify stage but not able to do.
Any suggestion how I can handle this INSERT or rename back to have double quote.
Thanks,
Rohit