Omron SYSMAC NJ Series User manual

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

1. All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or transmitted, in
any form, or by any means, mechanical, electronic, photocopying, recording, or otherwise, without the prior
written permission of OMRON.
2. 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 information contained
in this manual is subject to change without notice.
3. Every precaution has been taken in the preparation of this manual. Nevertheless, OMRON assumes no responsi-
bility for errors or omissions.
Neither is any liability assumed for damages resulting from the use of the information contained in 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 Basic are either registered trademarks or trademarks of Microsoft Corpora-
tion in the United States and other countries.
• EtherCAT®is registered trademark and patented technology, licensed by Beckhoff Automation GmbH, Germany.
• ODVA, CIP, CompoNet, DeviceNet, and EtherNet/IP are trademarks of ODVA.
• The SD and SDHC logos are trademarks of SD-3C, LLC.
Other company names and product names in this document are the trademarks or registered trademarks of their
respective companies.
Trademarks
Copyrights
NOTE
• Microsoft product screen shots used with permission from Microsoft.
• This product incorporates certain third party software. The license and copyright information associated with this
software is available at http://www.fa.omron.co.jp/nj_info_e/.

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 the
NJ/NX-series CPU Unit. (Database may be referred to as DB hereinafter.) Please read this manual
and 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 Audience
This 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 language
specifications in international standard IEC 61131-3 or Japanese standard JIS B 3503.
Applicable Products
This manual covers the following products.
• NX-series Database Connection CPU Units
a) NX701-1720
b) NX701-1620
c) NX102-1220
d) NX102-1120
e) NX102-1020
f) NX102-9020
• NJ-series Database Connection CPU Units
a) NJ501-1520
b) NJ501-1420
c) NJ501-1320
d) NJ501-R520
e) NJ501-R420
f) NJ501-R320
g) NJ501-4320
h) NJ101-1020
i) NJ101-9020
• Sysmac Studio
a) SYSMAC-SE2£££
NX701-££20: Version 1.21 or higher
NX102-££20: Version 1.24 or higher
NJ501-1£20, NJ501-4£20, or NJ101-££20: Version 1.14 or higher
NJ501-R£20: Version 1.44 or higher
Introduction
1
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Relevant Manuals
The 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 CPU
Unit.
Most operations are performed from Sysmac Studio Automation Software. Refer to the Sysmac Studio
Version 1 Operation Manual (Cat. No. W504) for information on Sysmac Studio.
Manual
Basic information
Purpose of use
NX-series CPU Unit Hardware User’s Manual NX-series NX102 CPU Unit Hardware User’s Manual NJ-series CPU Unit Hardware User’s Manual NJ/NX-series CPU Unit Software User’s Manual NJ/NX-series Instructions Reference Manual NJ/NX-series CPU Unit Motion Control User’s Manual NJ/NX-series Motion Control Instructions Reference Manual NJ/NX-series 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 Units User’s Manual NJ-series Robot Integrated CPU Unit User’s Manual NJ/NX-series CPU Unit Troubleshooting Manual
Introduction to NX701 CPU Units ¡
Introduction to NX102 CPU Units ¡
Introduction to NJ-series Controllers ¡
Setting devices and hardware
¡ ¡ ¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using the database connection service ¡
Software settings
¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Writing the user program
¡ ¡
Using motion control ¡ ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
Using FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Programming error processing ¡
Relevant Manuals
2NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Manual
Basic information
Purpose of use
NX-series CPU Unit Hardware User’s Manual NX-series NX102 CPU Unit Hardware User’s Manual NJ-series CPU Unit Hardware User’s Manual NJ/NX-series CPU Unit Software User’s Manual NJ/NX-series Instructions Reference Manual NJ/NX-series CPU Unit Motion Control User’s Manual NJ/NX-series Motion Control Instructions Reference Manual NJ/NX-series 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 Units User’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 FINS ¡
Using the database connection service ¡
Using robot control for OMRON robots ¡
Learning about error management and correc-
tions*1 rrr¡
Maintenance
¡ ¡ ¡
Using motion control ¡
Using EtherCAT ¡
Using EtherNet/IP ¡
*1. Refer to the NJ/NX-series Troubleshooting Manual(Cat. No. W503) for the error management concepts and an overview of the error
items. However, refer to the manuals that are indicated with triangles (r) for details on errors corresponding to the products with the
manuals that are indicated with triangles (r).
Relevant Manuals
3
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Manual Structure
Page Structure
The following page structure is used in this manual.
4-9
4 Installation and Wiring
NJ-series CPU Unit Hardware User’s Manual (W500)
s
t
i
n
U
gnitn
u
oM
3-4
4
s
t
ne
no
p
m
o
C
rel
l
o
r
t
n
oC
g
n
i
tc
e
n
noC
1
-
3-
4
4-3 Mounting Units
The Units that make up an NJ-series Controller can be connected simply by pressing the Units together
and locking the sliders by moving them toward the back of the Units. The End Cover is connected in the
same way to the Unit on the far right side of the Controller.
1Join the Units so that the connectors fit exactly.
2The yellow sliders at the top and bottom of each Unit lock the Units together. Move the sliders
toward the back of the Units as shown below until they click into place.
Precautions for Correct UsePrecautions for Correct Use
4-3-1 Connecting Controller Components
Connector
Hook Hook holes
Slider
Lock
Release
Move the 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
Gives the current
headings.
Indicates a procedure.
Icons indicate
precautions, additional
information, or reference
information.
Gives the number
of the main section.
This illustration is provided only as a sample. It may not literally appear in this manual.
The sliders on the tops and bottoms of the Power Supply Unit, CPU Unit, I/O Units, Special I/O
Units, and CPU Bus Units must be completely locked (until they click into place) after connecting
the adjacent Unit connectors.
Special Information
Special information in this manual is classified as follows:
Precautions for Safe Use
Precautions on what to do and what not to do to ensure safe usage of the product.
Precautions for Correct Use
Precautions on what to do and what not to do to ensure proper operation and performance.
Additional Information
Additional information to read as required.
Manual Structure
4NJ/NX-series Database Connection CPU Units User’s Manual (W527)

