Mitsubishi Electric MELSEC iQ-R Series - Page 113

2 CPU MODULE INSTRUCTIONS
2.3 Application Instructions
111
2
■Calculating the mean value of 16-bit/32-bit binary data
■Calculating the square root of 16-bit/32-bit binary data
■CRC operation
Database access instructions
■Opening the database
■Closing the database
■Adding a record to the database
■Updating the record in the database
■Searching the record in the database
■Deleting the record in the database
Instruction symbol Processing details Reference
MEAN Calculates the average value of the (n) points of 16-bit data in the device starting from the one
specified by (s), and stores the average value in the device specified by (d).
Page 938
MEAN(P)(_U)
MEANP
MEAN_U
MEANP_U
DMEAN Calculates the average value of the (n) points of 32-bit data in the device starting from the one
specified by (s), and stores the average value in the device specified by (d).
Page 940
DMEAN(P)(_U)
DMEANP
DMEAN_U
DMEANP_U
Instruction symbol Processing details Reference
SQRT Performs a square root operation of the specified 16-bit binary data.
(s)
(d)
Page 942 SQRT(P)
SQRTP
DSQRT Performs a square root operation of the specified 32-bit binary data.
(s)+1, (s)
(d)
Page 943 DSQRT(P)
DSQRTP
Instruction symbol Processing details Reference
CRC Generates the CRC value for (n) 8-bit data (unit: byte) starting from the device specified by (s), and
store the CRC value to the device specified by (d).
Page 944 CRC(P)
CRCP
Instruction symbol Processing details Reference
DBOPEN Connects to the database specified by (s), and makes it available. Page 952 DBOPEN(P)
DBOPENP
Instruction symbol Processing details Reference
DBCLOSE Releases the identification number specified by (s) and the allocation of the database. Page 954
DBCLOSE(P)
DBCLOSEP
Instruction symbol Processing details Reference
DBINSERT Adds a record to the table specified by (s2) in the database corresponding to the identification
number specified by (s1).
Page 956
DBINSERT(P)
DBINSERTP
Instruction symbol Processing details Reference
DBUPDATE Updates all record that meets the condition specified by (s5) in the table specified by (s2) in the
database specified by the identification number specified by (s1).
Page 962
DBUPDATE(P)
DBUPDATEP
Instruction symbol Processing details Reference
DBSELECT Searches the records in the table specified by (s2) in the database corresponding to the
identification number specified by (s1).
Page 968
DBSELECT(P)
DBSELECTP
Instruction symbol Processing details Reference
DBDELETE Deletes the record that meets the condition specified by (s3) in the table specified by (s2) in the
database corresponding to the identification number specified by (s1).
Page 976
DBDELETE(P)
DBDELETEP