Avoid storage-space errors
An SQL error occurs if you include an IN clause with the
CREATE TABLE statement and one of the following conditions is true:
- The IN clause specifies an extspace or sbspace that does not exist.
- The IN clause specifies an sbspace, but the am_sptype purpose
value is set to
X
. - The IN clause specifies an extspace, but the am_sptype purpose
value is set to
S
.
An SQL error occurs if the CREATE TABLE statement contains
no IN clause and one of the following conditions is true:
- The am_sptype purpose value is set to
A
, no default SBSPACENAME exists, and the access method does not create an extspace. - The am_sptype purpose value is set to
S
, and no default SBSPACENAME exists. - The am_sptype purpose value is set to
X
, and the access method does not create an extspace.
An SQL error occurs if one of the following conditions
is true:
- The am_sptype purpose value is set to
D
. - The IN clause with the CREATE TABLE statement specifies a dbspace,
even if the am_sptype purpose value is set to
A
.