illegal usage of identity column teradata -

getting error while creating volatile table illegal usage of identity column..

create volatile table t1 (     id1 integer generated identity (start 1 increment 1 minvalue 0 maxvalue 100 no cycle),     nosec bigint ) on commit preserve rows; 

well, when read error messages indicates identity columns not supported volatile tables.

this cut&paste messages manual:

5784 illegal usage of identity column %vstr.

explanation: user attempted define invalid identity column or use identity column incorrectly. error returned if:

1) identity column defined

• a) part of composite index
• b) join index or hash index
• c) primary partition index
• d) value-ordered index.

2) input parameter of insert identity column using field (e.g., :f1) part of expression, e.g. :f1+:f2 or :f1+2.

3) an identity column defined in temporary or **volatile table. may defined in permanent table.

4) using statement contains multiple insert statements insert different identity column tables.

5) input parameter of insert identity column of type default using field (e.g., :f1) being reused in parameter in insert statement, e.g. using(f1 int, f2 int) ins tab(:f1,:f1);