Omron NX701-1620 User Manual

1 Introduction to the DB Connection Service
1-5
1
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
1-2-1 DB Connection Service Specifications
1-2 DB Connection Service
Specifications and System
Item
Description
Instruction
Number of DB Map Variables for
which a mapping can be created
 NX701-@@20/NJ501-1@20
SQL Server: 60 variables max.
Oracle Database: 30 variables max.
DB2: 30 variables max.
MySQL: 30 variables max.
Firebird: 15 variables max.
PostgreSQL: 30 variables max.
Even if the number of DB Map Variables has not reached the
upper limit, the total number of members of structures used as
data type of DB Map Variables is 10,000 members max.
 NJ501-4320
SQL Server: 15 variables max.
Oracle Database: 15 variables max.
MySQL: 15 variables max.
Even if the number of DB Map Variables has not reached the
upper limit, the total number of members of structures used as
data type of DB Map Variables is 10,000 members max.
 NJ101-@@20
SQL Server: 15 variables max.
Oracle Database: 15 variables max.
DB2: 15 variables max.
MySQL: 15 variables max.
Firebird: 15 variables max.
PostgreSQL: 15 variables max.
Even if the number of DB Map Variables has not reached the
upper limit, the total number of members of structures used as
data type of DB Map Variables is 10,000 members max.
Run mode of the DB Connection Service Operation Mode or Test Mode
 Operation Mode:
When each instruction is executed, the service actually
accesses the DB.
 Test Mode:
When each instruction is executed, the service ends the
instruction normally without accessing the DB actually.
Spool function Used to store SQL statements when an error occurred and
resend the statements when the communications are
recovered from the error.
*4
NX701-@@20: 2 MB
NJ501-@@20: 1 MB
NJ101-@@20: 192 KB
Operation Log function The following three types of logs can be recorded.
 Execution Log: Log for tracing the executions of the DB
Connection Service.
 Debug Log: Detailed log for SQL statement executions of the
DB Connection Service.
 SQL Execution Failure Log: Log for execution failures of SQL
statements in the DB.
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.
*1 The CIP (Common Industrial Protocol) communications using the built-in EtherNet/IP port
support the same functions as with the following CPU models. Therefore, when executing
the EtherNet/IP tag data link function, please specify the following CPU models on Network
Configurator. The following models are also displayed in Sysmac Gateway or CX-Compolet.
• NX701-1700 for NX701-1720
• NX701-1600 for NX701-1620
• NJ501-1500 for NJ501-1520
• NJ501-1400 for NJ501-1420

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English