Start of change

-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

End of change