15.00 - 5891 An invalid queue table creation or alter was supplied. - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Language
English (United States)
Last Update
2018-09-24

5891 An invalid queue table creation or alter was supplied.

Explanation:

The CREATE TABLE or ALTER TABLE statement contains an option, or specification, that is not valid for queue tables. The following variations are not allowed for queue tables: - Dropping the QITS column, - LOB data type column, - Lob UDT data type column, - GLOBAL TEMPORARY clause, - VOLATILE clause, - UNIQUE, or PRIMARY KEY, clause for the QITS column, - SET is specified or defaulted and the QITS is the only column, - PARTITION BY clause, - BEFORE/AFTER JOURNAL clause, - or the AS clause, - Changing the NOT NULL attribute of the QITS column, - Changing the DEFAULT attribute of the QITS column.

Generated By:

Syntaxer modules.

For Whom:

End User.

Remedy:

Remove the invalid option from the CREATE TABLE or ALTER TABLE statement.