实操派文库一最全的工山omRonMachine Automation ControllerNJ/NX-series入最全的工业自动化手册下载至Database Connection CPU Units学PLC就是快User's ManualNX701-▣▣20NX102-☐▣20NJ501-☐▣20NJ101-☐▣20实操派文库一最全的工业自动化手册下载：到“实操派”，学PLC就是快！实操派文库一最全的工业自动化手册下就全CPU UnitW527-E1-10always 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.Oracle,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实操实操派文库IntroductionThank 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.Hereinafter the Database Connection Service is called "DB Connection Serv-ice".Please read this manual and make sure you understand the functionality and performance of theNJ-series CPU Unit before 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-1220f)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 ManuaNX-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 control0Using EtherCAT0Using EtherNet/IP0Using FINS0Using the database connec-tion serviceing2NJ/NX-series Database Connection CPU Units User's Manual (W527)Relevant ManualsManual一最全的工业自动化手Basic informationHardwaNJ/NX-seriesMotiMotioNJ/NX-seriesUser's ManualNX-series NX102 CPU UnitHardware User's ManualNJ-series CPU UnitPurpose of useReference ManualC CNJ/NX-series CPU UnitControl InstructionsBuilt-in EtherCAT PortNJ/NX-series CPU UnitCPU UnitManuaReferencet User's ManualUser's ManualManuaTesting operation and debug-gingUsing motion control0Using 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…Revision History…27载Section 1Introduction to the DB Connection Service1-1 Overview and Features....1-1-1Overview ..1-1-2Features.1-31-2 DB Connection Service Specifications and System.......1-51-2.11-2-2DB Connedtion System..........................1-101-3 Operation Flow of the DB Connection Service..Section 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 Project2-2Setting the Built-in EtherNet/IP Port2.1-4Controller Setup ........2-2DB Connection Settings......2-21DB Connection Service Settings ...........DB Connection Settings..........Section 3Programming the DB Connection Function3-1DB Access Procedure ..3-23-2Creating a Structure Data Type3-33-33-2-2Specifications of Structure Data Type for DB Access3-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-32Registration and Attributes of DB Map Variables....3-18Restrictions on DB Map Variables3-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 Variables3-203-43Restrictions on DB Mapping.......3-203-5 Programming and Transfer..3-243-5-1Programming the DB Connection Service .......3-243-5-2Displaying DB Connection Instructions on Sysmac Studio.3-5-3DB Connection Instruction Set....3-253-5-4System-defined Variables.....3-263-5-5实操派文库3-56Transferring the DB Connection Settings and User Program.3-273-6 Debugging in Design,Startup,and Operation Phases.......3-6-1Design phase.293-6-23-6-3Section 4Basic Operations and Status Check4-1Run Mode of DB Connection Service and Start/Stop Procedures....................4-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 Service......4-.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-3-3Connection Status of each DB Connection.4-104-3-4Checking the Status of each DB Connection.4-11Section 5Other Functions5-1Examples of Using Functions........5-2 Spool Function.…5-45-2.1NJ/NX-series Database Connection CPU Units User's Manual (W527)9CONTENTS实操派文Spooling System...Applicable Instructions and Spooling Execution Conditions5-2-4Memory Area Used by the Spool Function.........5-55-2.5Spool Function Settings....5-75-2-6How to Resend the SQL Statements Stored in the Spool Memory.....5-27Clearing the SQL Statements from the Spool Memory............................5.-85-2-8Relationship with the DB Connection Instructions ...5-1052-9How to Estimate the Number of SQL Statements that can be Spooled.......5-125-3 DB Connection Service shutdown function........................5-155-3-1Overview.....5-3-2Shutdown System....5-15Howto Execute the Shutdown Function.5-165-3-4Howto Check the Shutdown of the DB Connection Service.........5-.165-4 How to Prevent Losing SQL Statements at Power Interruption........................5-175-4-1.5-175-4-25-5 Timeout Monitoring Functions.......5-215-5-1Timeout Monitoring Functions....5-2155-2Login Timeout........5-5-3Query Execution Timeout............5-5-4Communications Timeout.....5-2255-5Instruction Execution Timeout5-5-6Keep Alive Monitoring Time....5-235-6 Other Functions...............Backup/Restore Function in the DB Connection Service..5-6-2Operation Authority Verification in the DB Connection Service.............5-.25Section 6How to Use Operation Logs6-16-2Execution Log..6-3Overview....6-3Application Procedure...6-2.3Setting the Execution Log....6-2-5Execution Log File Specifications6-3Debug Log…Overview...6-3-2Application Procedure....6-3-3.6-9Start Recording to the Debug Log....6-3-5Stopping Recording to Debug Log6-3-6Checking the Debug Log...............63-7Debug Log File Specifications.6-4 SQL Execution Failure Log.64-1Overview....6-4-2Application Procedure....6-4-3Setting the SQL Execution Failure Log.6-4-4Checking the SQL Execution Failure Log.6-186-4-5SQLExecution Failure Log File Specifications.........6-186-5SD Memory Card Operations..........6-226-5-1Saving Operation Log Files on SD Memory Card..6-2265-2Directory Used for DB Connection Service6-226-5-3Operation Log Operations in Replacing the SD Memory Card ...........6-236-5-4Guidelines for SD Memory Card Replacement Time....6-236-5-5Replacement Timing of SD Memory Card.......6-246-6 Checking the Operation Logs...6-256-6-1How to Check the Operation Logs10NJ/NX-series Database Connection CPU Units User's Manual (W527)CONTENTS实操派文库实操派6-6-2Checking the Log on the Operation Log Window in Sysmac Studio.6-6-3Checking the Log with the SD Memory Card....6-6-4Checking the Log by Transfer using FTP Client SoftwareSection7DB Connection InstructionsDB Connection Instructions and Variables7-2DB Connection Instruction Set...............................7-2Variables Used in the DB Connection Instructions....DB_Connect(Establish DB Connection).......7-6Variables....Related System-defined Variables.Related Error Codes...Function....7-8Precautions for Correct Use.7-8Sample Programming...................DB_Close(Close DB Connection).....Related System-defined Variables.7-11Related Error CodesFunction.….7-11Precautions for Correct Use......7-11Sample Programming…DB_CreateMapping(Create DB Map).Related System-defined Variables.............7-14Related Error Codes.......Function..........Precautions for Correct Use........Sample Programming ..............7-16实操派文库DB_Insert(Insert DB Record)Variables.…Related System-defined VariablesRelated Error Codes....Precautions for Correct Use.................Sample Programming ............7-20DB_Update(Update DB Record).721721Related System-defined VariablesRelated Error CodesFunction.…Precautions for Correct Use.7-24Sample Programming…DB_Select(Retrieve DB Record)7-39Variables.……Related System-defined VariablesRelated Error Codes...............Function......7-41Precautions for Correct Use ......7-43Sample Programming ..............DB_Delete(Delete DB Record)....Related System-defined Variables.7-46Related Error Codes...Function ...Precautions for Correct Use7-47Sample Programming ........DB ControlService (Control DB Connection Service).7-60NJ/NX-series Database Connection CPU Units User's Manual (W527)11CONTENTS实操派文实操派文Variables..7-60Related System-defined Variables..7-61Related Error Codes.............7-61%Function.…Precautions for Correct Use.....Sample Programming........................763DB_GetServiceStatus (Get DB Connection Service Status)..............................7-66Variables..……7-66Related Error CodesFunction.....Precautions for Correct UseSample Programming-…DB GetConnectionStatus (Get DB Connection Status)...7-71Variables……Related System-defined Variables.Related Error Codes.....7-72Function....Precautions for Correct UseSample Programming.........DB_ControlSpool(Resend/Clear Spool Data)..Variables ..Related System-defined Variables........7-78Related Error Codes.....Function..…Precautions for Correct Use7-78Sample Programming.…DB_PutLog (Record Operation Log)......7-84Related Error Codes............Function.....7-85Precautions for Correct Use.7-86实操派文Sample Programming.....DB_Shutdown(Shutdown DB Connection Service).7-90Related System-defined Variables........................7-90Related Error Codes............7-91Function...…....Precautions for Correct Use....7-91Sample Programming.Section 8Troubleshooting8-1Overview of Errors....8-28-1-1How to Check for Errors81-2Errors Related to the DB Connection Service8-28-58-2 Troubleshooting.8-8Error Table.…Error Descriptions.....8-15AppendixA-1Task Design Procedure ...........Startup Time of DB Connection Service..A-2A-1-2Reference Values for Execution Time of DB Connection Instructions.A-4How to Measure Execution Time of DB Connection Instructions...A-10Guideline for System Service Execution Time Ratio....A-10A-1-5Checking the System Service Execution Time RatioA-2 Execution Time of DB Connection Instructions ...................A-1412NJ/NX-series Database Connection CPU Units User's Manual (W527)CONTENTS实操派文库Restrictions to Execution Time of DB Connection Instructions最全A-2-2Impact of Operation Log Recording on Execution Time of DB Connection Instructions.......A-21A-2-3How to Measure DB Response Time......A-22A-2-4Ensuring Equipment Performance (Takt Time)by Monitoring Instruction Execution Timeout A-22A-3SpecificationSA-24A-3-1General SpecificationsA3-2A-3-3A-24A-4 Version Information .....A-4-1Unit Versions and Corresponding DB Connection Service Versions...DB Connection Functions that were Added or Changed for Each Unit Version...........A4-3Actual Unit Version of CPU Unit and Unit Version Set in the Sysmac Studio Project.........A-27A-4-4DB Connection Service Version and Connection Database Types After Changing Devices.A-29Index是快实操派文库一最全的工业自动化手册下载：到"实操派”，学PLC就是快实操派文库一最全的工业自动化手册下载NJ/NX-series Database Connection CPU Units User's Manual (W527)13