Omron NX701-1620

Appendix A
A-72
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Related System-defined Variables
Name
Meaning
Data type
Description
_EIP_EtnOnlineSta Online BOOL Status of the communications function of
the built-in EtherNet/IP port.
TRUE: Can be used.
FALSE: Cannot be used.
Related Error Codes
Error code
Meaning
Description
0400 hex Input Value Out of Range A value that is not defined as an enumerator was specified in the Cmd
input variable.
041D hex Too Many Instructions Executed at the
Same Time
More than 32 DB Connection Instructions were executed at the same
time.
3000 hex DB Connection Service not Started The Resend Spool Data operation was executed by this instruction
when the DB Connection Service was not running.
3002 hex DB Connection Service Shutdown or
Shutting Down
The instruction was executed after the DB Connection Service was
shut down or while the DB Connection Service was being shut down.
3008 hex Invalid DB Connection The value of the DBConnection input variable is invalid or the specified
DB Connection is already closed.
300B hex SQL Execution Error The executed SQL statement resulted in an error in the DB.
3011 hex DB Connection Disconnected Error Status The DB Connection Service cannot communicate with the DB due to a
network failure or other causes.
3013 hex DB Connection Service Error Stop The instruction was executed while the DB Connection Service was
stopped due to an error.
3015 hex DB Connection Service Initializing The instruction was executed while the initialization processing of the
DB Connection Service was in progress.
Function
This instruction is used to resend or clear the SQL statements stored in the Spool memory for the DB Connection
specified in the DBConnection input variable.
When you select manual resend for Spool data, the SQL statements stored in the Spool memory are resent by
executing this instruction.
Precautions for Correct Use
 Execution of this instruction is continued until processing is completed even if the value of Execute changes to
FALSE or the execution time exceeds the task period. The value of Done changes to TRUE when processing
is completed. Use this to confirm normal completion of processing.
 When you execute this instruction to resend the Spool data, this instruction just starts the Spool data resending
processing. When the value of the Done output variable changes to TRUE, the resending processing of the
SQL statements stored in the Spool memory has not been completed. Confirm the completion of resending
processing by reading the number of Spool data using the DB_GetConnectionStatus instruction.
 When the Spool function is not enabled, this instruction will be completed normally without executing the
resend or clear processing of the SQL statements stored in the Spool memory.
 The Clear Spool Data operation can be executed even when the DB Connection Service is not running.
 Refer to Using this Section of the NJ/NX-series Instructions Reference Manual (Cat. No. W502) for a timing
chart for Execute, Done, Busy, and Error.
 This instruction cannot be used on an event task. A compiling error will occur.