Mitsubishi Electric MELSEC iQ-R-R00CPU - Page 237

13 DATABASE FUNCTION
13.1 Specifications
235
13
Available operations
The following table lists the operations that can be performed with the database functions.
: Can be performed, : Cannot be performed
• For details on the database access instructions, refer to the following.
 MELSEC iQ-R Programming Manual (CPU Module Instructions, Standard Functions/Function Blocks)
• For the available SQL commands for the CPU module database access function, refer to the following.
Page 996 List of Available SQL Commands for CPU Module Database Access Function
• The user cannot execute multiple database access instructions simultaneously. If they are executed
simultaneously, instructions other than the first one will be completed with an error.
• Even though the operation can be performed for the database of the CPU module by the SQL command, an
error occurs on the application side when it cannot be performed in the application. In this case, check the
details of the error and perform the operation within the range of the specifications of the application again.
Operation Description Database access instruction CPU module database
access function
Availability and instruction
symbol
Availability and application
Database Connection Connects to the specified database.  DBOPEN(P)  Microsoft Access

,
Excel

, user-created
application
Disconnection Disconnects from the specified database.  DBCLOSE(P) 
Import Imports the specified data from the
specified Unicode text file to create a
database.
 DBIMPORT(P) 
Export Exports the specified data in the specified
database into a Unicode text file.
 DBEXPORT(P) 
Table Add Adds a table to the database.  Microsoft Access

Record Access Accesses the specified table in the
database.
 Microsoft Access

Add Adds a record to the specified table of the
database.
 DBINSERT(P)  Microsoft Access

Update Updates the value of the specified record
on the specified table in the database.
 DBUPDATE(P)  Microsoft Access

Acquire
(Search)
Acquires the value of the specified record
on the specified table in the database.
 DBSELECT(P)  Excel

Delete Deletes the specified record on the
specified table in the database.
 DBDELETE(P)  Microsoft Access

Transaction Start Starts a transaction for the specified
database.
 DBTRANS(P)  Microsoft Access

(The
transaction range depends
on the application.)
Commit Commits a transaction for the specified
database.
 DBCOMMIT(P)  Microsoft Access

(The
transaction range depends
on the application.)
Rollback Performs rollback on the specified
database.
 DBROLBAK(P)  Microsoft Access

(The
transaction range depends
on the application.)
Database operation by a desired SQL  User-created application