SQL/MP Messages Manual

FastSort Messages
HP NonStop SQL/MP Messages Manual—427720-006
21-7
FastSort 27
Cause. The specified output file exists but is too small or has a wrong type.
SORTPROG cannot purge the file and create a new one because of the file's security,
current usage, or some other condition in the system.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Follow recovery recommendations in the Guardian Procedure Errors and
Messages Manual for the operating system error code returned with this FastSort error
code. If the problem is security or current usage, you can change the security for the
file or prevent concurrent access to it.
FastSort 28
Cause. SORTPROG could not open the scratch file.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Follow the recovery recommendations in the Guardian Procedure Errors
and Messages Manual for the operating system error code returned with this FastSort
error code.
FastSort 29
Cause. SORTPROG could not write to the output file, probably because you or
FastSort underestimated the number of input records.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. If FastSort underestimated the number of input records, you can specify
the number of records or name an existing file large enough to hold the output records.
Follow recovery recommendations in the Guardian Procedure Errors and Messages
Manual for the operating system error code returned with this FastSort error code. If
you have created the target table, be sure that the table is large enough to hold the
output records.
27 The TO file already exists and cannot be purged.
28 A SCRATCH file cannot be opened.
29 A write has failed to the TO file.