This information is provided to increase understanding or make operation easier.
Version Information
Information on differences in specifications and functionality for Controller with different unit versions
and for different versions of the Sysmac Studio is given.
Precaution on Terminology
In this manual, "download" refers 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 to both "upload" and "download" data. Here,
"synchronize" means to automatically compare the data for Sysmac Studio on the computer with the
data in the physical Controller and transfer the data in the direction that is specified by the user.
Manual Structure
5
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

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

Sections in this Manual
Sections in this Manual
7
NJ/NX-series Database Connection CPU Units User’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
Other Functions
How to Use Operation Logs
DB Connection Instruction
Troubleshooting
Appendix
5

CONTENTS
Introduction .............................................................................................................. 1
Intended Audience...........................................................................................................................................1
Applicable Products .........................................................................................................................................1
Relevant Manuals..................................................................................................... 2
Manual Structure...................................................................................................... 4
Page Structure.................................................................................................................................................4
Special Information ..........................................................................................................................................4
Precaution on Terminology ..............................................................................................................................5
Sections in this Manual ........................................................................................... 7
Terms and Conditions Agreement........................................................................ 14
Warranty, Limitations of Liability ....................................................................................................................14
Application Considerations ............................................................................................................................15
Disclaimers ....................................................................................................................................................15
Safety Precautions................................................................................................. 17
Precautions for Safe Use ...................................................................................... 18
Precautions for Correct Use ................................................................................. 19
Regulations and Standards .................................................................................. 20
Versions .................................................................................................................. 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 Service
1-1 Overview and Features..........................................................................................................1-2
1-1-1 Overview .....................................................................................................................................1-2
1-1-2 Features ......................................................................................................................................1-3
1-2 DB Connection Service Specifications and System...........................................................1-5
1-2-1 DB Connection Service Specifications........................................................................................1-5
1-2-2 DB Connection System .............................................................................................................1-11
1-3 Operation Flow of the DB Connection Service .................................................................1-14
Section 2 DB Connection Settings
2-1 Starting Sysmac Studio and Creating a New Project .........................................................2-2
CONTENTS
8NJ/NX-series Database Connection CPU Units User’s Manual (W527)

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)

