Omron NX701-1620 User Manual

Appendix A
A-4
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Output variable
Meaning Data type Description
Member
FailedCnt Number of Error
Executions
DINT Number of times when an SQL statement
execution failed in the DB Connection.
DBRespTime DB Response
Time
TIME Time since an SQL statement is sent from the
CPU Unit until the SQL execution result is
returned from the CPU Unit when an SQL
statement is executed.
This is stored only when a normal response is
returned from the DB. If an instruction execution
timeout occurred, the DB Response Time is not
stored when the instruction execution is
completed (i.e. when the Error output variable
changes from FALSE to TRUE). (The previous
DB Response Time is held.) The new DB
Response Time is stored when a normal
response is returned from the DB after the
instruction execution timeout.
SpoolDataCnt Number of Spool
Data
INT Number of SQL statements stored in the Spool
memory for the DB Connection.
SpoolUsageRate Spool Usage SINT Use rate of the Spool memory for the DB
Connection. The unit is percentage (%).
ErrorDateTime Disconnection
Date/Time
DATE_AND_TIME Date and time the last time the connection was
disconnected due to an error.
SQLSTATE SQL Status STRING(8) Error code
*2
defined in SQL Standards (ISO/IEC
9075) for disconnection
*1
ErrorCode Error Code DINT Error code
*2
for disconnection
*1
, which is specific
to DB vendor
ErrorMsg Error Message STRING(128) Error message
*2
for disconnection
*1
, which is
specific to DB vendor
*1 When a network failure or an SQL Execution Error occurred
*2 The value may differ by unit version of the CPU Unit.
The value of connection error to SQL Server was changed in the unit version 1.08 of the CPU Units.
 SendStatus
Output variable
Meaning
Data type
Description
SendStatus Send Status _eDBC_SEND_STATUS Enumeration data type that shows transmission status
of the SQL statement to DB
_DBC_SEND_INIT(0): Initial status
_DBC_SEND_UNSENT(1): SQL statement unsent
_DBC_SEND_SENDING(2): Sending SQL statement
_DBC_SEND_SPOOLED(3): SQL statement spooled
_DBC_SEND_COMPLETE(4):
SQL statement transmission completed

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English