7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
975
7
In the following cases, the error completion signal in (d2)+1 is turned on and an error code is stored as the completion status
in the device (d3).
• The DBSELECT(P) instruction is executed during execution of the database access instruction.
• An invalid identification number is specified by (s1).
• An identification number of a database which is not open is specified by (s1).
• A database built or operated with a programmable controller CPU with firmware version "28" or later is specified by (s1) for
a programmable controller CPU with firmware version earlier than "28".
• The table name specified by (s2) does not exist.
• The number of fields to be searched according to (s3) exceeds the maximum value.
• An out-of-range field name is set in the field name specified by (s3)+1 to (s3)+.
• The number of records to be searched according to (s4) exceeds the maximum value.
• The size of the field to be searched according to (s4) is outside the range.
• Database selection processing failed.
• The number of records output to (d1) exceeds the number specified by (s4).
• The size of the records output to (d1) exceeds the size specified by (s4).
• The logical operator setting value specified by (s4) is out of the range.
• The logical operator setting value specified by (s4)+37 is 1 or 2, and that in (s4)+1 is set to 0.
• 0 is set in (s4) and a value other than 0 is set in (s4)+1.
For the error code stored in the completion status of the operand, refer to the following.
Page 986 Error codes related to database access instructions
Error code
(SD0)
Description
2820H The area specified by (s2), (s3), (s4), (d1), or (d2) exceeds the applicable range of the device/label used.