Queue Table - Error while executing

Database
Enthusiast

Queue Table - Error while executing

Hi All,

I am trying to execute the following Create Table Statement for creating a Queue Table in Teradata and i am getting a syntax error. But as per the syntax diagram and the examples in the documentation, the syntax is correct. Can any one help me out in rectifying this?

create table quetable1, queue
(create_timestamp timestamp(6) not null default current_timestamp(6), a int, b int);

The error i am getting is
Code = 3706.
3706: Syntax error: Expected a CHECKSUM keyword.

I am using Teradata SQL Assistance for executing the script.

Thanks,
Manu.
1 REPLY
Enthusiast

Re: Queue Table - Error while executing

Got the Solution. I was trying to execute the Query against V2R5 where Queue Table support was not there. Queue Table support is there from V2R6 only.