CREATE MULTISET TABLE dbname.tablename ,NO FALLBACK , NO BEFORE JOURNAL, NO AFTER JOURNAL, CHECKSUM = DEFAULT ( SYSTEM_CODE VARCHAR(10) CHARACTER SET LATIN CASESPECIFIC, SEQUENCE_NUM INTEGER TITLE 'Sequence Number' NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1 INCREMENT BY 1 MINVALUE -2147483647 MAXVALUE 2147483647 NO CYCLE), SOURCE_ID VARCHAR(3) CHARACTER SET LATIN CASESPECIFIC) PRIMARY INDEX XNUPI_ORDER_DOC_ADDRESS_NOTES ( SYSTEM_CODE, SEQUENCE_NUM );
[NCR] [Teradata DBMS] : Illegal usage of Identity Column SEQUENCE_NUM. [SQL State=HY000, DB Errorcode=5784]
How to avoid this error? Ans: Try to use only the Identity column as the PI. It is allowed.
Note: It will help if you are okay with this single column PI.