Page top

NX701-1[]20

NX-Series NX701 Database Connection CPU Units

NX701-1[]20

The Controller can be directly connected to a database. No special Unit, software, nor middleware is required.

General Specification

Item NX701-[][][][]
Enclosure Mounted in a panel
Grounding Method Ground to less than 100 Ω
Dimensions
(height × depth × width)
100 mm × 100 mm × 132 mm
Weight 880 g (including the End Cover)
Power consumption 40 W (including SD Memory Card and End Cover)
Operation
Environment
Ambient Operating
Temperature
0 to 55°C
Ambient Operating
Humidity
10% to 95% (with no condensation)
Atmosphere Must be free from corrosive gases.
Ambient Storage
Temperature
-25 to 70°C (excluding battery and fan unit)
Altitude 2,000 m or less
Pollution Degree 2 or less: Meets IEC 61010-2-201.
Noise Immunity 2 kV on power supply line (Conforms to IEC 61000-4-4.)
Overvoltage Category Category II: Meets IEC 61010-2-201.
EMC Immunity Level Zone B
Vibration Resistance Conforms to IEC 60068-2-6.
5 to 8.4 Hz with 3.5-mm amplitude, 8.4 to 150 Hz
Acceleration of 9.8 m/s2 for 100 min in X, Y, and Z directions (10 sweeps of
10 min each = 100 min total)
Shock Resistance Conforms to IEC 60068-2-27.
147 m/s2, 3 times in X, Y, and Z directions (100 m/s2 for Relay Output Units)
Battery Life 2.5 years (at 25°C, Power ON time rate 0% (power OFF))
Model CJ1W-BAT01
Applicable Standards Conforms to cULus, NK *, LR *, EU Directives, RCM and KC Registration.

* Supported only by the CPU Units manufactured in December 2016 or later. Not supported by the NX701-1[]20.

Performance Specifications

