was in progress
When the instruction was executed while the DB Connection Service was stopped due to an error
When the instruction was executed after the DB Connection Service was shut down or while the DB
Connection Service was being shut down
When the value of the DBConnection input variable is invalid or the specified DB Connection is
already closed
When the variable specified in the MapVar input variable has not been mapped by a
DB_CreateMapping instruction.
When the value of the Timeout input variable is outside the valid range
When the executed SQL statement resulted in an error in the DB
When the combination of data types is not listed in the table of data type correspondence between
NJ/NX-series Controllers and database and the data type cannot be converted
When the DB Connection Service cannot communicate with the DB due to a network failure or other
causes
When one or more SQL statements are already stored in the Spool memory
When the SQL statement cannot be spooled because the Spool capacity is exceeded
When the instruction was not completed within the time specified in the TimeOut input variable
When the instruction was executed before completion of the DB’s processing for the DB Connection
Instruction Execution Timeout that occurred for the previous DB_Insert, DB_Update, DB_Select, or
DB_Delete instruction
When more than 32 DB Connection Instructions were executed at the same time
Sample Programming
Refer to the sample programming that is provided for the DB_Update instruction.