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
Post a Comment