background image

6-4-4 

Checking the SQL Execution Failure Log .................................................................................6-30

6-4-5 

SQL Execution Failure Log File Specifications .........................................................................6-30

6-5  SD Memory Card Operations ..............................................................................................6-36

6-5-1 

Saving Operation Log Files on SD Memory Card .....................................................................6-36

6-5-2 

Directory Used for DB Connection Service ...............................................................................6-36

6-5-3 

Operation Log Operations in Replacing the SD Memory Card .................................................6-37

6-5-4 

Guidelines for SD Memory Card Replacement Time ................................................................6-37

6-5-5 

Replacement Timing of SD Memory Card.................................................................................6-38

6-6  Checking the Operation Logs.............................................................................................6-39

6-6-1 

How to Check the Operation Logs ............................................................................................6-39

6-6-2 

Checking the Log on the Operation Log Window in Sysmac Studio.........................................6-39

6-6-3 

Checking the Log with the SD Memory Card ............................................................................6-41

6-6-4 

Checking the Log by Transfer using FTP Client Software ........................................................6-41

Section 7 

DB Connection Instructions

DB Connection Instructions and Variables ...................................................................................7-2

DB Connection Instruction Set......................................................................................................................7-2
Variables Used in the DB Connection Instructions 
.......................................................................................7-2

DB_Connect (Establish DB 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

Variables .....................................................................................................................................................7-10
Related System-defined Variables
..............................................................................................................7-11
Related Error Codes 
...................................................................................................................................7-11
Function 
......................................................................................................................................................7-11
Precautions for Correct Use 
.......................................................................................................................7-11
Sample Programming 
.................................................................................................................................7-12

DB_CreateMapping (Create DB Map) ...........................................................................................7-13

Variables .....................................................................................................................................................7-13
Related System-defined Variables
..............................................................................................................7-14
Related Error Codes 
...................................................................................................................................7-14
Function 
......................................................................................................................................................7-15
Precautions for Correct Use 
.......................................................................................................................7-15
Sample Programming 
.................................................................................................................................7-16

DB_Insert (Insert DB Record) .......................................................................................................7-17

Variables .....................................................................................................................................................7-17
Related System-defined Variables
..............................................................................................................7-18
Related Error Codes 
...................................................................................................................................7-18
Function 
......................................................................................................................................................7-19
Precautions for Correct Use 
.......................................................................................................................7-19
Sample Programming 
.................................................................................................................................7-20

DB_Update (Update DB Record)...................................................................................................7-21

Variables .....................................................................................................................................................7-21
Related System-defined Variables
..............................................................................................................7-22
Related Error Codes 
...................................................................................................................................7-22
Function 
......................................................................................................................................................7-23
Precautions for Correct Use 
.......................................................................................................................7-24
Sample Programming 
.................................................................................................................................7-25

DB_Select (Retrieve DB Record) ..................................................................................................7-39

Variables .....................................................................................................................................................7-39
Related System-defined Variables
..............................................................................................................7-40
Related Error Codes 
...................................................................................................................................7-40
Function 
......................................................................................................................................................7-41

CONTENTS

11

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

Содержание SYSMAC NX series

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

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

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

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

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

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

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

Страница 8: ...Manual Structure 6 NJ NX series Database Connection CPU Units User s Manual W527...

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

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

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

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

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

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

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

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

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

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

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

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

Отзывы: