实操派文库一最全的工山omRonMachine Automation ControllerNJ/NX-series入最全的工业自动化手册下载至Database Connection CPU Units学PLC就是快User's ManualNX701-▣▣20NX102-☐▣20NJ501-☐▣20NJ101-☐▣20实操派文库一最全的工业自动化手册下载：到“实操派”，学PLC就是快！实操派文库一最全的工业自动化手册下就全CPU UnitW527-E1-12always in control实操派文库一最全的工业自动化手册下载：到实操派文库一最全的工业自动化手册下载NOTEAll rights reserved.No part of this publication may be reproduced.stored in a retrieval system.ortransmitted,in any form,or by any means,mechanical,electronic,photocopying.recording.or oth-erwise,without the prior written permission of OMRON.No patent liability is assumed with respect to the use of the information contained herein.Moreover.because OMRON is constantly striving to improve its high-quality products,the informa-tion contained in this manual is subject to change without notice.Every precaution has been taken in the preparation of this manual.Nevertheless,OMRON as-sumes no responsibility for errors or omissions.Neither is amy liability assumed for damages resulting from the use of the information contained inthis publication.TrademarksSysmac and SYSMAC are trademarks or registered trademarks of OMRON Corporation in Japan实操and other countries for OMRON factory automation products.实Microsoft,Windows,Windows Vista,Excel,and SQL Server are either registered trademarks ortrademarks of Microsoft Corporation in the United States and other countries.EtherCAT is registered trademark and patented technology,licensed by Beckhoff AutomationGmbH,Germany.ODVA,CIP,CompoNet,DeviceNet,and EtherNet/IP are trademarks of ODVA..The SD and SDHC logos are trademarks of SD-3C.LLCOracle,Java,and MySQL are registered trademarks of Oracle Corporation and/or its affiliates in the的工业自动化手册下USA and other countries.IBM and DB2 are registered trademarks of International Business Machines Corporation in the USAand other countries.Firebird is a registered trademark of Firebird Foundation IncorporatedPostgreSQL is a registered trademark of PostgreSQL Global Development GroupOther pany names and product names in this document are the trademarks or registered trade-marks of their respective panies.CopyrightsMicrosoft product screen shots reprinted with permission from Microsoft Corporation.This product incorporates certain third party software.The license and copyright information associ-ated with this software is available at ://www.fa.omron.co.jp/nj_info_e/Introduction实操实操派文库Introduction最Thank you for purchasing an NJ/NX-series CPU Unit.This manual contains information that is necessary to use the Database Connection Service with theNJ/NX-series CPU Unit.(Database may be referred to as DB hereinafter.)Please read this manualand make sure you understand the functionality and performance of the NJ/NX-series CPU Unit be-册下fore you attempt to use it in a control system.Keep this manual in a safe place where it will be available for reference during operation.Intended AudienceThis manual is intended for the following personnel,who must also have knowledge of electrical systems(an electrical engineer or the equivalent).Personnel in charge of introducing FA systems.Personnel in charge of 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 understand the programming languagespecifications in international standard IEC 61131-3 or Japanese standard JIS B 3503.Applicable ProductsThis manual covers the following products.实操派文库NX-series Database Connection CPU Unitsa)X701-1720b)X701-1620c)X102-1220d)X102-1120f)X102-9020NJ-series Database Connection CPU Unitsa)NW501-1520实操派文库一最全的工业自动化手册下载b)NW501-1420c)NW501-1320d)NW501-4320e)NW101-1020f)NW101-9020·Sysmac Studio学C就X701-☐▣20：Version1.21 or higherX102-▣▣20：Version1.24 or higherNW501-☐☐20orNW101-▣▣20：Version1.14 or higherNJ/NX-series Database Connection CPU Units User's Manual (W527)Relevant Manuals实操实操派文库Relevant ManualsThe following table provides the relevant manuals for the NJ-series CPU Units.Read all of the man-uals that are relevant to your system configuration and application before you use the NJ-series CPUUnit.Most operations are performed from Sysmac Studio Automation Software.Refer to the Sysmac StudioVersion 1 Operation Manual(Cat.No.W504)for information on Sysmac Studio.ManualHardware User's ManualNX-series CPU UnitInstructions Reference ManualNJ/NX-seriesGControl Instructions Reference ManuaFINS Functions User'sNX-series CPU UnitPurpose of useManuaManuaCPU UnitsUnitsIntroduction to NX 102 CPU0UnitsIntroduction to NJ-series Con-0trollersSetting devices and hardwareUsing motion control0Using EtherCAT∠000Using EtherNet/IP、0Using the database connec-0tion serviceUsing motion controlUsing EtherCAT0Using EtherNet/IP00Using FINS0Using the database connec-tion service0Writing the user programUsing motion control00Using EtherCAT0Using EtherNet/IP0Using FINS0Using the database connec-tion serviceing2NJ/NX-series Database Connection CPU Units User's Manual (W527)Relevant Manuals实操派文Manual一最全的工业自动化手Basic informationHardwaNX-series NX102 CPU UnitHardware User's ManualNJ-series CPU UnitNJ/NX-seriesMotiMotioNJ/NX-seriesUser's ManualReference ManualC CNJ/NX-series CPU UnitControl InstructionsNJ/NX-series CPU UnitBuilt-in EtherCAT PortCPU UnitPurpose of uset User's ManualUser's ManualManuaReferenceManuaTesting operation and debug-gingUsing motion controlUsing EtherCAT0Using EtherNet/IP0Using FINS0Using the database connec0tion serviceLearning about error manage-△△ment and corrections"1MaintenanceUsing motion controlUsing EtherCATUsing EtherNet/IP0*1.Refer to the NJ/NX-series Troubleshooting Manual(Cat.No.W503)for the error management concepts and an overview of the erroritems.However,refer to the manuals that are indicated with triangles (A)for details on errors corresponding to the products with themanuals that are indicated with triangles(A).工业自动化手册下载：到"实操派”，学PLC就是快的工业自动化手册下载NJ/NX-series Database Connection CPU Units User's Manual (W527)3Manual Structure实操实操派文库Manual StructurePage StructureThe following page structure is used in this manual.最的工业白化手册下载Level 1 headingLevel 2 headingLevel 2 heading4-3Mounting UnitsLevel 3 headingGives the currentLevel 3 headingheadings.A step in a procedureIndicates a procedure.Page tabGives the numberof the main section.Special informationlcons indicateprecautions,additionalManual name实操派文库一最全的工业自动化手册下载Special InformationSpecial information in this manual is classified as follows:Precautions on what to do and what not to do to ensure safe usage of the product.Precautions on what to do and what not to do to ensure proper operation and performance.Additional information to read as required.This information is provided to increase understanding or make operation easier.NJ/NX-series Database Connection CPU Units User's Manual (W527)Manual Structure实操派文库实操派文库Version InformationInformation on differences in specifications and functionality for Controller with different unit versionsand for different versions of the Sysmac Studio is given.白Precaution on TerminologyIn this manual,"download"refers to transferring data from Sysmac Studio to the physical Controllerand"upload"refers to transferring data from the physical Controller to Sysmac Studio.For Sysmac Studio,"synchronization"is used to both"upload"and"download"data.Here,"synchronize"means to automatically pare the data for Sysmac Studio on the puter with thedata in the physical Controller and transfer the data in the direction that is specified by the user.实操派文库一最全的工业自动化手册下载：到实操派”，学PLC就是快！实操派文库一最全的工业自动化手册下载至NJ/NX-series Database Connection CPU Units User's Manual (W527)Manual Structure实操派文库一最全的工业自动化手册下载：到实操派”，学PLC就是快！实操派文库一最全的工业自动化手册下载至实操派文库一最全的工业自动化手册下载：到"实操派”，学PLC就是快！实操派文库一最全的工业自动化手册下载全NJ/NX-series Database Connection CPU Units User's Manual (W527)Sections in this Manual实操派Sections in this Manual工业自动化手册下载：到“实操实操派文库一最的工业自动化Introduction to the DB21Connection ServiceIndex是快32DB Connection settings43Programming the DB Connection Function5Basic Operations and Status Check6实5Other Functions实操派库一全86How to Use Operation LogsADB Connection Instruction8Troubleshooting实操派AAppendixLC就是快NJ/NX-series Database Connection CPU Units User's Manual (W527)7CONTENTS实操派文库CONTENTS最Introduction..........1Intended Audience1Applicable Products.Relevant Manuals..Manual Structure..........Page Structure..Special Information........Precaution on TerminologySections in this Manual..........7Terms and Conditions AgreementWarranty,Limitations of Liability.......Application Considerations15Disclaimers.……Safety Precautions..............17Precautions for Safe Use ..........18Precautions for Correct Use.....19Regulations and Standards .............20实操派文库Versions.…21Version Types........21Checking Versions......21Unit Versions of CPU Units and Sysmac Studio Versions.23Related Manuals...........24Terminology….26Revision History…28载Section 1Introduction to the DB Connection Service1-1 Overview and Features....1-1-1Overview ..1-1-2Features.1-2 DB Connection Service Specifications and System......1-2.11-2-2DB Connedtion System.............................1-3 Operation Flow of the DB Connection Service...1-14Section 2 DB Connection Settings2-1 Starting Sysmac Studio and Creating a New Project...................2-2NJ/NX-series Database Connection CPU Units User's Manual (W527)CONTENTS实操派文实操派文Starting Sysmac Studio2-1-2Creating a New ProjectSetting the Built-in EtherNet/IP Port2.1-4Controller Setup ........2-32-2DB Connection Settings......2-21DB Connection Service Settings ...........DB Connection Settings..........25Section 3Programming the DB Connection Function3-1DB Access Procedure ....3-23-2Creating a Structure Data Type3-33-2-2Specifications of Structure Data Type for DB Access333-2-3How to Create a Structure Data Type for DB Access3-3Creating a DB Map Variable..3-173-3-1DB Map Variables and DB Mapping..3-173-32Registration and Attributes of DB Map Variables.....3-18Restrictions on DB Map Variables..3-193-4 Specifying the Table and Applying the Mapping......3-203-41DB Mapping by Executing a Create DB Map Instruction.3-203-4-2Clearing the Mapping of DB Map Variables....3-203-43Restrictions on DB Mapping.......3-203-5 Programming and Transfer.3-243-5-1Programming the DB Connection Service .......3-5-2Displaying DB Connection Instructions on Sysmac Studio3-253-5-3DB Connection Instruction Set..........................3-253-5-4System-defined Variables.....3-263-5-5实操派文库.3-273-56Transferring the DB Connection Settings and User Program...3-283-6 Debugging in Design,Startup,and Operation Phases........3-293-6-1Design phase3-293-6-23-6-3Operati0 n Phase…l3-29Section 4Basic Operations and Status Check4-1Run Mode of DB Connection Service and Start/Stop Procedures...................4-24-1-1Run Mode of the DB Connection Service4-1-2How to Start/Stop the DB Connection Service...4-24-1-3DB Connection Service is Stopped or Cannot be Started.....4-1-4Changing the Run Mode of the DB Connection Service4-54-2Establishing/Closing a DB Connection ..........4-64-3Checking the Status of DB Connection Service and each DB Connection....4-74-3-1Operation Status of the DB Connection Service..4-3-2Checking the Status of the DB Connection Service....4-84-3-3Connection Status of each DB Connection..4-104-3-4Checking the Status of each DB Connection4-11Section 5Other Functions5-1Examples of Using Functions........5-2 Spool Function.5-55-2.1.5-5NJ/NX-series Database Connection CPU Units User's Manual (W527)9CONTENTS实操派文Spooling System..Applicable Instructions and Spooling Execution Conditions最全5-2-4Memory Area Used by the Spool Function.5-6Spool Function Settings.5-2-6How to Resend the SQL Statements Stored in the Spool Memory..5-8Clearing the SQL Statements from the Spool Memory..........................5-95-2-8Relationship with the DB Connection Instructions ...5-1152-9How to Estimate the Number of SQL Statements that can be Spooled.......5135-3Stored Procedure Call Function.......5-3-1Overview ....5-165-3-2Specifications of the Stored Procedure Call Function for Databases....5-17Howto Execute the Stored Procedure Call Function..5-195-3-4Specifying the Table and Applying the Mapping.5-205-3-5Errors during Stored Procedure Call ..........................5-225-4 Batch Insert Function.5-2454-1.5-2454-2How to Execute the Batch Insert Function......5-255-5 DB Connection Service Shutdown Function...5.-2655-15-5-25-5-3How to Execute the Shutdown Function....5-275-5-4How to Check the Shutdown of the DB Connection Service......5275-6 How to Prevent Losing SQL Statements at Power Interruption......5-285-6-1Overview...56-2Procedures ....5-285-7 Timeout Monitoring Functions.....5-335-7.15-7-25-7-3Query Execution Timeout..5-345-7-4Communications Timeout....5-34实操5-7-5Instruction Execution Timeout5-7-6Keep Alive Monitoring Time.....5-35文5-8 Other Functions.......5-365-8-1Backup/Restore Function in the DB Connection Service...............................5-365-8-2Operation Authority Verification in the DB Connection Service..5-375-8-3Encrypted Communication.....5-37Section 6How to Use Operation Logs6-1Operation Logs.…6-2Execution Log....6-2-26-3Application Procedure......................6-36-2-3Setting the Execution Log......6-2-4Checking the Execution Log.....6-4Execution Log File Specifications6-3 Debug Log...6-1563-163-2Application Procedure........6-3-3Set the Debug Log.…6-3-4Start Recording to the Debug Log..6-1663-5Stopping Recording to Debug Log6176-3-6Checking the Debug Log.........6-186-3-7Debug Log File Specifications.....6-186-4 SQL Execution Failure Log...............6-296-4-1.6-296-4-2Application Procedure..........6-29Setting the SQL Execution Failure Log.6-2910NJ/NX-series Database Connection CPU Units User's Manual (W527)CONTENTS实操派文库实操派文6-44Checking the SQL Execution Failure Log6-4-5SQL Execution Failure Log File Specifications.6-30SD Memory Card Operations.......6-366-5-1Saving Operation Log Files on SD Memory Card...6-366-5-2Directory Used for DB Connection Service6-366-53Operation Log Operations in Replacing the SD Memory Card..................6-376-54Guidelines for SD Memory Card Replacement Time........................6-376-5-5Replacement Timing of SD Memory Card..........................6-6 Checking the Operation Logs.................6-396-6-1How to Check the Operation Logs ....6-396-6-2Checking the Log on the Operation Log Window in Sysmac Studio..6-396-63Checking the Log with the SD Memory Card....6-416-6-4Checking the Log by Transfer using FTP Client Software.6-41Section 7DB Connection InstructionsDB Connection Instructions and Variables...7-2DB Connection Instruction Set.....................Variables Used in the DB Connection InstructionsDB_Connect(Establish DB Connection)...7-6.7-6Related System-defined Variables........Related Error Codes.....7-7Function.....Precautions for Correct Use ..7-8Sample Programming ....................DB Close (Close DB Connection)....Related System-defined Variables7-11实操派文库Related Error Codes......................7-11Function......Precautions for Correct Use.Sample Programming ......DB_CreateMapping (Create DB Map).Variables.....7-13Related System-defined Variables....Related Error Codes.…7-14Function ........7-15Precautions for Correct Use.7-15Sample Programming…DB_Insert(Insert DB Record)Variables........Related System-defined Variables.Related Error Codes.….7-18Function......7-19Precautions for Correct Use....Sample Programming.........7-20DB_Update(Update DB Record)..7-21Variables….7-21Related System-defined VariablesRelated Error Codes....................7-22FunctionPrecautions for Correct Use .........Sample Programming ......7-25DB_Select(Retrieve DB Record).Variables.…Related System-defined VariablesNJ/NX-series Database Connection CPU Units User's Manual (W527)11CONTENTS实操派文实操派文Precautions for Correct Use7-43Sample Programming.DB Delete (Delete DB Record).7-45Variables.……Related System-defined Variables...................................7-45Related Error Codes.Function..7-47Precautions for Correct Use....Sample Programming.......7-48DB_ControlService (Control DB Connection Service)7-60Variables ....7-60Related System-defined Variables........7-61Related Error Codes......7-61Function..…Precautions for Correct Use.7-62Sample Programming.....................DB_GetServiceStatus(Get DB Connection Service Status)..7-66Variables........7-66Related Error Codes7-67Function.Precautions for Correct Use.7-67Sample Programming.......DB_GetConnectionStatus(Get DB Connection Status).7-71Variables ...Related System-defined Variables.......7-72772Function.......7-72Precautions for Correct Use......................7-72Sample Programming......................DB_ControlSpool(Resend/Clear Spool Data)7-77Variables.实操派文库Related System-defined Variables.7-78Related Error Codes....7-78Function......7-78Precautions for Correct Use..................Sample Programming................7-79DB PutLog (Record Operation Log).7-84Variables.7-84Related Error Codes7-85Function.…7-85Precautions for Correct Use...............7-86Sample Programming.........DB_Shutdown(Shutdown DB Connection Service).Variables...Related System-defined Variables...Related Error Codes.....7-91.7-91Precautions for Correct Use .........Sample Programming......................7-91DB_Batchlnsert (DB Records Batch Insert)......7-94Variables.....7-94Related System-defined Variables..7-95Related Error Codes..7-95Function....Precautions for Correct Use ....7-96Sample Programming....7-97DB AttachProcedure (Generate DB Stored Procedure Handle)..7-107Variables……….7-107.7-108Related Error Codes12NJ/NX-series Database Connection CPU Units User's Manual (W527)CONTENTS实操派文库实操派文Function .....Precautions for Correct Use....7-110Sample Programming..................DBExecuteProcedure(Execute DB Stored Procedure)....7-1127-113Related Error Codes....7-114Precautions for Correct Use....7.115Sample Programming .......7-115DB_DetachProcedure(Release DB Stored Procedure Handle).Variables...Related System-defined Variables.....Function ......7-1257-125Precautions for Correct Use.........7-125Sample Programming.........7-126Section 8Troubleshooting8-1Overview of Errors.........8-28-1-1How to Check for Errors8-1-2Errors Related to the DB Connection Service858-2 Troubleshooting.............8-8Error Table....8-88-2-2Error Descriptions.8-16AppendixA-1Task Design Procedure.....................A-1-1Startup Time of DB Connection Service..A-1-2Reference Values for Execution Time of DB Connection InstructionsA-13How to Measure Execution Time of DB Connection Instructions.....A-11最全A-1-4Guideline for System Service Execution Time RatioA-1-5Checking the System Service Execution Time Ratio..A-13A-2 Execution Time of DB Connection Instructions...A-15Restrictions to Execution Time of DB Connection Instructions.A-15Impact of Operation Log Recording on Execution Time of DB Connection InstructionsA-2-3How to Measure DB Response Time....A-2-4Ensuring Equipment Performance (Takt Time)by Monitoring Instruction Execution Timeout..A-23.A-25A-3-1A-3-2Performance Specifications.A-25A-3-3Function Specifications.....A-4 Version Information......A-4-1Unit Versions and Corresponding DB Connection Service Versions...A4-2DB Connection Functions that were Added or Changed for Each Unit Version.......A-4-3Unit Version,DB Connection Service Version,and Unit Version Set in the Sysmac Stu-A-4-4DB Connection Service Version and Connection Database Types After Changing Devices...A-30A-4-5DB Connection Service Versions and Connection Database Types/ersions ......................A-31IndexNJ/NX-series Database Connection CPU Units User's Manual (W527)13