I'm trying to run two queries in Teradata (using the JDBC driver) and keep getting this error that drives me crazy.
I try to run a routine query followed by a create table query:
create table xxxxxx
with data unique primary index();
I keep getting the same error:
"Data definition not valid unless solitary"
Any idea on how I can fix this and be able to run both queries subsequently?