5-2-2 Spooling System .........................................................................................................................5-5
5-2-3 Applicable Instructions and Spooling Execution Conditions .......................................................5-5
5-2-4 Memory Area Used by the Spool Function .................................................................................5-6
5-2-5 Spool Function Settings ..............................................................................................................5-8
5-2-6 How to Resend the SQL Statements Stored in the Spool Memory.............................................5-9
5-2-7 Clearing the SQL Statements from the Spool Memory .............................................................5-10
5-2-8 Relationship with the DB Connection Instructions ....................................................................5-12
5-2-9 How to Estimate the Number of SQL Statements that can be Spooled....................................5-14
5-3 Stored Procedure Call Function .........................................................................................5-16
5-3-1 Overview ...................................................................................................................................5-16
5-3-2 Specifications of the Stored Procedure Call Function for Databases .......................................5-17
5-3-3 How to Execute the Stored Procedure Call Function................................................................5-19
5-3-4 Specifying the Table and Applying the Mapping .......................................................................5-20
5-3-5 Errors during Stored Procedure Call .........................................................................................5-22
5-4 Batch Insert Function ..........................................................................................................5-24
5-4-1 Overview ...................................................................................................................................5-24
5-4-2 How to Execute the Batch Insert Function ................................................................................5-25
5-5 DB Connection Service Shutdown Function.....................................................................5-26
5-5-1 Overview ...................................................................................................................................5-26
5-5-2 Shutdown System .....................................................................................................................5-26
5-5-3 How to Execute the Shutdown Function ...................................................................................5-27
5-5-4 How to Check the Shutdown of the DB Connection Service.....................................................5-27
5-6 How to 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-33
5-7-3 Query Execution Timeout..........................................................................................................5-34
5-7-4 Communications Timeout..........................................................................................................5-34
5-7-5 Instruction Execution Timeout ...................................................................................................5-35
5-7-6 Keep Alive Monitoring Time ......................................................................................................5-35
5-8 Other Functions ...................................................................................................................5-36
5-8-1 Backup/Restore Function in the DB Connection Service..........................................................5-36
5-8-2 Operation Authority Verification in the DB Connection Service.................................................5-37
5-8-3 Encrypted Communication ........................................................................................................5-38
Section 6 How to Use Operation Logs
6-1 Operation Logs ......................................................................................................................6-2
6-2 Execution Log ........................................................................................................................6-3
6-2-1 Overview .....................................................................................................................................6-3
6-2-2 Application Procedure .................................................................................................................6-3
6-2-3 Setting the Execution Log ...........................................................................................................6-3
6-2-4 Checking the Execution Log .......................................................................................................6-4
6-2-5 Execution Log File Specifications ...............................................................................................6-4
6-3 Debug Log ............................................................................................................................6-15
6-3-1 Overview ...................................................................................................................................6-15
6-3-2 Application Procedure ...............................................................................................................6-15
6-3-3 Set the Debug Log ....................................................................................................................6-15
6-3-4 Start Recording to the Debug Log.............................................................................................6-16
6-3-5 Stopping Recording to Debug Log ............................................................................................6-17
6-3-6 Checking the Debug Log...........................................................................................................6-18
6-3-7 Debug Log File Specifications...................................................................................................6-18
6-4 SQL Execution Failure Log .................................................................................................6-29
6-4-1 Overview ...................................................................................................................................6-29
6-4-2 Application Procedure ...............................................................................................................6-29
6-4-3 Setting the SQL Execution Failure Log .....................................................................................6-29
CONTENTS
10 NJ/NX-series Database Connection CPU Units User’s Manual (W527)

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)

