Omron NX701-1620 User Manual

5 Other Functions
5-5
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
5
5-2-3 Applicable Instructions and Spooling Execution Conditions
5-2 Spool Function
Spooling Execution Conditions
SQL statements are spooled in the following cases.
 When an applicable instruction is executed, the SQL statement cannot be sent due to a network
failure.
 When an applicable instruction is executed, the response from the DB cannot be received due
to a network failure.
 When an applicable instruction is executed, the DB is stopped due to a server’s problem or
other causes.
 When an applicable instruction is executed, one or more SQL statements are already stored in
the Spool memory.
 When an applicable instruction is executed, a DB Connection Instruction Execution Timeout
occurs.
Precautions for Correct Use
 The following error codes are applicable to the spooling execution conditions when the
instructions end in an error. When the instructions end in an error with other error codes,
the SQL statement is not stored in the Spool memory.
3011 hex: DB Connection Disconnected Error Status
3012 hex: DB Connection Instruction Execution Timeout
3014 hex: Data Already Spooled
3016 hex: DB in Process
 If an instruction error (SQL Execution Error) occurs, the transmitted SQL statement itself
can be the cause of the SQL Execution Error. Therefore, the SQL statement is not stored
in the Spool memory because the SQL Execution Error may occur again when the SQL
statement is resent.
 Even if a response cannot be received from the DB, the transmitted SQL statement may
have been processed in the DB.

Omron NX701-1620 Specifications

General

Brand	Omron
Model	NX701-1620
Category	Controller
Language	English