Data Manipulation Language Statements › Logical Record Clauses › Logical-Record Status Codes

Logical-Record Status Codes

A path status of LR-ERROR signifies an error in the processing of a logical-record request. When the error occurs in the request itself, LRF returns a path of LR-ERROR to the LR-STATUS field of the logical-record request control (LRC) block and places one of the following codes in the ERRSTAT field of the IDMS communications block:

2008

The named logical record is not defined in the subschema, or the specified DML verb is not permitted with the named logical record. The logical record name may have been misspelled.

2010

The subschema prohibits access to logical records.

2018

A path command has attempted to access a database record that has not been bound.

2040

The WHERE clause in an @OBTAIN NEXT statement has directed LRF to a different processing path than did the WHERE clause in the preceding @OBTAIN statement for the same logical record. Either the WHERE clause is incorrect or an @OBTAIN FIRST should have been issued instead of @OBTAIN NEXT.

2041

LRF was unable to match the request's WHERE clause to a path in the subschema.

2042

The logical-record path for the request specifies return of the LR-ERROR path status to the program.

2043

Bad or inconsistent data was encountered in the logical-record buffer during evaluation of the request's WHERE clause:

• A WHERE clause has specified that a packed decimal field should be compared to a field that is not packed; the field that is not packed cannot be converted to packed because it contains nonnumeric data.
• Data in variable storage or in a database record does not conform to its description.

A path status of LR-ERROR is returned to the program unless the DBA has included an ON clause in the path to override this action.

2044

The request's WHERE clause does not include information required by the logical-record path.

2045

A subscript value in a WHERE clause is either less than 0 or greater than its maximum allowed value. A path status of LR-ERROR is returned to the program unless the DBA has included an ON clause in the path to override this action.

2046

A program check has been issued during evaluation of a WHERE clause for one of the following reasons:

• An arithmetic overflow would occur (fixed point, decimal, or exponent).
• An arithmetic underflow would occur (exponent).
• A divide exception would occur (fixed point, decimal, or floating point).
• A significance exception has occurred.

A path status of LR-ERROR is returned to the program unless the DBA has included an ON clause in the path to override this action.

2063

A request's WHERE clause contains a keyword that exceeds 32 characters.

2064

A path command has attempted to access a CALC data item that has not been defined properly in the subschema.

2072

LRF cannot acquire sufficient storage to evaluate the request.

These status codes can result from any of the logical-record DML statements with the exception of 2040, which applies to @OBTAIN NEXT only.