Item NX701
17[]0 16[]0
Processing
time
Instruction
Execution
Times
LD instruction 0.37 ns or more
Math Instructions
(for Long Real Data)
3.2 ns or more
Program-
ming
Program
capacity
*1
Size 80 MB (1600 KS)
Number POU definition 6,000
POU instance 48,000
Variables
capacity
No Retain
Attribute *2
Size 256 MB
Number 360,000
Retain
Attribute *3
Size 4 MB
Number 40,000
Data type Number 8,000
Memory for
CJ-Series
Units (Can
be Specified
with AT
Specifications
for
Variables.)
CIO Area NX701-1[]00: ---
NX701-1[]20: 6144 words (CIO 0 to CIO 6143) *4
Work Area NX701-1[]00: ---
NX701-1[]20: 512 words (W0 to W511) *4
Holding Area NX701-1[]00: ---
NX701-1[]20: 1536 words (H0 to H1535) *5
DM Area NX701-1[]00: ---
NX701-1[]20: 32768 words (D0 to D32767) *5
EM Area NX701-1[]00: ---
NX701-1[]20: 32768 words × 25 banks (E0_00000 to E18_32767) *6
Unit
config-
uration
Maximum
Number of
Connectable
Units
Maximum number of NX
unit on the system
4,096
(on NX series EtherCAT slave terminal)
Maximum number of Expansion Racks 0
Power Supply
Unit for CPU
Rack and
Expansion
Racks
Model NX-PA9001
NX-PD7001
Power OFF
Detection
Time
AC Power
Supply
30 to 45 ms
DC Power
Supply
5 to 20ms
Motion
control
Number of
Controlled
Axes
Maximum Number of
Controlled Axes
Maximum number of axes which can be defined.
256 axes 128 axes
Motion
control axes
Maximum number of motion control axes which can be defined.
All motion control function is available.
256 axes 128 axes
Maximum number of
used real axes
Maximum number of used real axes.
The Number of used real axes includes following servo axes and encoder axes.
256 axes 128 axes
Used motion
control servo
axes
Maximum number of servo axes which all motion control function is available.
256 axes 128 axes
Maximum number of axes
for linear interpolation
axis control
4 axes per axes group
Number of axes for circular
interpolation axis control
2 axes per axes group
Maximum Number of Axes Groups 64 groups
Motion Control Period The same control period as that is used for the process data communications cycle for EtherCAT.
Cams Number of
Cam Data
Points
Maximum
Points per
Cam Table
65,535 points
Maximum
Points for All
Cam Tables
1,048,560 points
Maximum Number of Cam
Tables
640 tables
Position Units Pulses, millimeters, micrometers, nanometers, degrees or inches
Override Factors 0.00% or 0.01% to 500.00%
Peripheral
USB port
Supported Services Sysmac Studio connection
Physical Layer USB 2.0-compliant B-type connector
Transmission Distance between Hub and
Node
5 m max.
Built-in
EtherNet/IP
Port
Number of port 2
Physical Layer 10BASE-T/ 100BASE-TX/1000BASE-T
Frame length 1514 max.
Media Access Method CSMA/CD
Modulation Baseband
Topology Star
Baud Rate 1Gbps (1000BASE-T)
Transmission Media STP (shielded, twisted-pair) cable of Ethernet category 5, 5e or higher
Maximum Transmission Distance between
Ethernet Switch and Node
100m
Maximum Number of Cascade Connections There are no restrictions if Ethernet switch is used.
CIP service:
Tag Data
Links
(Cyclic
Communi-
cations)
Maximum Number of
Connections
256/port total 512
Packet interval *7 0.5 to 10,000 ms in 0.5-ms increments
Can be set for each connection.
Permissible
Communications Band
40,000 pps *8
including heartbeat
Maximum Number of Tag
Sets
256/port total 512
Tag types Network variables
Number of tags per
connection
(i.e., per tag set)
8 (7 tags if Controller status is included in the tag set.)
Maximum Link Data Size
per Node (total size for all
tags)
256/port total 512
Maximum number of tag 369,664 byte (Total in 2 ports 739,328 byte)
Maximum Data Size per
Connection
1,444 byte
Maximum Number of
Registrable Tag Sets
256/port total 512 (1 connection = 1 tag set)
Maximum Tag Set Size 1,444 bytes
(Two bytes are used if Controller status is included in the tag set.)
Multi-cast Packet Filter *9 Supported.
Cip Message
Service:
Explicit
Messages
Class 3 (number of
connections)
128/port total 256 (clients plus server)
UCMM
(non-
connection
type)
Maximum
Number of
Clients that
Can
Communicate
at One Time
32/port total 64
Maximum
Number of
Servers that
Can
Communicate
at One Time
32/port total 64
Maximum number of TCP socket service 30
Built-in
EtherCAT
Port
Communications Standard IEC 61158 Type12
EtherCAT Master Specifications Class B (Feature Pack Motion Control compliant)
Physical Layer 100BASE-TX
Modulation Baseband
Baud Rate 100 Mbps (100Base-TX)
Duplex mode Auto
Topology Line, daisy chain, and branching
Transmission Media Twisted-pair cable of category 5 or higher (double-shielded straight cable with aluminum tape and braiding)
Maximum Transmission Distance between
Nodes
100m
Maximum Number of Slaves 512
Range of node address 1-512
Maximum Process Data Size Inputs: 11,472 bytes
Outputs: 11,472 bytes *10
Maximum Process Data Size per Slave Inputs: 1,434 bytes
Outputs: 1,434 bytes
Communications Cycle • Primary periodic task: 125 μs, 250 μs to 8 ms (in 250-μs increments)
• Priority-5 periodic task: 125 μs, 250 μs to 100 ms (in 250-μs increments)
Sync Jitter 1 μs max.
Internal Clock At ambient temperature of 55°C: -3.5 to +0.5 min error per month
At ambient temperature of 25°C: -1.5 to +1.5 min error per month
At ambient temperature of 0°C: -3 to +1 min error per month

*1. This is the capacity for the execution objects and variable tables (including variable names).
*2. Words for CJ-series Units in the Holding, DM, and EM Areas are not included. For NX701-1[]20, Words for CJ-series Units are included.
*3. Words for CJ-series Units in the CIO and Work Areas are not included. For NX701-1[]20, Words for CJ-series Units are included.
*4. You can set the size in 1ch unit. Use Non-Retain attribute memory.
*5. You can set the size in 1ch unit. Use Retain attribute memory.
*6. NX701-1[]20 use the dedicated area for the spool function. Even if the spool function is valid, Retain attribute memory is not used.
*7. Data is updated on the line in the specified interval regardless of the number of nodes.
*8. Means packets per second, i.e., the number of communications packets that can be sent or received in one second.
*9. An IGMP client is mounted for the EtherNet/IP port. If an ethernet switch that supports IGMP snooping is used, filtering of unnecessary multicast packets is performed.
*10.The data must be within eight frames.

