Hitachi

Hitachi Advanced Database Messages


KFAA30673-E

"aa....aa" in the bb....bb statement is duplicated. (M+J+O)

An option was illegally specified more than once in a table or index definition. <SQLSTATE: 425D4>

aa....aa: Option specified more than once
  • BRANCH: BRANCH ALL specification

  • CORRECTIONRULE: Notation-correction-search text-index specification

  • EMPTY: Specifies unfinished status

  • EXCLUDE NULL VALUES: Null-value exclusion specification

  • INDEXTYPE: Index type specification

  • PCTFREE: Unused index area or unused table area specified

  • PRIMARY KEY: Uniqueness constraint definition

  • DELIMITER: Text-index delimiter specification

  • STORAGE FORMAT: Table-storage-format specification

bb....bb: Invalid SQL statement
  • CREATE INDEX

  • CREATE TABLE

S:

Ignores this SQL statement.

Action:

Correct the SQL statement.