The next table describes the EGL error values for input/output (I/O) operations that affect databases, files, and MQSeries® message queues. The values associated with hard errors are available to your code only if the system variable VGVar.handleHardIOErrors is set to 1, as described in Exception handling.
Error value | Type of error | Type of Record | Meaning of error value |
---|---|---|---|
deadLock | Hard | SQL | Two program instances are trying to change a record, but neither can do so without system intervention. |
duplicate | Soft | Indexed or Relative | Your code tried to access a record having a key that already exists, and the attempt succeeded. For details, see duplicate. |
endOfFile | Soft | Indexed, Relative, Serial | For details, see endOfFile. |
ioError | Hard or Soft | Any | EGL received a non-zero return code from the I/O operation. |
format | Hard | Any | The accessed file is incompatible with the record definition. For details, see format. |
fileNotAvailable | Hard | Any | fileNotAvailable is possible for any I/O operation and could indicate, for example, that another program is using the file or that resources needed to access the file are scarce. |
fileNotFound | Hard | Indexed, Message queue, Relative, Serial | A file was not found. |
full | Hard | Indexed, Relative, Serial | full is set in these cases:
|
hardIOError | Hard | Any | A hard error occurred, which is any error except endOfFile, noRecordFound, or duplicate. |
noRecordFound | Soft | Any | For details, see noRecordFound. |
unique | Hard | Indexed, Relative, or SQL | UNQ indicates unique: your code tried to add or replace a record having a key that already exists, and the attempt failed. For details, see unique. |
The duplicate setting is returned only if the access method returns the information, as is true on some operating systems but not on others. The option is not available during SQL database access.
(An empty file is one from which all records have been deleted. An uninitialized file is one that has never had any records added to it.)
The file format (fixed or variable length) is different from the EGL record format.
In relation to fixed-length records, the length of a record in the file is different from the length of the EGL record. In relation to variable-length records, the length of a record in the file is larger than the length of the EGL record.
The file type specified for the record does not match the file type at run time.
The key length in the file is different from the key length in the EGL indexed record.
The key position in the file is different from the key position in the EGL indexed record.
The unique setting is returned only if the access method returns the information, as is true on some operating systems but not on others.
During SQL database access, unique is set when a SQL row being added or replaced has a key that already exists in a unique index. The corresponding sqlcode is -803.
Related reference
add
Association elements
close
delete
Exception handling
execute
get
get next
get previous
Logical expressions
open
prepare
replace