Mitsubishi Electric MELSEC iQ-R Series, Programming Manual

Page: 969 / 2110

7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
967
7
• The following figure shows the operation of the completion device at completion of the DBUPDATE(P) instruction.
• SM753 (File being accessed) turns on while the DBUPDATE(P) instruction is executed.
*1
While SM753 is on, the
DBUPDATE(P) instruction cannot be executed. If executed, no processing is performed. However, the instruction has been
completed with an error while the database access instruction is being executed.
• When "To Use or Not to Use the Built-in Database Access" is set to "Use" in the module parameter of the CPU module, the
DBUPDATE(P) instruction cannot be executed while SM1498 (CPU module database start-up flag) is off.
*1
If executed, no
processing is performed.
*1 For the firmware versions supporting SM753 and SM1498, refer to the list of special relay areas. (  MELSEC iQ-R CPU Module
User's Manual (Application))
Precautions
In the following cases, the error completion signal in (d1)+1 is turned on and an error code is stored as the completion status
in the device (d2).
• The DBUPDATE(P) instruction is executed during execution of the database access instruction.
• An identification number outside the range 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 characters of the table name specified by (s2) exceeds 32.
• An out-of-range value is specified in (s3) for the number of fields to be updated.
• An out-of-range field name is set in the field name specified by (s3)+1 to (s3)+

.
• An out-of-range value is specified in (s5) for the condition size.
• The size of the first condition in (s5) is set to 0.
• An out-of-range value is specified in (s5) for the condition symbol.
• An out-of-range value is specified in (s5) for the logical operator setting value.
• Database update processing failed.
• The logical operator setting value specified by (s5)+35 is 1 or 2, and that in (s5)+1 is set to 0.
• The range of the data for one record set in (s4)+2 does not match the size specified by (s4).
• The field name to be set in (s5)+2 is left unset.
Operation error
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), (s5), or (d1) exceeds the applicable range of the device/label used.
OFF
OFF
ON
ON
Program
DBUPDATE(P) instruction
END processing END processing
Updating the
database
Completion device (d1)
Completion device (d1)+1
END processing
Error completion