Programmable controller, peripheral device thereof, and table data access program of programmable controller

A programmable controller comprising:

• a processor to execute multiple commands in a user program in order;
• at least one memory having a database storage, which stores therein a database that holds data used in a process performed by the processor in a table format;
• the memory further comprises a system-data storage, which stores therein database-access setting information that sets a condition acquiring data included in the database in the database storage;
• wherein, when the commands include an instruction to access the database, the processor converts the database-access setting information in the system-data storage into a database query command described in a database query language;
• wherein the processor is further configured:
• to access the database in the database storage, and
• to access data specified by the database query command,
• wherein the database-access setting information includes:
• database specification information that specifies the database in the database storage, and
• an access-target specification condition that includes a name of a table of the database, and
• wherein the processor generates the database query command from the database-access setting information in accordance with command conversion information in which information included in the database-access setting information corresponds to a parameter of the database query command.

A non-transitory computer readable medium storing a table data access program, which when executed by a programmable controller, causes the programmable controller to:

• repeatedly execute commands of a user program in order from a first normal command to an END command described at an end of the commands and in the process of executing a normal command, accesses a database that holds data used in a process of executing a normal command in a table format, and
• access the database when the normal command is executed,
• wherein the table data access program, when executed, causes the programmable controller to further execute:
• a database-query-command generation procedure of, when the normal command includes a command to access the database, converting the access command into a database query command described in a database query language;
• a database management procedure of
• accessing the database stored in a memory, and
• accessing data in the database specified by the database query command so as to perform a predetermined process, and
• an END command processing procedure of executing an END command including a process of acquiring the result of executing the database query command,
• wherein in the END command processing procedure,
• when a process corresponding to the database query command issued is completed, a completion checking process of writing the data acquired by the database management procedure in an address specified by the command to access the database of the memory is performed, and
• when the process corresponding to the database query command issued is not completed, the completion checking process is performed at a time of executing a next END command.

A non-transitory computer readable medium storing a table data access program, which when executed by a programmable controller causes the programmable controller to:

• repeatedly execute commands of a user program in order from a first normal command to an END command described at an end of the commands, and
• access a database that holds data used in a process of executing a normal command in a table format, when the normal command is executed,
• wherein the table data access program, when executed, causes the programmable controller to further execute:
• a database-query-command generation procedure of, when the normal command includes an instruction to access the database, converting database-access setting information in a system-data memory into a database query command described in a database query language;
• and
• a database management procedure of
• accessing the database in the memory, and
• accessing data specified by the database query command so as to perform a predetermined process, wherein:
• the database-access setting information includes
• database specification information that specifies the database, and
• an access-target specification condition that includes a name of a table of the database, and
• wherein the table data access program, when executed, causes the programmable controller to generate the database query command from the database-access setting information in accordance with command conversion information in which information included in the database-access setting information corresponds to a parameter of the database query command.