Function Specifications

Item NX701-[][][][]
Tasks Function I/O refreshing and the user program are executed
in units that are called tasks.
Tasks are used to specify execution conditions and
execution priority.
Periodically
Executed
Tasks
Maximum Number
of Primary Periodic
Tasks
1
Maximum Number
of Periodic Tasks
4
Conditionally
executed
tasks
Maximum number
of event tasks
32
Execution
conditions
When Activate Event Task instruction is executed
or when condition expression for variable is met.
Program-
ming
POU
(program
organization
units)
Programs POUs that are assigned to tasks.
Function Blocks POUs that are used to create objects with specific
conditions.
Functions POUs that are used to create an object that
determine unique outputs for the inputs, such as
for data processing.
Programming
Languages
Types Ladder diagrams *1 and structured text (ST)
Namespaces A concept that is used to group identifiers for POU
definitions.
Variables External
Access of
Variables
Network Variables The function which allows access from the HMI,
host computers, or other Controllers
Data Types Data Types Boolean BOOL
Bit Strings BYTE, WORD, DWORD, LWORD
Integers INT, SINT, DINT,LINT, UINT, USINT, UDINT, ULINT
Real Numbers REAL, LREAL
Durations TIME
Dates DATE
Times of Day TIME_OF_DAY
Date and Time DATE_AND_TIME
Text Strings STRING
Derivative Data Types Structures, unions, enumerations
Structures Function A derivative data type that groups together data
with different variable types.
Maximum Number
of Members
2048
Nesting Maximum
Levels
8
Member Data Types Basic data types, structures, unions, enumerations,
array variables
Specifying Member
Offsets
You can use member offsets to place structure
members at any memory locations.
Unions Function A derivative data type that groups together data
with different variable types.
Maximum Number
of Members
4
Member Data Types BOOL, BYTE, WORD, DWORD, LWORD
Enumer-
ations
Function A derivative data type that uses text strings called
enumerators to express variable values.
Data Type
Attributes
Array
specifi-
cations
Function An array is a group of elements with the same data
type. You specify the number (subscript) of the
element from the first element to specify the
element.
Maximum Number
of Dimensions
3
Maximum Number
of Elements
65535
Array
Specifications for
FB Instances
Supported.
Range Specifications You can specify a range for a data type in advance.
The data type can take only values that are in the
specified range.
Libraries User libraries
Motion
Control
Control Modes position control, velocity control, torque control
Axis Types Servo axes, virtual servo axes, encoder axes, and
virtual encoder axes
Positions that can be managed Command positions and actual positions
Single-axis Single-axis
Position
Control
Absolute
Positioning
Positioning is performed for a target position that
is specified with an absolute value.
Relative
Positioning
Positioning is performed for a specified travel
distance from the command current position.
Interrupt Feeding Positioning is performed for a specified travel
distance from the position where an interrupt input
was received from an external input.
Cyclic synchronous
absolute
positioning
The function which outputs command positions in
every control period in the position control mode.
Single-axis
Velocity
Control
Velocity Control Velocity control is performed in Position Control
Mode.
Cyclic Synchronous
Velocity Control
A velocity command is output each control period
in Velocity Control Mode.
Single-axis
Torque
Control
Torque Control The torque of the motor is controlled.
Single-axis
Synchro-
nized
Control
Starting Cam
Operation
A cam motion is performed using the specified cam
table.
Ending Cam
Operation
The cam motion for the axis that is specified with
the input parameter is ended.
Starting Gear
Operation
A gear motion with the specified gear ratio is
performed between a master axis and slave axis.
Positioning Gear
Operation
A gear motion with the specified gear ratio and
sync position is performed between a master axis
and slave axis.
Ending Gear
Operation
The specified gear motion or positioning gear
motion is ended.
Synchronous
Positioning
Positioning is performed in sync with a specified
master axis.
Master Axis Phase
Shift
The phase of a master axis in synchronized control
is shifted.
Combining Axes The command positions of two axes are added or
subtracted and the result is output as the
command position.
Single-axis
Manual
Operation
Powering the Servo The Servo in the Servo Drive is turned ON to
enable axis motion.
Jogging An axis is jogged at a specified target velocity.
Auxiliary
Functions
for
Single-axis
Control
Resetting Axis
Errors
Axes errors are cleared.
Homing A motor is operated and the limit signals, home
proximity signal, and home signal are used to
define home.
Homing with
parameter
Specifying the parameter, a motor is operated and
the limit signals, home proximity signal, and home
signal are used to define home.
High-speed Homing Positioning is performed for an absolute target
position of 0 to return to home.
Stopping An axis is decelerated to a stop at the specified rate.
Immediately
Stopping
An axis is stopped immediately.
Setting Override
Factors
The target velocity of an axis can be changed.
Changing the
Current Position
The command current position or actual current
position of an axis can be changed to any position.
Enabling External
Latches
The position of an axis is recorded when a trigger
occurs.
Disabling External
Latches
The current latch is disabled.
Zone Monitoring You can monitor the command position or actual
position of an axis to see when it is within a
specified range (zone).
Enabling digital
cam switches
You can turn a digital output ON and OFF
according to the position of an axis.
Monitoring Axis
Following Error
You can monitor whether the difference between
the command positions or actual positions of two
specified axes exceeds a threshold value.
Resetting the
Following Error
The error between the command current position
and actual current position is set to 0.
Torque Limit The torque control function of the Servo Drive
can be enabled or disabled and the torque limits
can be set to control the output torque.
Command position
compensation
The function which compensate the position for
the axis in operation.
Cam monitor Outputs the specified offset position for the slave
axis in synchronous control.
Start velocity You can set the initial velocity when axis motion
starts.
Axes Groups Multi-axes
Coordinated
Control
Absolute Linear
Interpolation
Linear interpolation is performed to a specified
absolute position.
Relative Linear
Interpolation
Linear interpolation is performed to a specified
relative position.
Circular 2D
Interpolation
Circular interpolation is performed for two axes.
Axes Group Cyclic
Synchronous
Absolute
Positioning
A positioning command is output each control
period in Position Control Mode.
Auxiliary
Functions
for
Multi-axes
Coordinated
Control
Resetting Axes
Group Errors
Axes group errors and axis errors are cleared.
Enabling Axes
Groups
Motion of an axes group is enabled.
Disabling Axes
Groups
Motion of an axes group is disabled.
Stopping Axes
Groups
All axes in interpolated motion are decelerated to
a stop.
Immediately
Stopping Axes
Groups
All axes in interpolated motion are stopped
immediately.
Setting Axes Group
Override Factors
The blended target velocity is changed during
interpolated motion.
Reading Axes
Group Positions
The command current positions and actual current
positions of an axes group can be read.
Changing the Axes
in an Axes Group
The Composition Axes parameter in the axes group
parameters can be overwritten temporarily.
Common
Items
Cams Setting Cam Table
Properties
The end point index of the cam table that is
specified in the input parameter is changed.
Saving Cam ables The cam table that is specified with the input
parameter is saved in non-volatile memory in the
CPU Unit.
Generating cam
tables
The cam table that is specified with the input
parameter is generated from the cam property and
cam node.
Parameters Writing MC Settings Some of the axis parameters or axes group
parameters are overwritten temporarily.
Changing axis
parameters
You can access and change the axis parameters
from the user program.
Auxiliary
Functions
Count Modes You can select either Linear Mode (finite length)
or Rotary Mode (infinite length).
Unit Conversions You can set the display unit for each axis
according to the machine.
Acceler-
ation/
Deceleration
Control
Automatic
Acceleration/
Deceleration
Control
Jerk is set for the acceleration/deceleration
curve for an axis motion or axes group motion.
Changing the
Acceleration and
Deceleration Rates
You can change the acceleration or deceleration
rate even during acceleration or deceleration.
In-position Check You can set an in-position range and in-position
check time to confirm when positioning is
completed.
Stop Method You can set the stop method to the immediate
stop input signal or limit input signal.
Re-execution of Motion Control
Instructions
You can change the input variables for a motion
control instruction during execution and execute
the instruction again to change the target values
during operation.
Multi-execution of Motion Control
Instructions (Buffer Mode)
You can specify when to start execution and how
to connect the velocities between operations when
another motion control instruction is executed
during operation.
Continuous Axes Group Motions
(Transition Mode)
You can specify the Transition Mode for multi-
execution of instructions for axes group operation.
Monitoring
Functions
Software Limits Software limits are set for each axis.
Following Error The error between the command current value and
the actual current value is monitored for an axis.
Velocity,
Acceleration Rate,
Deceleration Rate,
Torque,
Interpolation
Velocity,
Interpolation
Acceleration Rate,
And Interpolation
Deceleration Rate
You can set and monitor warning values for each
axis and each axes group.
Absolute Encoder Support You can use an OMRON G5-Series or 1S-Series
Servomotor with an Absolute Encoder to eliminate
the need to perform homing at startup.
Input signal logic inversion You can inverse the logic of immediate stop input
signal, positive limit input signal, negative limit input
signal, or home proximity input signal.
External Interface Signals The Servo Drive input signals listed on the right
are used. Home signal, home proximity signal,
positive limit signal, negative limit signal, immediate
stop signal, and interrupt input signal
Unit
(I/O)
Manage-
ment
EtherCAT
Slaves
Maximum Number of Slaves 512
CJ-Series
Units
Basic I/O
Units
Load Short-circuit
Protection and I/O
Disconnection
Detection
Alarm information for Basic I/O Units is read.
Communi-
cations
Peripheral USB Port A port for communications with various kinds of
Support Software running on a personal computer.
Built-in Ether-
Net/IP port
Internal Port
Communications protocol TCP/IP, UDP/IP
CIP
Communica-
tions Service
Tag Data Links Programless cyclic data exchange is performed
with the devices on the EtherNet/IP network.
Message
Communications
CIP commands are sent to or received from the
devices on the EtherNet/IP network.
TCP/IP
functions
CIDR The function which performs IP address allocations
without using a class (class A to C) of IP address.
IP Forwarding The function which forward IP packets between
interfaces.
TCP/IP
Applications
Socket Services Data is sent to and received from any node on
Ethernet using the UDP or TCP protocol. Socket
communications instructions are used.
FTP client File can be read from or written to computers at
other Ethernet nodes from the CPU Unit. FTP
client communications instructions are used.
FTP Server Files can be read from or written to the SD
Memory Card in the CPU Unit from computers at
other Ethernet nodes.
Automatic Clock
Adjustment
Clock information is read from the NTP server at
the specified time or at a specified interval after
the power supply to the CPU Unit is turned ON.
The internal clock time in the CPU Unit is updated
with the read time.
SNMP Agent Built-in EtherNet/IP port internal status
information is provided to network management
software that uses an SNMP manager.
EtherCAT
Port
Supported
Services
Process Data
Communications
Control information is exchanged in cyclic
communications between the EtherCAT master
and slaves.
SDO
Communications
A communications method to exchange control
information in noncyclic event communications
between EtherCAT master and slaves.
This communications method is defined by CoE.
Network Scanning Information is read from connected slave devices
and the slave configuration is automatically
generated.
DC (Distributed Clock) Time is synchronized by sharing the EtherCAT
system time among all EtherCAT devices (including
the master).
Packet Monitoring The frames that are sent by the master and the
frames that are received by the master can be
saved.
The data that is saved can be viewed with
WireShark or other applications.
Enable/disable Settings for Slaves The slaves can be enabled or disabled as
communications targets.
Disconnecting/Connecting Slaves Temporarily disconnects a slave from the EtherCAT
network for maintenance, such as for replacement
of the slave, and then connects the slave again.
Supported
Application
Protocol
CoE SDO messages of the CAN application
can be sent to slaves via EtherCAT.
Communications Instructions The following instructions are supported.
CIP communications instructions, socket
communications instructions, SDO message
instructions, no-protocol communications
instructions *2, FTP client instructions, and
Modbus RTU protcol instructions *2
Operation
Manage-
ment
RUN Output Contacts The output on the Power Supply Unit turns ON in
RUN mode.
System
Manage-
ment
Event Logs Function Events are recorded in the logs.
Maximum
number of
events
System event log 2,048
Access event log 1,024
User-defined event log 1,024
Debugging Online
Editing
Single Programs, function blocks, functions, and global
variables can be changed online.
Different operators can change different POUs
across a network.
Forced Refreshing The user can force specific variables to TRUE or
FALSE.
Maximum
Number of
Forced
Variables
Device Variables
for EtherCAT
Slaves
64
MC Test Run Motor operation and wiring can be checked from
the Sysmac Studio.
Synchronizing The project file in the Sysmac Studio and the data
in the CPU Unit can be made the same when
online.
Differentiation monitoring Rising/falling edge of contacts can be monitored.
Maximum number of contacts 8
Data Tracing Types Single Triggered
Trace
When the trigger condition is met, the specified
number of samples are taken and then tracing
stops automatically.
Continuous Trace Data tracing is executed continuously and the
trace data is collected by the Sysmac Studio.
Maximum Number of Simultaneous
Data Trace
4
Maximum Number of Records 10,000
Sampling Maximum Number
of Sampled
Variables
192 variables
Timing of Sampling Sampling is performed for the specified task period,
at the specified time, or when a sampling
instruction is executed.
Triggered Traces Trigger conditions are set to record data before
and after an event.
Trigger Conditions When BOOL variable changes to TRUE or FALSE
Comparison of non-BOOL variable with a constant
Comparison Method: Equals (=), Greater than (>),
Greater than or equals (≥), Less Than (<), Less
than or equals (≤), Not equal (≠)
Delay Trigger position setting: A slider is used to set the
percentage of sampling before and after the trigger
condition is met.
Simulation The operation of the CPU Unit is emulated in the
Sysmac Studio.
Reliability
Functions
Self-
diagnosis
Controller
Errors
Levels Major fault, partial fault, minor fault, observation,
and information
User-defined errors User-defined errors are registered in advance and
then records are created by executing instructions.
Levels 8 levels
Security Protecting
Software
Assets and
Preventing
Operating
Mistakes
CPU Unit Names and Serial IDs When going online to a CPU Unit from the Sysmac
Studio, the CPU Unit name in the project is
compared to the name of the CPU Unit being
connected to.
Protection User Program
Transfer with No
Restoration
Information
You can prevent reading data in the CPU Unit from
the Sysmac Studio.
CPU Unit Write
Protection
You can prevent writing data to the CPU Unit from
the Sysmac Studio or SD Memory Card.
Overall Project
File Protection
You can use passwords to protect .smc files from
unauthorized opening on the Sysmac Studio.
Data Protection You can use passwords to protect POUs on the
Sysmac Studio.
Verification of Operation
Authority
Online operations can be restricted by operation
rights to prevent damage to equipment or injuries
that may be caused by operating mistakes.
Number of Groups 5
Verification of User Program
ExecutionID
The user program cannot be executed without
entering a user program execution ID from the
Sysmac Studio for the specific hardware (CPU
Unit).
SD
Memory
Card
Functions
Storage Type SD Memory Card, SDHC Memory Card
Application Automatic transfer from
SD Memory Card
The data in the autoload folder on an SD Memory
Card is automatically loaded when the power
supply to the Controller is turned ON.
Transfer program from
SD Memory Card *2
The user program on an SD Memory Card is
loaded when the user changes system-defined
variable to TRUE.
SD Memory Card Operation
Instructions
You can access SD Memory Cards from
instructions in the user program.
File Operations from the Sysmac
Studio
You can perform file operations for Controller files
in the SD Memory Card and read/write standard
document files on the computer.
SD Memory Card Life Expiration
Detection
Notification of the expiration of the life of the SD
Memory Card is provided in a systemdefined
variable and event log.
Backup
functions
SD Memory
Card backup
functions
Operation Using front switch You can use front switch to backup, compare, or
restore data.
Using system-
defined variables
You can use system-defined variables to backup,
compare, or restore data. *3
Memory Card
Operations Dialog
Box on Sysmac
Studio
Backup and verification operations can be
performed from the SD Memory Card Operations
Dialog Box on the Sysmac Studio.
Using instruction Backup operation can be performed by using
instruction.
Protection Prohibiting backing
up data to the SD
Memory Card
Prohibit SD Memory Card backup functions.
Sysmac Studio Controller backup functions Backup, restore, and verification operations for
Units can be performed from the Sysmac Studio.