Precautions for Correct Use .......................................................................................................................7-43
Sample Programming .................................................................................................................................7-44
DB_Delete (Delete DB Record) .....................................................................................................7-45
Variables .....................................................................................................................................................7-45
Related System-defined Variables..............................................................................................................7-46
Related Error Codes ...................................................................................................................................7-46
Function ......................................................................................................................................................7-47
Precautions for Correct Use .......................................................................................................................7-47
Sample Programming .................................................................................................................................7-48
DB_ControlService (Control DB Connection Service) ...............................................................7-60
Variables .....................................................................................................................................................7-60
Related System-defined Variables..............................................................................................................7-61
Related Error Codes ...................................................................................................................................7-61
Function ......................................................................................................................................................7-62
Precautions for Correct Use .......................................................................................................................7-62
Sample Programming .................................................................................................................................7-63
DB_GetServiceStatus (Get DB Connection Service Status) ......................................................7-67
Variables .....................................................................................................................................................7-67
Related Error Codes ...................................................................................................................................7-68
Function ......................................................................................................................................................7-68
Precautions for Correct Use .......................................................................................................................7-68
Sample Programming .................................................................................................................................7-68
DB_GetConnectionStatus (Get DB Connection Status).............................................................7-72
Variables .....................................................................................................................................................7-72
Related System-defined Variables..............................................................................................................7-73
Related Error Codes ...................................................................................................................................7-73
Function ......................................................................................................................................................7-73
Precautions for Correct Use .......................................................................................................................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-79
Sample Programming .................................................................................................................................7-80
DB_PutLog (Record Operation Log) ............................................................................................7-85
Variables .....................................................................................................................................................7-85
Related Error Codes ...................................................................................................................................7-86
Function ......................................................................................................................................................7-86
Precautions for Correct Use .......................................................................................................................7-87
Sample Programming .................................................................................................................................7-87
DB_Shutdown (Shutdown DB Connection Service) ...................................................................7-91
Variables .....................................................................................................................................................7-91
Related System-defined Variables..............................................................................................................7-91
Related Error Codes ...................................................................................................................................7-92
Function ......................................................................................................................................................7-92
Precautions for Correct Use .......................................................................................................................7-92
Sample Programming .................................................................................................................................7-92
DB_BatchInsert (DB Records Batch Insert) ................................................................................7-95
Variables .....................................................................................................................................................7-95
Related System-defined Variables..............................................................................................................7-96
Related Error Codes ...................................................................................................................................7-96
Function ......................................................................................................................................................7-97
Precautions for Correct Use .......................................................................................................................7-97
Sample Programming .................................................................................................................................7-98
DB_AttachProcedure (Generate DB Stored Procedure Handle)..............................................7-108
Variables ...................................................................................................................................................7-108
Related System-defined Variables............................................................................................................7-109
Related Error Codes .................................................................................................................................7-109
CONTENTS
12 NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Function ....................................................................................................................................................7-110
Precautions for Correct Use ..................................................................................................................... 7-111
Sample Programming ...............................................................................................................................7-112
DB_ExecuteProcedure (Execute DB Stored Procedure).......................................................... 7-113
Variables ...................................................................................................................................................7-113
Related System-defined Variables............................................................................................................7-114
Related Error Codes .................................................................................................................................7-114
Function ....................................................................................................................................................7-115
Precautions for Correct Use .....................................................................................................................7-116
Sample Programming ...............................................................................................................................7-116
DB_DetachProcedure (Release DB Stored Procedure Handle)...............................................7-125
Variables ...................................................................................................................................................7-125
Related System-defined Variables............................................................................................................7-125
Related Error Codes .................................................................................................................................7-126
Function ....................................................................................................................................................7-126
Precautions for Correct Use .....................................................................................................................7-126
Sample Programming ...............................................................................................................................7-127
Section 8 Troubleshooting
8-1 Overview of Errors.................................................................................................................8-2
8-1-1 How to Check for Errors..............................................................................................................8-2
8-1-2 Errors Related to the DB Connection Service.............................................................................8-5
8-2 Troubleshooting.....................................................................................................................8-8
8-2-1 Error Table...................................................................................................................................8-8
8-2-2 Error Descriptions .....................................................................................................................8-16
Appendix
A-1 Task Design Procedure ........................................................................................................ A-2
A-1-1 Startup Time of DB Connection Service..................................................................................... A-2
A-1-2 Reference Values for Execution Time of DB Connection Instructions ....................................... A-4
A-1-3 How to Measure Execution Time of DB Connection Instructions............................................. A-12
A-1-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 Execution Time of DB Connection Instructions ................................................ A-18
A-2-2 Impact of Operation Log Recording on Execution Time of DB Connection Instructions .......... A-25
A-2-3 How to Measure DB Response Time ....................................................................................... A-26
A-2-4 Ensuring Equipment Performance (Takt Time) by Monitoring Instruction Execution Timeout.. A-26
A-3 Specifications...................................................................................................................... A-28
A-3-1 General Specifications ............................................................................................................. A-28
A-3-2 Performance Specifications ..................................................................................................... A-28
A-3-3 Function Specifications ............................................................................................................ A-28
A-4 Version Information ............................................................................................................ A-29
A-4-1 Unit Versions and Corresponding DB Connection Service Versions ....................................... A-29
A-4-2 DB Connection Functions that were Added or Changed for Each Unit Version....................... A-30
A-4-3 Unit Version, DB Connection Service Version, and Unit Version Set in the Sysmac Stu-
dio Project ................................................................................................................................ A-30
A-4-4 DB Connection Service Version and Connection Database Types After Changing Devices ... A-34
A-4-5 DB Connection Service Versions and Connection Database Types/Versions ......................... A-34
Index
CONTENTS
13
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Terms and Conditions Agreement
Warranty, Limitations of Liability
Warranties
Exclusive Warranty
Omron’s exclusive warranty is that the Products will be free from defects in materials and work-
manship for a period of twelve months from the date of sale by Omron (or such other period ex-
pressed in writing by Omron). Omron disclaims all other warranties, express or implied.
Limitations
OMRON MAKES NO WARRANTY OR REPRESENTATION, EXPRESS OR IMPLIED, ABOUT
NON-INFRINGEMENT, MERCHANTABILITY OR FITNESS FOR A PARTICULAR PURPOSE OF
THE PRODUCTS. BUYER ACKNOWLEDGES THAT IT ALONE HAS DETERMINED THAT THE
PRODUCTS WILL SUITABLY MEET THE REQUIREMENTS OF THEIR INTENDED USE.
Omron further disclaims all warranties and responsibility of any type for claims or expenses based
on infringement by the Products or otherwise of any intellectual property right.
Buyer Remedy
Omron’s sole obligation hereunder shall be, at Omron’s election, to (i) replace (in the form originally
shipped with Buyer responsible for labor charges for removal or replacement thereof) the non-com-
plying Product, (ii) repair the non-complying 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 any other claims or expenses regarding the Products
unless Omron’s analysis confirms that the Products were properly handled, stored, installed and
maintained and not subject to contamination, abuse, misuse or inappropriate modification. Return
of any Products by Buyer must be approved in writing by Omron before shipment. Omron Compa-
nies shall not be liable for the suitability or unsuitability or the results from the use of Products in
combination with any electrical or electronic components, circuits, system assemblies or any other
materials or substances or environments. Any advice, recommendations or information given orally
or in writing, are not to be construed as an amendment or addition to the above warranty.
See http://www.omron.com/global/ or contact your Omron representative for published information.
Limitation on Liability; Etc
OMRON COMPANIES SHALL NOT BE LIABLE FOR SPECIAL, INDIRECT, INCIDENTAL, OR CON-
SEQUENTIAL DAMAGES, LOSS OF PROFITS OR PRODUCTION OR COMMERCIAL LOSS IN ANY
Terms and Conditions Agreement
14 NJ/NX-series Database Connection CPU Units User’s Manual (W527)

WAY 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 Product on
which liability is asserted.
Application Considerations
Suitability of Use
Omron Companies shall not be responsible for conformity with any standards, codes or regulations
which apply to the combination of the Product in the Buyer’s application or use of the Product. At Buy-
er’s request, Omron will provide applicable third party certification documents identifying ratings and
limitations of use which apply to the Product. This information by itself is not sufficient for a complete
determination of the suitability of the Product in combination with the end product, machine, system, or
other application or use. Buyer shall be solely responsible for determining appropriateness of the par-
ticular Product with respect to Buyer’s application, product or system. Buyer shall take application re-
sponsibility in all cases.
NEVER USE THE PRODUCT 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
PROPERLY RATED AND INSTALLED FOR THE INTENDED USE WITHIN THE OVERALL EQUIP-
MENT OR SYSTEM.
Programmable Products
Omron Companies shall not be responsible for the user’s programming of a programmable Product, or
any consequence thereof.
Disclaimers
Performance Data
Data presented in Omron Company websites, catalogs and other materials is provided as a guide for
the user in determining suitability and does not constitute a warranty. It may represent the result of
Omron’s test conditions, and the user must correlate it to actual application requirements. Actual per-
formance is subject to the Omron’s Warranty and Limitations of Liability.
Change in Specifications
Product specifications and accessories may be changed at any time based on improvements and oth-
er reasons. It is our practice to change part numbers when published ratings or features are changed,
or when significant construction changes are made. However, some specifications of the Product may
Terms and Conditions Agreement
15
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

be changed without any notice. When in doubt, special part numbers may be assigned to fix or estab-
lish key specifications for your application. Please consult with your Omron’s representative 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 responsibility is assumed for clerical, typographical or proofreading errors or omissions.
Terms and Conditions Agreement
16 NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Safety Precautions
Refer to the following manuals for safety precautions.
•NX-series CPU Unit Hardware User's Manual (Cat. No. W535)
•NX-series NX102 CPU Unit Hardware User’s 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 representative and check with the
product specification document or other documentation.
Safety Precautions
17
NJ/NX-series Database Connection CPU Units User’s Manual (W527)

Precautions for Safe Use
Refer to the following manuals for precautions for safe use.
•NX-series CPU Unit Hardware User's Manual (Cat. No. W535)
•NX-series NX102 CPU Unit Hardware User’s 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 sales representative and check with
the product specification document or other documentation.
Precautions for Safe Use
18 NJ/NX-series Database Connection CPU Units User’s Manual (W527)