background image

2-1-1 

Starting Sysmac Studio...............................................................................................................2-2

2-1-2 

Creating a New Project ...............................................................................................................2-2

2-1-3 

Setting the Built-in EtherNet/IP Port............................................................................................2-3

2-1-4 

Controller Setup ..........................................................................................................................2-3

2-2  DB Connection Settings........................................................................................................2-5

2-2-1 

DB Connection Service Settings .................................................................................................2-5

2-2-2 

DB Connection Settings ..............................................................................................................2-7

Section 3 

Programming the DB Connection Function

3-1  DB Access Procedure ...........................................................................................................3-2

3-2  Creating a Structure Data Type ............................................................................................3-3

3-2-1 

Overview .....................................................................................................................................3-3

3-2-2 

Specifications of Structure Data Type for DB Access .................................................................3-3

3-2-3 

How to Create a Structure Data Type for DB Access ...............................................................3-13

3-3  Creating a DB Map Variable ................................................................................................3-16

3-3-1 

DB Map Variables and DB Mapping..........................................................................................3-16

3-3-2 

Registration and Attributes of DB Map Variables ......................................................................3-17

3-3-3 

Restrictions on DB Map Variables.............................................................................................3-18

3-4  Specifying the Table and Applying the Mapping ..............................................................3-19

3-4-1 

DB Mapping by Executing a Create DB Map Instruction ..........................................................3-19

3-4-2 

Clearing the Mapping of DB Map Variables ..............................................................................3-19

3-4-3 

Restrictions on DB Mapping......................................................................................................3-19

3-5  Programming and Transfer .................................................................................................3-23

3-5-1 

Programming the DB Connection Service ................................................................................3-23

3-5-2 

Displaying DB Connection Instructions on Sysmac Studio .......................................................3-24

3-5-3 

DB Connection Instruction Set ..................................................................................................3-24

3-5-4 

System-defined Variables..........................................................................................................3-25

3-5-5 

Simulation Debugging of DB Connection Instructions ..............................................................3-26

3-5-6 

Transferring the DB Connection Settings and User Program ...................................................3-27

3-6  Debugging in Design, Startup, and Operation Phases ....................................................3-28

3-6-1 

Design Phase............................................................................................................................3-28

3-6-2 

Startup Phase ...........................................................................................................................3-28

3-6-3 

Operation Phase .......................................................................................................................3-28

Section 4 

Basic Operations and Status Check

4-1  Run Mode of DB Connection Service and Start/Stop Procedures ....................................4-2

4-1-1 

Run Mode of the DB Connection Service ...................................................................................4-2

4-1-2 

How to Start/Stop the DB Connection Service............................................................................4-2

4-1-3 

DB Connection Service is Stopped or Cannot be Started...........................................................4-4

4-1-4 

Changing the Run Mode of the DB Connection Service .............................................................4-5

4-2  Establishing/Closing a DB Connection ...............................................................................4-6

4-3  Checking the Status of DB Connection Service and each DB Connection......................4-7

4-3-1 

Operation Status of the DB Connection Service .........................................................................4-7

4-3-2 

Checking the Status of the DB Connection Service....................................................................4-8

4-3-3 

Connection Status of each DB Connection...............................................................................4-10

4-3-4 

Checking the Status of each DB Connection ............................................................................ 4-11

Section 5 

Other Functions

5-1  Examples of Using Functions...............................................................................................5-3

5-2  Spool Function.......................................................................................................................5-5

5-2-1 

Overview .....................................................................................................................................5-5

CONTENTS

9

NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Summary of Contents for SYSMAC NX series

Page 1: ...Machine Automation Controller NJ NX series Database Connection CPU Unit CPU Unit User s Manual W527 E1 16 NX701 20 NX102 20 NJ501 20 NJ101 20...

Page 2: ...this publication Sysmac and SYSMAC are trademarks or registered trademarks of OMRON Corporation in Japan and other countries for OMRON factory automation products Microsoft Windows Excel and Visual B...

Page 3: ...f designing FA systems Personnel in charge of installing and maintaining FA systems Personnel in charge of managing FA systems and facilities For programming this manual is intended for personnel who...

