Omron Corporation

Masaru Nakasaki

Yoshihide Nishiyama

Kotaro Okamura

Masanori Ota

Koji Yaoita

Minoru Oka

Provided is a technique enables programming, including that for database operations, without describing a SQL used to operate the database. A PLC () that can access a DBMS () stores a user program () and definition information (), the user program () including a structure type of variable, the definition information () indicating a definition of the structure type. The sequence command program () sequentially executes instructions in the user program () and invokes a DB access process program () in order to access the DBMS (). The DB access process program () reads the definition information () and, on the basis of the read definition information (), generates a SQL statement to be used when access to the DBMS () is made by execution of the user program (). The DB access process program () executes the generated SQL statement by transmitting the SQL statement to the DB server ().

Control device

A technique for facilitating debugging in a user program which operates by cooperation of a PLC and another system in a control system including a controller and another system. A CPU unit has a communication interface, executes a user program, calls DB connection service in accordance with an instruction included in the user program, and generates a statement to access a database device. In the DB connection service, operation is performed while switching a first mode and a second mode. In the first mode, a statement according to an access instruction is generated, the generated statement is transmitted to a database system, and a result of a response is sent to the user program. In the second mode, without transmitting the statement to the database device, a result of execution corresponding to the statement is sent to the user program.

Growing community of inventors

Kyoto, Japan

Masaru Nakasaki