*1. Inline ST is supported. (Inline ST is ST that is written as an element in a ladder diagram.)
*2. Supported only by the CPU Units with unit version 1.11 or later.
*3. Restore is supported with unit version 1.14 or later.

Function Specifications of Database Connection CPU Units

Besides functions of the NX701-[][][][], functions supported by the NX701-1[]20 is as follows.

Item Description
NX701-1[]20
Supported port Built-in EtherNet/IP port
Supported DB *1*2 Microsoft Corporation: SQL Server 2012/2014/2016/2017
Oracle Corporation:
Oracle Database 11g /12c/18c
MySQL Community Edition 5.6/5.7/8.0 *3
International Business Machines Corporation (IBM):
DB2 for Linux, UNIX and Windows 9.7/10.1/10.5/11.1
Firebird Foundation Incorporated: Firebird 2.5
The PostgreSQL Global Development Group: PostgreSQL 9.4/9.5/9.6/10
Number of DB Connections
(Number of databases that
can be connected at the same time)
3 connections max. *4
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), Deleting records (DELETE), Execute Stored
Procedure *5, and Execute Batch Insert *5
Max. number of instructions
for simultaneous execution
32
Max. number of columns in an
INSERT operation
SQL Server: 1,024
Oracle: 1,000
DB2: 1,000
MySQL: 1,000
Firebird: 1,000
PostgreSQL: 1,000
Max. number of columns in an
UPDATE operation
SQL Server: 1,024
Oracle: 1,000
DB2: 1,000
MySQL: 1,000
Firebird: 1,000
PostgreSQL: 1,000
Max. number of columns in a
SELECT operation
SQL Server: 1,024
Oracle: 1,000
DB2: 1,000
MySQL: 1,000
Firebird: 1,000
PostgreSQL: 1,000
Max. number of records in the
output of a SELECT operation
65,535 elements, 4 MB
Stored
procedure
call *5
Supported
databases
• SQL Server
• Oracle Database
• MySQL Community Edition
• PostgreSQL
Argument
(Sum of IN, OUT
and INOUT)
Up to 256 variables *6
Return value One variable
Result set Supported
Spool function Not supported
Batch insert
execution *5
Supported
databases
• SQL Server
• Oracle Database
• MySQL Community Edition
• PostgreSQL
Supported data
size
Less than 1,000 columns and upper limit (8 MB) of structure variable
size or less *7
Spool function Not supported
Max. number of DB Map
Variables for which a mapping
can be connected
SQL Server: 60
Oracle: 30
DB2: 30
MySQL: 30
Firebird: 15
PostgreSQL: 30 *8
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.
Spool capacity 2 MB *9
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.
Encrypted
Communication
Supported
databases
• SQL Server
• Oracle Database
• MySQL Community Edition
• PostgreSQL
TLS Ver. TLS 1.2

