Neoview Messages Manual (Volume 1) (R2.5)

table-name
is the table being dropped whose DDL was to be saved.
platform-pathname
is the pathname of the file to which the DDL was to be saved.
Cause A file-system error occurred when you attempted to save a table DDL. Possible reasons
are:
• The directory /usr/tandem/sqlmx/ddl did not exist or could not be created.
• The system did not have write access to /usr/tandem/sqlmx/ddl
• Insufficient file space was available.
Effect The table is not dropped.
Recovery Either correct the file-system problem and drop the table or perform a SHOWDDL
on the existing table, capture the output, set. SAVE_DROPPED_TABLE_DDL to “OFF,” and
drop the table. For information about file-system errors, see Chapter 21 (page 385).
SQL 1233
1233 Creating schema in SQL/MX system catalog catalog-name is prohibited.
catalog-name
is the name of the HP Neoview database catalog.
Cause You attempted to create a schema in the system catalog.
Effect The operation fails.
Recovery Choose a different catalog name and reissue the CREATE statement.
SQL 1235
1235 An invalid combination of EXTENT sizes and MAXEXTENTS was specified
for table or index table-name.
Cause A CREATE or ALTER statement specified an invalid combination of EXTENT sizes
and MAXEXTENTS.
Effect The operation fails.
Recovery Correct the error and retry the operation. For information about EXTENT and
MAXEXTENTS, see the Neoview SQL Reference Manual.
SQL 1236
1236 The schema name specified for SQL object object-name is not valid.
The schema name must be the same as the schema being created.
object-name
is the name of the SQL object.
Cause You specified a schema name for an object that is different from the name of the
schema being created.
Effect The operation fails.
Recovery Specify a schema name for the object that matches the name of the schema being
created.
SQL 1238
1238 The character set used in TRIGGER text must be ISO88591.
Cause You specified a literal with a character set other than ISO88591 in the text of a create
trigger statement.
Effect The operation fails.
Recovery Specify only ISO88591 literals in the command.
SQL 1239
1239 The character set used for string literals in VIEW must be ISO88591.
46 Data Definition Language (DDL) Messages (1000 Through 1999)