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

Versioning and Distribution Messages (25000
through 25399)
HP NonStop SQL/MX Messages Manual—523730-004
18-19
Distribution Messages (25400-25499)
SQL 25404
Where catalog1 and catalog2 are ANSI catalog names.
Cause. You attempted to establish a relationship between catalog1 and catalog2,
which have different visibility.
Effect. The operation fails.
Recovery. Correct the error and retry the operation.
SQL 25405
Where catalog is the ANSI name of the target catalog.
Where location is the location from a CREATE CATALOG operation.
Cause. A CREATE CATALOG operation specified a remote location, either explicitly or
because the default volume is remote.
Effect. The operation fails.
Recovery. Correct the error and retry the operation.
SQL 25406
Where type of object is the object type of object (for instance, index).
Where object is the ANSI name of a database object specified in the DML query.
Where node is the expand node name of a remote node where one or more partitions
of object resided when the DML query was compiled.
Cause. When the DML query was compiled, the affected database object had
partitions on a remote node, and the database object’s catalog was visible on both the
remote node and the local node. When the query was executed, the visibility of the
object’s catalog changed. See accompanying messages 1002, 25401, or 25403 for
more detail of the visibility change.
Effect. If the message is issued as an error, it is accompanied by error 1002, and the
query fails. If the message is issued as a warning, it is accompanied by warning 25401
25404 Catalogs catalog1 and catalog2 must have identical
visibility.
25405 Catalog catalog cannot be created because location
location is a remote node.
25406 Runtime visibility check failed for type of object
object trying to access node.