KFAA31696-E

The data DB area for storing tables or indexes is not specified in the CREATE TABLE or CREATE INDEX statement. <SQLSTATE: 58024>

               S:

                  Ignores this SQL statement. Alternatively, the system invalidates this transaction.

               Action:

                  Take one of the following actions:

                  ■ Correct the SQL statement.

                  If the CREATE TABLE statement resulted in an error, add either or both of the following specifications to the CREATE TABLE statement.

                        Specification of IN DB-area-name that specifies the DB area in which defined tables are to be stored

                        Specification of IN DB-area-name in a uniqueness constraint definition

                  For details about the IN DB-area-name specification, see Explanation of specification format in Specification format and rules for the CREATE TABLE statement in the manual HADB SQL Reference.

                  If the CREATE INDEX statement resulted in an error, add the following specification to the CREATE INDEX statement.

                        Specification of IN DB-area-name that specifies the DB area in which defined indexes are to be stored

                  For details about the IN DB-area-name specification, see Explanation of specification format in Specification format and rules for the CREATE INDEX statement in the manual HADB SQL Reference.

                  ■ Specify the adb_sql_default_dbarea_shared operand in the server definition.

                  For the adb_sql_default_dbarea_shared operand, specify the DB area name that is assumed if the IN DB-area-name specification is omitted.