Page 4: ...ies CPU Unit Built in EtherCAT Port User s Manual NJ NX series CPU Unit Built in EtherNet IP Port User s Manual NX series CPU Unit FINS Functions User s Manual NJ NX series Database Connection CPU Uni...

Page 5: ...r s Manual NJ series Robot Integrated CPU Unit User s Manual NJ NX series CPU Unit Troubleshooting Manual Testing operation and debugging Using motion control Using EtherCAT Using EtherNet IP Using FI...

Page 6: ...e sliders toward the back until they lock into place Level 1 heading Level 2 heading Level 3 heading Level 2 heading A step in a procedure Manual name Special information Level 3 heading Page tab Give...

Page 7: ...efers to transferring data from Sysmac Studio to the physical Controller and upload refers to transferring data from the physical Controller to Sysmac Studio For Sysmac Studio synchronization is used...

Page 8: ...Manual Structure 6 NJ NX series Database Connection CPU Units User s Manual W527...

Page 9: ...ser s Manual W527 1 I 2 3 4 5 6 7 8 A 1 I 6 2 3 4 7 8 A Introduction to the DB Connection Service Index DB Connection settings Basic Operations and Status Check Programming the DB Connection Function...

Page 10: ...ons 21 Version Types 21 Checking Versions 21 Unit Versions of CPU Units and Sysmac Studio Versions 23 Related Manuals 24 Terminology 26 Revision History 28 Section 1 Introduction to the DB Connection...

Page 11: ...on Sysmac Studio 3 24 3 5 3 DB Connection Instruction Set 3 24 3 5 4 System defined Variables 3 25 3 5 5 Simulation Debugging of DB Connection Instructions 3 26 3 5 6 Transferring the DB Connection S...

Page 12: ...Prevent Losing SQL Statements at Power Interruption 5 28 5 6 1 Overview 5 28 5 6 2 Procedures 5 28 5 7 Timeout Monitoring Functions 5 33 5 7 1 Timeout Monitoring Functions 5 33 5 7 2 Login Timeout 5...

Page 13: ...Connection 7 6 Variables 7 6 Related System defined Variables 7 7 Related Error Codes 7 7 Function 7 7 Precautions for Correct Use 7 8 Sample Programming 7 9 DB_Close Close DB Connection 7 10 Variable...

Page 14: ...se 7 73 Sample Programming 7 74 DB_ControlSpool Resend Clear Spool Data 7 78 Variables 7 78 Related System defined Variables 7 79 Related Error Codes 7 79 Function 7 79 Precautions for Correct Use 7 7...

Page 15: ...4 Guideline for System Service Execution Time Ratio A 13 A 1 5 Checking the System Service Execution Time Ratio A 15 A 2 Execution Time of DB Connection Instructions A 18 A 2 1 Restrictions to Executi...

Page 16: ...plying Product or iii repay or credit Buyer an amount equal to the purchase price of the non complying Product provided that in no event shall Omron be re sponsible for warranty repair indemnity or an...

Page 17: ...FOR AN APPLICATION INVOLVING SERIOUS RISK TO LIFE OR PROPERTY OR IN LARGE QUANTITIES WITHOUT ENSURING THAT THE SYSTEM AS A WHOLE HAS BEEN DESIGNED TO ADDRESS THE RISKS AND THAT THE OMRON PRODUCT S IS...

Page 18: ...entative at any time to confirm actual specifications of purchased Product Errors and Omissions Information presented by Omron Companies has been checked and is believed to be accurate how ever no res...

Page 19: ...Manual Cat No W593 NJ series CPU Unit Hardware User s Manual Cat No W500 NJ series Robot Integrated CPU Unit User s Manual Cat No O037 For safety precautions on NJ501 4320 please contact our sales rep...

Page 20: ...Manual Cat No W593 NJ series CPU Unit Hardware User s Manual Cat No W500 NJ series Robot Integrated CPU Unit User s Manual Cat No O037 For precautions for safe use on NJ501 4320 please contact our sal...

Reviews: