I'm trying to create a Queue table in a Teradata Database Express environment but unsuccessful to do so.
CREATE TABLE T_Queue, QUEUE (
qits TIMESTAMP(6) NOT NULL DEFAULT CURRENT_TIMESTAMP(6)
,qsn INTEGER GENERATED ALWAYS AS IDENTITY (NO CYCLE)
) UNIQUE PRIMARY INDEX (qsn)
The error is: CREATE TABLE Failed. 5891: An invalid queue table creation or alter was supplied.
What seems to be the problem?
Interestingly enough I am currently observing training where this very question just came up.
Check your ODBC settings: go into Advanced and see if Disable Parsing is ticked, if not, tick it. This is most likely the ODBC driver changing the TIMESTAMP(6) field.
I hope this works!