Mitsubishi Electric MELSEC iQ-R-R6SFM - Page 241

13 DATABASE FUNCTION
13.2 Database Access Instruction
239
13
Ex.
Example of the Unicode text file format (Database name: database1, Table name: product-info1)
Unicode text files can be created using a text editor or spreadsheet software program. The method for saving
Unicode text files in Notepad or Excel is as follows:
• In the text editor (Notepad, an accessory of Windows

7), select [Save As] from the [File] menu, and select
"Unicode" as the character code to save the file.
• In the spreadsheet software program (Excel 2010), select [Save As] from the [File] menu, and select
"Unicode" as the file type to save the file. When a Unicode text file is created using a spreadsheet software
program, tabs are automatically inserted by saving the file. Therefore, it is not necessary to insert tabs into
the file in the spreadsheet software program.
proid1 proinfo1 proinfo2
proinfon
1
1001
1010
abcd
abcd
abcd
efgh
efgh
efgh
pqrs
pqrs
pqrs tuv
Key restriction: Main key
Data type: INT
Data type: STRING, Number of characters: 124
Key restriction: None
//Database name
database1
<table>
//Table name
product-info1
//Field name
proid1 [Tab] proinfo1 [Tab] ... [Tab] proinfon
//Data type
INT [Tab] STRING: 124 [Tab] ... [Tab] STRING: 124
//Key restriction
1: pk1 [Tab] 0 [Tab] ... [Tab] 0
//Index
0
//Record
//First record
1 [Tab] abcd [Tab] efgh [Tab] ... [Tab] pqrs
//Second record
1001 [Tab] abcd [Tab] efgh [Tab] ... [Tab] pqrs tuv
//nth record
1010 [Tab] abcd [Tab] efgh [Tab] ... [Tab] pqrs
</table>