manualshive.com logo in svg

Omron NX1 Series, Руководство пользователя, Страница: 28 / 38

Поделиться
Скачать
Omron NX1 Series Скачать руководство пользователя страница 28

Machine Automation Controller

 NX1

28

Function Specifications of the Database Connection CPU Units

Besides functions of the NX102-

@@@@

, functions supported by the NX102-

@@

20 are as follows.

Item

Description

NX102-1220

NX102-1120

NX102-1020

NX102-9020

Supported port

Built-in EtherNet/IP port

Supported 
DB versions 
*

1

 *

2

SQL Server by Microsoft

2012/2014/2016/2017

Oracle Database by Oracle

11g/12c/18c

DB2 for Linux, UNIX and Windows by IBM

9.7/10.1/10.5/11.1

MySQL Community Edition by Oracle*

3

5.6/5.7/8.0

Firebird by Firebird Foundation

2.5

PostgreSQL by PostgreSQL Global 
Development Group

9.4/9.5/9.6/10

Number of DB Connections (Number of databases that 
can be connected at the same time)

2*

4

 *

5

Instruction

Supported operations

The following operations can be performed by executing DB Connection Instructions in the CPU Units:
Inserting records (INSERT), Updating records (UPDATE), Retrieving records (SELECT), Deleting re-
cords (DELETE), Execute Stored Procedure*

6

, and Execute Batch Insert*

6

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 *

6

Supported databases

• SQL Server
• Oracle Database
• MySQL Community Edition
• PostgreSQL

Argument
(Sum of IN, OUT and 
INOUT)

Up to 256 variables*

7

Return value

One variable

Result set

Supported

Spool function

Not supported

Batch insert 
execution *

6

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*

8

Spool function

Not supported

Max. number of DB Map Variables for 
which a mapping can be connected*

9

SQL Server: 30*

10

Oracle: 20*

10

DB2: 20*

10

MySQL: 20*

10

Firebird: 15
PostgreSQL: 20*

10

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 commu-
nications are recovered from the error

Spool capacity*

11

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

Encrypted 
Communica
tion

Supported databases

• SQL Server
• Oracle Database
• MySQL Community Edition
• PostgreSQL

TLS Ver.

TLS 1.2

Содержание NX1 Series

Страница 1: ...ustrial Ethernet ports OPC UA server functionality Up to 12 axes of control via EtherCAT Up to 32 local NX I O Units DC power supply without battery backup Fully conforms to IEC 61131 3 standard progr...

Страница 2: ...t Software EtherCAT CPU Rack NX Units EtherCAT Network configuration Built in EtherNet IP port 1 Built in EtherNet IP port 2 Built in EtherCAT port NX Unit configuration NX series NX102 CPU Unit Note...

Страница 3: ...e I O refreshing method ON OFF response time DC Input Unit Screwless Clamping Terminal Block 12 mm Width 4 points NPN 12 to 24 VDC Switching Synchronous I O refreshing and Free Run refreshing 20 s max...

Страница 4: ...nt 8 A Unit 0 5 ms max 1 0 ms max NX OD3268 8 NPN 0 5 A point 4 A Unit 12 to 24 VDC 0 1 ms max 0 8 ms max NX OD4121 PNP 24 VDC 0 5 ms max 1 0 ms max NX OD4256 16 NPN 12 to 24 VDC 0 1 ms max 0 8 ms max...

Страница 5: ...g and Free Run refreshing Outputs 0 1 ms max 0 8 ms max Inputs 20 s max 400 s max NX MD6121 5 Outputs PNP Inputs For both NPN PNP Outputs 24 VDC Inputs 24 VDC Outputs 0 5 ms max 1 0 ms max Inputs 20 s...

Страница 6: ...shing NX AD2208 4 1 8000 0 to 8000 0 2 full scale Singleended input 250 s point Free Run re freshing NX AD3203 Differential Input NX AD3204 1 30000 0 to 30000 0 1 full scale Differential Input 10 s po...

Страница 7: ...r current output 4 None Standard control NX TC3408 Product Name Specifications Model Number of points Input type Resolution 25 C Over all accuracy 25 C Conversion time I O refreshing method Terminals...

Страница 8: ...Product Name Specifications Model Number of channels External inputs Maximum response frequency I O refreshing method Number of I O entry mappings Incremental Encoder Input Unit 1 NPN 3 NPN 500 kHz Fr...

Страница 9: ...2 5 inputs CH NPN 3 outputs CH NPN 4 Mpps 2 2 Line driver out put NX PG0232 5 5 inputs CH PNP 3 outputs CH PNP NX PG0242 5 4 5 inputs CH NPN 3 outputs CH NPN 4 4 NX PG0332 5 5 inputs CH PNP 3 outputs...

Страница 10: ...rent 4 A NX PF0630 Power supply voltage 5 to 24 VDC 4 5 to 28 8 VDC I O power feed maximum current 10 A NX PF0730 I O Power Supply Connection Unit Number of I O power terminals IOG 16 terminals Curren...

Страница 11: ...points 2 points Sinking inputs PNP 24 VDC Cannot be connected 1 Free Run refreshing Ver 1 0 NX SID800 Appearance Specifications Model Number of safety output points Internal I O common Maximum load cu...

Страница 12: ...AD3604 No NX AD3608 No NX AD4603 Yes NX AD4604 No NX AD4608 No NX AD2203 Yes NX AD2204 No NX AD2208 No NX AD3203 Yes NX AD3204 No NX AD3208 No NX AD4203 Yes NX AD4204 No NX AD4208 No NX Units Model N...

