Home
Omron
Controller
NX701-1620
Omron NX701-1620 User Manual
5
of 1
of 1 rating
306 pages
Give review
Manual
Specs
To Next Page
To Next Page
To Previous Page
To Previous Page
Loading...
Appendix A
A-
24
NJ/NX-series Database Connection CP
U Units User’s Manual
(W527)
Sample Programming
- Establish a DB Connection named M
yDatabase1 and map a table
with a variable.
Check the completion of DB_Connec
t and DB_CreateMapping instr
uctions.
DB_Creat
eMap
ping_U
pdate_i
nstanc
e.Done
Operati
ngEnd_
Conne
ct
DB_
Conne
ct_instanc
e.Er
ror
DB_
Creat
eMappi
ng
_
Insert
_
instance.E
rror
DB_
Creat
eMappi
ng
_
Updat
e_ins
tance.
Error
Accept the trigger for establishi
ng the DB Connection.
Trigger_Con
nect
Operati
ng_Co
nnect
_DBC_Status.Run
RS_Conne
ct_i
nstance
Operati
ngEnd_
Conne
ct
Set
Reset1
RS
Q1
Establish the DB Connection nam
ed MyDatabase1.
Operati
ng_Co
nnect
DB_Conne
ct_i
nstance
‘
MyDatabas
e1
’
Execute
DBConnec
tionN
ame
DB_Conne
ct
Done
Busy
Error
Error
ID
DBConnec
tion
MyD
B1
Map the variable
MapVar_Insert
to the table
Production
of the DB Co
nnection
MyDB
1
for the INSER
T operation.
DB_Connect_instance.Done
DB_CreateMapping
_
Insert_
instance
MyDB
1
‘
Production
’
MapV
ar_
Insert
_DB
C_SQL
TYPE_INSERT
Execute
DBConnection
T
ableName
MapV
ar
SQL
Ty
pe
DB_CreateMapping
Done
Busy
Error
ErrorID
211
213
Table of Contents
Default Chapter
2
Nx701
2
Introduction
3
Intended Audience
3
Applicable Products
3
Nj501
3
Relevant Manuals
4
Manual Structure
5
Page Structure
5
Special Information
6
Precaution on Terminology
6
Sections in this Manual
7
Table of Contents
8
Contents
9
Terms and Conditions Agreement
13
Warranty, Limitations of Liability
13
Application Considerations
14
Disclaimers
14
Safety Precautions
16
Nj501
16
Precautions for Safe Use
17
Precautions for Correct Use
18
Nj101
18
Regulations and Standards
19
Conformance to EU Directives
19
Conformance to KC Standards
20
Conformance to Shipbuilding Standards
20
Software Licenses and Copyrights
20
Versions
21
Unit Versions
21
Version Types
21
Checking Versions
21
Unit Versions of CPU Units and Sysmac Studio Versions
24
Related Manuals
25
Nj101
25
Terminology
27
Revision History
28
W527-E1
28
1 Introduction to the DB Connection Service
29
Overview and Features
30
Overview
30
Features
31
DB Connection Service Specifications and System
32
DB Connection Service Specifications
32
DB Connection System
35
Operation Flow of the DB Connection Service
37
2 DB Connection Settings
37
Starting Sysmac Studio and Creating a New Project
42
Starting Sysmac Studio
42
Creating a New Project
42
Setting the Built-In Ethernet/Ip Port
44
Controller Setup
44
DB Connection Settings
45
DB Connection Service Settings
45
DB Connection Settings
48
3 Programming the DB Connection Function
53
DB Access Procedure
54
Creating a Structure Data Type
55
Overview
55
Specifications of Structure Data Type for DB Access
55
How to Create a Structure Data Type for DB Access
64
Creating a DB Map Variable
67
DB Map Variables and DB Mapping
67
Registration and Attributes of DB Map Variables
68
Restrictions on DB Map Variables
69
Specifying the Table and Applying the Mapping
70
DB Mapping by Executing a Create DB Map Instruction
70
Clearing the Mapping of DB Map Variables
70
Restrictions on DB Mapping
71
Programming and Transfer
74
Programming the DB Connection Service
74
Displaying DB Connection Instructions on Sysmac Studio
75
DB Connection Instruction Set
76
System-Defined Variables
77
Simulation Debugging of DB Connection Instructions
78
Transferring the DB Connection Settings and User Program
78
Debugging in Design, Startup, and Operation Phases
79
Design Phase
79
Startup Phase
79
Operation Phase
79
4 Basic Operations and Status Check
81
Run Mode of DB Connection Service and Start/Stop Procedures
82
Run Mode of the DB Connection Service
82
How to Start/Stop the DB Connection Service
82
DB Connection Service Is Stopped or Cannot be Started
84
Changing the Run Mode of the DB Connection Service
85
Establishing/Closing a DB Connection
86
Checking the Status of DB Connection Service and each DB Connection
87
Operation Status of the DB Connection Service
87
Checking the Status of the DB Connection Service
88
Connection Status of each DB Connection
91
Checking the Status of each DB Connection
92
5 Other Functions
95
Examples of Using Functions
96
Spool Function
98
Overview
98
Spooling System
98
Applicable Instructions and Spooling Execution Conditions
98
Memory Area Used by the Spool Function
100
Spool Function Settings
102
How to Resend the SQL Statements Stored in the Spool Memory
103
Clearing the SQL Statements from the Spool Memory
104
Relationship with the DB Connection Instructions
106
How to Estimate the Number of SQL Statements that Can be Spooled
108
DB Connection Service Shutdown Function
109
Overview
109
Shutdown System
110
How to Execute the Shutdown Function
110
How to Check the Shutdown of the DB Connection Service
111
How to Prevent Losing SQL Statements at Power Interruption
112
Overview
112
Procedures
112
Timeout Monitoring Functions
116
Login Timeout
117
Query Execution Timeout
117
Communications Timeout
118
Instruction Execution Timeout
118
Keep Alive Monitoring Time
118
Other Functions
120
Backup/Restore Function in the DB Connection Service
120
Operation Authority Verification in the DB Connection Service
122
6 How to Use Operation Logs
123
Operation Logs
125
Execution Log
126
Overview
126
Application Procedure
126
Setting the Execution Log
127
Checking the Execution Log
127
Execution Log File Specifications
127
Debug Log
132
Overview
132
Application Procedure
132
Setting the Debug Log
133
Starting Recording to Debug Log
134
Stopping Recording to Debug Log
135
Checking the Debug Log
136
Debug Log File Specifications
136
SQL Execution Failure Log
140
Overview
140
Application Procedure
140
Setting the SQL Execution Failure Log
140
Checking the SQL Execution Failure Log
141
SQL Execution Failure Log File Specifications
141
SD Memory Card Operations
144
Saving Operation Log Files on SD Memory Card
144
Directory Used for DB Connection Service
144
Operation Log Operations in Replacing the SD Memory Card
145
Guidelines for SD Memory Card Replacement Time
145
Replacement Timing of SD Memory Card
146
Checking the Operation Logs
147
How to Check the Operation Logs
147
Checking the Log on the Operation Log Window in Sysmac Studio
147
Checking the Log with the SD Memory Card
149
Checking the Log by Transfer Using FTP Client Software
149
7 Troubleshooting
151
Overview of Errors
152
How to Check for Errors
153
Errors Related to the DB Connection Service
155
Troubleshooting
157
Error Table
157
Error Descriptions
165
Appendix A DB Connection Instructions and Variables
190
A-1-1 DB Connection Instruction Set
190
DB Connection Instruction Set
190
A-1-2 Variables Used in the DB Connection Instructions
191
Variables Used in the DB Connection Instructions
191
Db_Connect (Establish DB Connection
194
Db_Close (Close DB Connection
197
Db_Createmapping (Create DB Map
199
Db_Insert (Insert DB Record
202
Db_Update (Update DB Record
206
Db_Select (Retrieve DB Record
222
Db_Delete (Delete DB Record
227
Db_Controlservice (Control DB Connection Service
242
Db_Getservicestatus (Get DB Connection Service Status
248
Db_Getconnectionstatus (Get DB Connection Status
253
Db_Controlspool (Resend/Clear Spool Data
259
Db_Putlog (Record Operation Log
266
Db_Shutdown (Shutdown DB Connection Service
272
Appendix B
277
Task Design Procedure
278
Startup Time of DB Connection Service
278
Reference Values for Execution Time of DB Connection Instructions
280
Instructions
280
B-1-3 How to Measure Execution Time of DB Connection Instructions
283
How to Measure Execution Time of DB Connection Instructions
283
Guideline for System Service Execution Time Ratio
284
B-1-5 Checking the System Service Execution Time Ratio
285
Execution Time of DB Connection Instructions
287
Restrictions to Execution Time of DB Connection Instructions
287
B-1-2 Reference Values for Execution Time of DB Connection Instructions
287
Impact of Operation Log Recording on Execution Time of DB Connection Instructions
293
How to Measure DB Response Time
294
Instruction Execution Timeout
295
B-2-4 Ensuring Equipment Performance (Takt Time) by Monitoring Instruction Execution Timeout
295
Specifications
296
General Specifications
296
Performance Specifications
296
Function Specifications
296
B-3 Specifications
296
Version Information
297
Unit Versions and Corresponding DB Connection Service Versions
297
DB Connection Functions that Were Added or Changed for each Unit Version
297
B-4-3 Actual Unit Version of CPU Unit and Unit Version Set in the Sysmac Studio Project
298
Sysmac Studio Project
299
5
Based on 1 rating
Ask a question
Give review
Questions and Answers:
Need help?
Do you have a question about the Omron NX701-1620 and is the answer not in the manual?
Ask a question
Omron NX701-1620 Specifications
General
Brand
Omron
Model
NX701-1620
Category
Controller
Language
English
Related product manuals
Omron NX701-1
448 pages
Omron NX701-1720
578 pages
Omron NX-ID
430 pages
Omron NX Series
464 pages
Omron NX-SID800
492 pages
Omron NX-EC0142
468 pages
Omron NX-SL3300
626 pages
Omron NX-PG0122
468 pages
Omron NX-PG0112
468 pages
Omron NX-SL5500
626 pages
Omron NX1P2 series
340 pages
Omron NX102 series
256 pages
To Next PageTo Next PageTo Previous PageTo Previous Page
Loading...
Need help?
General
