sql - Error while creating date column in tables- teradata -


proc sql; connect teradata tera(mode=teradata server=oneview user="&teraid." password="&terapwd.");  execute(create multiset table ud497.pan_am_email (     athnum        decimal(10,0),     blk_1_cde      char(1),     blk_2_cde      char(1),     open_dt         date,     language      char(7),     mktcell       char(2),     project_id     char(15),     campaign        char(35); ) primary index(athnum); ) tera; 

error message :

error: teradata execute: syntax error, expected 'check' keyword between ',' , 'language' keyword.

the error message suggests language keyword in teradata, double quote it:

"language"      char(7), 

but now, whenever use in sql, must double quote it, e.g.

select "language"... 

maybe change name.


Comments