SQL/MP Messages Manual

FastSort Messages
HP NonStop SQL/MP Messages Manual—427720-006
21-12
FastSort 45
Cause. The SORT DEFINE BLOCK attribute specifies an invalid scratch file block
size.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Change the SORT DEFINE BLOCK attribute to specify a block size in the
range of 512 to 4096 for remote or partitioned scratch files or in the range of 512 to
30,720 for local nonpartitioned files.
FastSort 46
Cause. The offset of a real numerical key field inside the record is not on a word
boundary.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Correct either the offset or the record layout.
FastSort 47
Cause. The calling process called SORTMERGESTATISTICS at the wrong time.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Correct your program logic.
FastSort 48
Cause. A key field of a signed numerical type is too big.
Effect. The SQL DDL or DML operation in progress terminates abnormally.
Recovery. Change the key-field type in the syntax, or change the key-field format.
45 Invalid SCRATCH file block size.
46 Real number keys must be word aligned.
47 SORTMERGESTATISTICS has been called unexpectedly.
48 A signed ASCII numeric key is larger than 32 bytes.