Appendix B
B-24
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Number of DB Map Variables for which a Mapping can be Created
DB Connection
Service version of
DB Connection Service version set in the Sysmac Studio project
1.00 1.01 1.02
1.02 15 variables max. SQL Server: 60 variables max.
Oracle: 30 variables max.
DB2: 30 variables max.
MySQL: 30 variables max.
Firebird: 15 variables max.
SQL Server: 60 variables max.
Oracle: 30 variables max.
DB2: 30 variables max.
MySQL: 30 variables max.
Firebird: 15 variables max.
PostgreSQL: 30 variables max.
1.01 15 variables max. SQL Server: 60 variables max.
Oracle: 30 variables max.
DB2: 30 variables max.
MySQL: 30 variables max.
Firebird: 15 variables max.
The following table shows the differences in the specifications by the combination of actual DB
Connection Service version of CPU Unit and DB Connection Service version set in the Sysmac Studio
project when using an NJ101-20 CPU Unit.
Supported Database Type
DB Connection
Service version of
DB Connection Service version set in the Sysmac Studio project
1.01 1.02
1.02 Oracle
SQL Server
DB2
MySQL
Firebird
Oracle
SQL Server
DB2
MySQL
Firebird
1.01 Oracle
SQL Server
DB2
MySQL