7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
947
7
■Applicable devices
• These instructions import the data stored in the Unicode text file specified by (s) and construct a database. Information
such as a table configuration needs to be defined in advance in the Unicode text file used by the DBIMPORT(P) instruction.
( MELSEC iQ-R CPU Module User's Manual (Application))
• When the database that is already open exists and the DBIMPORT(P) instruction is executed, it is completed with an error.
• Upon successful completion, the completion signal in the completion device (d1)+0 is turned on and 0 is stored as the
completion status in the device (d2).
• The following figure shows the operation of the completion device at completion of the DBIMPORT(P) instruction.
• SM753 (File being accessed) turns on while the DBIMPORT(P) instruction is being executed.
*1
While SM753 is on, the
DBIMPORT(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
DBIMPORT(P) instruction cannot be executed while SM1498 (CPU module database start-up flag) is off.
*1
If executed, no
processing is performed.
• When DBIMPORT(P) instruction is executed, if a database with the name specified in the Unicode text file specified by (s)
exists on the same path as the Unicode text file, the database with the same name on the SD memory card (in the
database folder) is deleted and a new database is created with the name specified in the Unicode text file.
*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))
Operand Bit Word Double word Indirect
specification
Constant Others
X, Y, M, L,
SM, F, B, SB,
FX, FY
J\ T, ST, C, D, W,
SD, SW, FD, R,
ZR, RD
U\G, J\,
U3E\(H)G
Z LT, LST,
LC
LZ K, H E $
(s)
(d1)
(d2)
OFF
OFF
ON
ON
Program
DBIMPORT(P) instruction
END processing END processing
Importing data to
the database
Completion device (d1)
Completion device (d1)+1
END processing
Error completion