SQL/MP Messages Manual

SQLCI Utility Processor Messages (9000 to 9999)
HP NonStop SQL/MP Messages Manual—427720-006
11-43
SQL 9144
Cause. The disk label or the INDEXES table was corrupted.
Effect. The command continues.
Recovery. None. Report the entire message to your service provider.
SQL 9146
Cause. You specified a file record length that was shorter than the DDL record
definition implied. There might be an error in either the file name or the DDL record
name.
SQL/MP determines a file's record length either from the size given when the file was
created, or from the value specified in a RECIN or RECOUT option. The length of a
record description is that of the DDL record definition specified via SOURCEREC or
TARGETREC. If no DDL record definition was specified, one is implied from the SQL
definition of the other file in the command.
Effect. None. The COPY, LOAD, APPEND, or APPENDRESTART command
continues to run as entered.
Recovery. Informational message only; no corrective action is needed. If the
mismatch in record lengths does cause an error, determine whether the problem was
caused by the wrong DDL record definition or the wrong file name. Correct the one in
error, and reissue the command.
SQL 9147
Cause. The PURGEDATA PARTONLY option only applies to a table that does not
have indexes.
Effect. The PURGEDATA command fails.
Recovery. Drop the indexes that are defined on the table or reissue the command
without the PARTONLY option.
9144 Version mismatch. The SQL index value-1 has a version
number of value-2 in its disk label, which does not match the
version number of value-3 in the object description in the
value-4.INDEXES catalog table.
9146 The record length for value-1 (value-2) is shorter than
the length of the record description associated with that
file (value-3).
9147 The PURGEDATA command using the PARTONLY option cannot
operate on SQL table value-1 because the table has dependent
indexes.