*1. SQL Server 2014, Oracle Database 12c and PostgreSQL 9.4 are supported by the DB Connection Service Version 1.02
     or higher.
     SQL Server 2016, My SQL 5.7, DB2 11.1 and Postgre SQL 9.5/9.6 are supported by the DB Connection Service Version
     1.03 or higher.
     SQL Server 2017 is supported by the DB Connection Service Version 1.04 or higher.
     Oracle Database 18c, MySQL Community Edition 8.0 and PostgreSQL 10 are supported by the DB Connection Service
     Version 2.00 or higher.
     You cannot use Oracle 10g with the DB Connection Service version 2.00 or higher.
*2. Connection to the DB on the cloud is not supported.
*3. The supported storage engines of the DB are InnoDB and MyISAM.
*4. When two or more DB Connections are established, the operation cannot be guaranteed if you set different database
      types for the connections.
*5. The function is available for the DB Connection Service Version 2.00 or higher.
*6. Depends on members of a structure.
*7. Constrained by the memory capacity for variables. See the specifications for the memory capacity for variables.
*8. 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.
*9. Refer to "NJ/NX-series Database Connection CPU Units User's Manual (W527)" for the information.
Note: The extended support for databases has ended for the following DB versions.
         Please consider replacing the current database with a new version.

Item Discription
Microsoft Corporation: SQL Server 2008/2008R2
Oracle Corporation: Oracle Database 10g
Oracle Corporation: MySQL Community Edition 5.1/5.5
International Business Machines Corporation (IBM): DB2 for Linux, UNIX and Windows 9.5
Firebird Foundation Incorporated: Firebird 2.1
The PostgreSQL Global Development Group: PostgreSQL 9.2/9.3

Version Information

Unit Versions and Programming Devices (NX701 CPU Units)

Refer to "NX-series CPU Unit Hardware User's Manual (W535)"

Functions That Were Added or Changed for Each Unit Version and Sysmac Studio version

Refer to "NX-series CPU Unit Hardware User's Manual (W535)".