Generator messages (7000 through 7999)

SQL 7000

7000 An internal error occurred in the code generator in file nameat line number: text.

Cause

The code generator received an internal error in file name at line number. Additional information appears in text.

Effect

The operation fails.

Recovery

Contact your service provider.

SQL 7001

7001 Default value value is not valid for column name.

Cause

You attempted to create a table with an invalid default value for column name.

Effect

The operation fails.

Recovery

Correct the syntax and resubmit.

SQL 7003

7003 A plan using cluster sampling could not be produced for this query.

Cause

You can use cluster sampling in a query only on a base table result set and only if there is no WHERE clause in the SELECT statement. This query does not satisfy these conditions.

Effect

NonStop SQL/MX is unable to compile the query.

Recovery

Rewrite the query (for example, using nested queries) so that cluster sampling is performed on a base table with no WHERE-clause predicate.

SQL 7007

7007 The input or ouput row size rowsize bytes, is greater than the maximum buffer size maxsize.

Where,

rowsize is the size of the input/output row in bytes;

maxsize is the maximum size, in bytes, the buffer can hold.

Cause

The size of the output row or the total size of the input parameters (input row) is greater than the maximum SQL buffer size.

Effect

SQL/MX is unable to compile the query.

Recovery

Rewrite the query so that the input or output row length is less than the SQL buffer size.