Omron NX701-1620 User Manual

Appendix A
A-3
A
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
A-1-2 Variables Used in the DB Connection Instructions
This section describes the details of the variables used in the DB Connection Instructions.
Common Input and Output Variables Used in the DB Connection Instructions
 DBConnection
Input variable
Meaning
Data type
Description
DBConnection DB Connection DWORD DB Connection output from a DB_Connect instruction.
The instructions are executed for a specified DB Connection.
 ServiceStatus
Output variable
Meaning Data type Description
Member
ServiceStatus DB Connection
Service Status
_sDBC_SERVICE_STATUS Structure to show the status of the DB
Connection Service.
Status Service Status _eDBC_STATUS Enumeration data type to show the
service status
_DBC_STATUS_IDLE(0): Idle
_DBC_STATUS_RUNNING(1):
Running in Operation Mode
_DBC_STATUS_TEST(2):
Running in Test Mode
DebugLog Debug Log Flag BOOL TRUE while the Debug Log is recorded.
FALSE while recording to the Debug Log
is stopped.
OperatingTime Operating Time TIME Time elapsed since the service was
started.
ExecCnt Number of Normal
Executions
DINT Total number of times in all connections
when an SQL statement was normally
executed.
FailedCnt Number of Error
Executions
DINT Total number of times in all connections
when an SQL statement execution failed.
SpoolDataCnt Number of Spool
Data
DINT Number of SQL statements stored in the
Spool memory in all connections.
 ConnectionStatus
Output variable
Meaning Data type Description
Member
ConnectionStatus DB Connection
Status
_sDBC_CONNECTION
_STATUS
Structure to show the status of a DB Connection.
Status Connection Status _eDBC_CONNECTION
_STATUS
Enumeration data type to show the status of a
DB Connection
_DBC_CONNECTION_STATUS_CLOSED(0):
Closed
_DBC_CONNECTION_STATUS_CONNECTED(1):
Connected
_DBC_CONNECTION_STATUS_DISCONNECTED(2):
Disconnected (Disconnected due to a network
failure while the DB is connected.)
ConnectedTime
Connected Time
TIME
Total time when the DB is connected.
DisconnectedTime Disconnected
Time
TIME Total time when the DB is disconnected due to
an error.
ExecCnt Number of Normal
Executions
DINT Number of times when an SQL statement was
executed normally in the DB Connection.
A-1 DB Connection Instructions and Variables
A-1-2 Variables Used in the DB Connection Instructions

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English