Страница 13: ...X and 10BASE T Product Name Specification Number of licenses Media Model Sysmac Studio Standard Edition Ver 1 The Sysmac Studio is the software that provides an integrated environ ment for setting pro...

Страница 14: ...le sheath material LSZH 2 Cable color Yellow 3 OMRON 0 3 XS6W 6LSZH8SS30CM Y 0 5 XS6W 6LSZH8SS50CM Y 1 XS6W 6LSZH8SS100CM Y 2 XS6W 6LSZH8SS200CM Y 3 XS6W 6LSZH8SS300CM Y 5 XS6W 6LSZH8SS500CM Y Cable w...

Страница 15: ...r Model Cables Kuramo Electric Co KETH PSB OMR 1 JMACS Japan Co Ltd PNET B 1 RJ45 Assembly Connector OMRON XS6G T421 1 1 Product Name Specification Model Memory Cards SD memory card 2 GB The HMC SD291...

Страница 16: ...or the Unit power supply 6 When the type of the I O power supply to NX Units you use is the supply from NX bus an Additional I O Power Supply Unit is required Refer to NX series NX102 CPU Unit Hardwar...

Страница 17: ...max 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...

Страница 18: ...4 EM Area 32 768 words 25 banks E0_0 to E18_32 767 4 5 Motion control Number of controlled axes 6 Maximum number of controlled axes 15 axes 4 axes Motion control axes 11 axes Single axis position cont...

Страница 19: ...twork variables CIO WR HR DM Number of tags per connection i e per tag set 8 7 tags if Controller status is included in the tag set Maximum number of tags 256 per port 512 total Maximum link data size...

Страница 20: ...ctions on variables unable to open Variables whose size is over 1 024 bytes Two dimensional or higher structure arrays Structures that include two dimensional and higher arrays Structures with four or...

Страница 21: ...he data must be within four frames 14 You can check the I O allocation status with the Sysmac Studio Refer to the NJ NX series CPU Unit Software User s Manual Cat No W501 for how to check the I O allo...

Страница 22: ...imes 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 d...

Страница 23: ...ing A motor is operated and the limit signals home proximity signal and home signal are used to define home Homing with parameter The parameters are specified the motor is operated and the limit signa...

Страница 24: ...ition check time to confirm when posi tioning 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...

Страница 25: ...ations 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 au tomatically g...

Страница 26: ...ered in advance and then records are created by ex ecuting instructions Levels 8 Security Protecting software assets and preventing operating mistakes CPU Unit names and serial IDs When going online t...

Страница 27: ...h system defined variables You can perform backup verification and restoration operations by manipulating system defined variables SD Memory Card Window in Sysmac Studio Backup and verification operat...

Страница 28: ...35 elements 4 MB Stored procedure call 6 Supported databases SQL Server Oracle Database MySQL Community Edition PostgreSQL Argument Sum of IN OUT and INOUT Up to 256 variables 7 Return value One varia...

Страница 29: ...6 The function is available for the DB Connection Service Version 2 00 or higher 7 Depends on members of a structure 8 Constrained by the memory capacity for variables See the specifications for the...

Страница 30: ...okup guides These guides are used to mount an NX Unit or the End Cover H NX bus connector This connector is used to connect the NX Unit mounted on the right side I ID information indication Shows the...

Страница 31: ...er to protect the NX Unit and CPU Unit One End Cover is provided with the CPU Unit R DIN Track contact plate This plate is used to contact the functional ground terminal with a DIN Track Series Config...

Страница 32: ...built in capacitor in which no electric charge is accumulated When you use the clock data for programming use a battery if you cannot ensure the continuous power ON time shown above or the power OFF t...

Страница 33: ...DB Connection Service Versions and Sysmac Studio Versions Database Connection CPU Units Refer to NJ NX series Database Connection CPU Units User s Manual W527 1 1 Connection 1 N Connection A direct c...

Страница 34: ...from the terminal block lock lever to the back surface of the CPU Unit For dimensions after attaching the communications cables refer to NX series NX102 CPU Unit Hardware User s Manual W593 End cover...

Страница 35: ...User s Manual W507 NX701 NX102 NX1P2 NJ501 NJ301 NJ101 Learning about motion control settings and programming concepts The settings and operation of the CPU Unit and programming concepts for motion c...

Страница 36: ...DA W566 NX TS NX HB W523 NX PD1 NX PF0 NX PC0 NX TBX01 W524 NX EC0 NX ECS NX PG0 W540 NX CIF W565 NX RS W567 NX ILM NX series Safety Control Unit User s Manual Z930 NX SL NX SI NX SO Learning how to u...

Страница 37: ...CONNECTED WITH THE PRODUCTS WHETHER SUCH CLAIM IS BASED IN CONTRACT WARRANTY NEGLIGENCE OR STRICT LIABILITY Further in no event shall liability of Omron Companies exceed the individual price of the Pr...

Страница 38: ...7900 Fax 1 847 843 7787 Regional Headquarters OMRON EUROPE B V Wegalaan 67 69 2132 JD Hoofddorp The Netherlands Tel 31 2356 81 300 Fax 31 2356 81 388 Contact www ia omron com Kyoto JAPAN OMRON ASIA PA...

Отзывы:

Нет отзывов