Omron NX701-1620 User Manual

1 Introduction to the DB Connection Service
1-4
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
1-2 DB Connection Service
Specifications and System
This section describes the specifications and system of the DB Connection Service.
1-2-1 DB Connection Service Specifications
This section describes the specifications of the DB Connection Service. Refer to B-3
Specifications for the general specifications, performance specifications, and function
specifications of the Database Connection CPU Units.
Refer to B-4 Version Information for the information on version upgrades of the DB Connection
Service.
Item
Description
CPU Unit model Special models
*1
. The other functions are same as the
NX-series NX701-@@20 CPU Unit, NJ-series NJ501-@@00
CPU Unit, or NJ101-@@00 CPU Unit.
 NX701-1720: 256-axis type
 NX701-1620: 128-axis type
 NJ501-1520: 64-axis type
 NJ501-1420: 32-axis type
 NJ501-1320: 16-axis type
 NJ501-4320: 16-axis type
 NJ101-1020: 2-axis type
 NJ101-9020: No-axis type
Supported DB
*2
For the supported DB, refer to Supported DB and
Corresponding Versions below.
Number of DB Connections (Number of databases
that can be connected at the same time)
 NX701-@@20: 3 connections max.
*3
 NJ501-@@20: 3 connections max.
*3
 NJ101-@@20: 1 connection max.
Instruction Supported operations The following operations can be performed by executing DB
Connection Instructions in the NJ/NX-series CPU Units.
Inserting records (INSERT), Updating records (UPDATE),
Retrieving records (SELECT), and Deleting records (DELETE)
Number of columns in an INSERT
operation
SQL Server: 1,024 columns max
Oracle Database: 1,000 columns max.
DB2: 1,000 columns max.
MySQL: 1,000 columns max.
Firebird: 1,000 columns max.
PostgreSQL: 1,000 columns max.
Number of columns in an UPDATE
operation
SQL Server: 1,024 columns max.
Oracle Database: 1,000 columns max.
DB2: 1,000 columns max.
MySQL: 1,000 columns max.
Firebird: 1,000 columns max.
PostgreSQL: 1,000 columns max.
Number of columns in a SELECT
operation
SQL Server: 1,024 columns max.
Oracle Database: 1,000 columns max.
DB2: 1,000 columns max.
MySQL: 1,000 columns max.
Firebird: 1,000 columns max.
PostgreSQL: 1,000 columns max.
Number of records in the output of a
SELECT operation
65,535 elements max., 4 MB max.

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English