1 Introduction to the DB Connection Service
1-8
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Other Systems
The following figure shows the other systems of the DB Connection function.
abc
Data 1
Data 2
Data 3
Data 4
System-defined
variable (i)
When transmission failed (m)
Status of the DB
Connection Service (h)
Dedicated area for the Spool function
EM Area (non-volatile memory)
Errors and status of the DB
Connection Service
DB Connection Instruction
You can check the status of the DB Connection Service and each DB Connection
((h) in the above figure) with the DB_GetServiceStatus (Get DB Connection Service
Status) instruction, DB_GetConnectionStatus (Get DB Connection Status)
instruction, or a system-defined variable ((i) in the above figure).
Refer to 4 Basic Operations
and Status Check.
Errors and status of the DB Connection Service are stored as an event log. ((j) in the
Refer to 7 Troubleshooting.
The logs of tracing the operations of the DB Connection Service on the CPU Unit
(called “Operation Logs”) ((k) in the above figure) are saved as a log file ((l) in the
above figure) into the SD Memory Card mounted in the CPU Unit.
Refer to 6 How to Use
Operation Logs.
When transmission of an SQL statement failed, the SQL statement is automatically
saved into the dedicated area for the Spool function for an NX-series Controller and
the EM Area for an NJ-series Controller. ((m) in the above figure)
When the communications are recovered, the stored SQL statement is resent
automatically or by executing an instruction. ((n) in the above figure)
Refer to 5-2 Spool Function.