-4747 THE CREATE OR ALTER TABLE STATEMENT FAILED BECAUSE SOME FUNCTIONALITY WAS SPECIFIED IN THE TABLE DEFINITION THAT IS NOT SUPPORTED WITH THE TABLE TYPE. UNSUPPORTED FUNCTIONALITY:functionality-keyword.
Explanation
An accelerator-only table cannot be defined with the following keywords or clauses:
- APPEND
- AUDIT
- BUFFERPOOL
- CHECK constraint
- COMPRESS
- DATA CAPTURE
- DSSIZE
- EDITPROC
- FIELDPROC
- FOREIGN KEY
- GENERATED
- HASH
- IMPLICITLY HIDDEN
- IN TABLESPACE
- INLINE LENGTH
- LOGGED or NOT LOGGED
- MEMBER CLUSTER
- PARTITION BY
- PERIOD
- PRIMARY KEY
- TRACKMOD
- UNIQUE
- VALIDPROC
- VOLATILE
- WITH DEFAULT
System action
The statement cannot be processed.
Programmer response
Respond to this message in one of the following ways:
- Reissue the CREATE TABLE statement without specifying the unsupported functionality given in the message token functionality-keyword.
SQLSTATE
429CB