950
7 APPLICATION INSTRUCTIONS
7.21 Database Access Instructions
Processing details
• These instructions export the data in the database stored in the database folder at the path specified by (s) to the Unicode
text file.
• The Unicode text file is created in the folder where the database folder is stored. The file name is "database_name.txt". If
the same Unicode text file already exists, the file is overwritten with the exported data.
Ex.
When the path of the database folder is "2:\database\recipe1", executing the instruction creates Unicode text file
"2:\database\recipe1.txt" and exports data to the file.
• 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 DBEXPORT(P) instruction.
• The internal configuration of the Unicode text file to which data is exported is the same as the file to which data is imported
by the DBIMPORT(P) instruction. (
MELSEC iQ-R CPU Module User's Manual (Application))
• SM753 (File being accessed) turns on while the DBEXPORT(P) instruction is being executed.
*1
While SM753 is on, the
DBEXPORT(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
DBEXPORT(P) instruction cannot be executed while SM1498 (CPU module database start-up flag) is off.
*1
If executed, no
processing is performed.
• During transaction, the DBEXPORT(P) instruction cannot be executed.
*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 DBEXPORT(P) instruction is executed during execution of the database access instruction.
• The path specified by (s) is not a database.
• Writing data to the Unicode text failed due to the failure to access the database.
• The number of characters of the path (including the drive path character) specified by (s) exceeds 128.
• A database built or operated with a programmable controller CPU with firmware version "28" or later is specified in (s) for a
programmable controller CPU with firmware version earlier than "28".
• The DBEXPORT(P) instruction is executed during transaction.
OFF
OFF
ON
ON
Program
DBEXPORT(P) instruction
END processing
END processing
Exporting data
from the database
Completion device (d1)
Completion device (d1)+1
END processing
Error completion
Содержание MELSEC iQ-R Series
Страница 1: ...MELSEC iQ R Programming Manual Instructions Standard Functions Function Blocks ...
Страница 2: ......
Страница 24: ...22 INDEX 2092 INSTRUCTION INDEX 2093 REVISIONS 2104 WARRANTY 2105 TRADEMARKS 2106 ...
Страница 34: ...32 MEMO ...
Страница 35: ...33 PART 1 PART 1 OVERVIEW This part consists of the following chapter 1 OVERVIEW ...
Страница 68: ...66 1 OVERVIEW 1 5 Precautions on Programming MEMO ...
Страница 204: ...202 5 SEQUENCE INSTRUCTIONS 5 3 Output Instructions Operation error There is no operation error ...
Страница 470: ...468 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 472: ...470 6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions Operation error There is no operation error ...
Страница 479: ...6 BASIC INSTRUCTIONS 6 6 Data Conversion Instructions 477 6 Operation error There is no operation error ...
Страница 504: ...502 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 518: ...516 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 520: ...518 6 BASIC INSTRUCTIONS 6 7 Data Transfer Instructions Operation error There is no operation error ...
Страница 754: ...752 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 756: ...754 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 758: ...756 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 760: ...758 7 APPLICATION INSTRUCTIONS 7 9 Real Number Instructions Operation error There is no operation error ...
Страница 895: ...7 APPLICATION INSTRUCTIONS 7 16 Ramp Signal Instruction 893 7 Operation error There is no operation error ...
Страница 917: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 915 7 Operation error There is no operation error ...
Страница 919: ...7 APPLICATION INSTRUCTIONS 7 20 Data Processing Instructions 917 7 Operation error There is no operation error ...
Страница 1415: ...13 SFC PROGRAM INSTRUCTIONS 13 1 SFC Control Instructions 1413 13 Operation error There is no operation error ...
Страница 1448: ...1446 14 REDUNDANT SYSTEM INSTRUCTIONS 14 2 Disabling Enabling System Switching MEMO ...
Страница 1795: ...25 TYPE CONVERSION FUNCTIONS 25 1 Converting BOOL to WORD 1793 25 Operation error There is no operation error ...
Страница 1805: ...25 TYPE CONVERSION FUNCTIONS 25 10 Converting WORD to DINT 1803 25 Operation error There is no operation error ...
Страница 1819: ...25 TYPE CONVERSION FUNCTIONS 25 21 Converting INT to DWORD 1817 25 Operation error There is no operation error ...
Страница 1950: ...1948 32 STRING FUNCTIONS 32 2 Extracting String Data From the Left Right Operation error There is no operation error ...
Страница 1972: ...1970 33 TIME DATA TYPE FUNCTIONS 33 4 Division MEMO ...
Страница 2067: ...APPX Appendix 5 PID Control Program Examples 2065 A 252 Set PID control data for loop 2 ...
Страница 2082: ...2080 APPX Appendix 6 Process Control Program Examples 129 Set the default value of the loop tag ...
Страница 2093: ...APPX Appendix 7 List of Loop Tag Memory Areas Used by Process Control Instructions 2091 A MEMO ...
Страница 2109: ......