Omron NX701-1620 User Manual

Terminology
25
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Terminology
Term
Description
Column
One of the information layers of each DB. Refers to the columns of each table.
DB
Refers to a database in a server.
DB Connection
Refers to a virtual communication path established between CPU Unit and DB.
DB Connection function
Used to connect a CPU Unit to a DB. This function operates on a CPU Unit.
DB Connection Instruction
Refers to special instructions for the DB Connection Service.
DB Connection Service This service provides the DB Connection function to connect a CPU Unit to a DB.
In the ID information indication on the side of the CPU Unit and in Sysmac Studio, this service is
indicated as “DBCon”.
DB Connection Service shutdown
function
Used to shut down the DB Connection Service after automatically saving the Operation Log files
into the SD Memory Card.
DB mapping Means to assign each member of a DB Map Variable to the corresponding column of a table in
the connected DB.
DB Map Variable
Refers to a variable that uses a structure data type for DB access as its data type.
Debug Log One of the Operation Logs. This log is used for recording which SQL statements are executed,
and parameters and execution result of each SQL statements.
EM Area Refers to EM Area of the memory for CJ-series Units. The data in this area are retained even if
the power supply to the CPU Unit is cycled (i.e. ON → OFF → ON) or the operating mode of the
CPU Unit is changed (i.e. PROGRAM mode ⇔ RUN mode).
Execution Log One of the Operation Logs. This log is used to record the executions of the DB Connection
Service.
Operation Log Used to trace the operations of the DB Connection function on the CPU Unit. There are three
types of Operation Logs; Execution Log, Debug Log, and SQL Execution Failure Log.
Run mode of the DB Connection
Service
Used to switch whether to actually access the DB or to normally end the instructions without
accessing the DB when DB Connection Instructions are executed.
Spool memory
Refers to the memory area for storing the SQL statements in the Spool function.
Spool function Used to store some SQL statements for inserting records into the DB or updating the records in
the DB that could not be executed due to a network failure.
Spool data
Refers to the SQL statements stored in the Spool memory.
Structure data type for DB access Refers to structure data type where all or some of the columns of a specified table are registered
as structure members.
SQL Stands for Structured Query Language, which is one of the languages for DB processing such
as data read/write.
SQL Execution Failure Log One of the Operation Logs. This log is used to record execution failure of SQL statements in the
DB.
SQL statement Refers to the statements that show a specific instruction used for DB operations such as data
read/write.
Table
One of the information layers of each DB, which contains data.

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English