Queue Tables in Database Express

Database
Enthusiast

Queue Tables in Database Express

Hey guys,

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)

,col3 INTEGER

) UNIQUE PRIMARY INDEX (qsn)

INDEX (qits)

The error is: CREATE TABLE Failed. 5891: An invalid queue table creation or alter was supplied.

What seems to be the problem?

Thanks!

Tags (1)
2 REPLIES
Teradata Employee

Re: Queue Tables in Database Express

Det7,

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!

Andrew

Enthusiast

Re: Queue Tables in Database Express

Or use the .Net provider instead of ODBC in SQL Assistant.  It works perfectly there.