SQL/MX 3.2 Messages Manual (H06.25+, J06.14+)

Executor Sort and Scratch File I/O Messages (10000

through 10199)

HP NonStop SQL/MX Release 3.2 Messages Manual—691121-001

12-12

Scratch File I/O Messages

SQL 10101

Where,

operator is the SQL/MX query operator that encountered the error; for example:

merge join.

number is an SQL/MX platform internal procedure-error number.

Cause. The query operator was unable to create a scratch file.

Effect. The operation fails.

Recovery. Contact your service provider to diagnose the cause of the FILE_CREATE_

returned error and correct the problem.

SQL 10102

Where,

operator is the SQL/MX query operator that encountered the error; for example:

merge join.

number is a SQL/MX platform internal procedure-error number.

Cause. The query operator was unable to open a scratch file.

Effect. The operation fails.

Recovery. None. This is an internal error. Contact your service provider.

SQL 10103

Where,

operator is the SQL/MX query operator that encountered the error; for example:

merge join.

number is a SQL/MX platform internal procedure-error number.

10101 operator failed to create a scratch file. FILE_CREATE_

returned error number.

10102 operator failed to open a scratch file. FILE_OPEN_

returned error number.

10103 operator failed to close a scratch file. FILE_CLOSE_

returned error number.