SQL/MX 2.x Messages Manual (G06.24+, H06.03+)

Privilege and Alias Messages (1000 through 1999)
HP NonStop SQL/MX Messages Manual—523730-004
3-45
Recovery. Fix the error conditions identified in messages preceding this message and
reissue the CREATE PROCEDURE statement.
SQL 1232
Where table-name is the table being dropped whose DDL was to be saved.
Where oss-pathname is the HP NonStop Kernel Open System Services (OSS)
pathname of the file to which the DDL was to be saved.
Cause. An OSS 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 OSS 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.
SQL 1233
Where catalog-name is the name of the SQL/MX 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 1234
Where object-name is the name of the SQL/MP object.
Cause. An ALTER SQL/MP ALIAS command specified the same SQL/MP database
object as was previously mapped.
Effect. The operation succeeds. This is a warning message only.
1232 A file error occurred when saving dropped table DDL for
table table-name to oss-pathname.
1233 Creating schema in SQL/MX system catalog catalog-name is
prohibited.
1234 SQL/MP object object-name is the same as previous
mapping.