5 Other Functions
5-20
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
Resend Flow by User Program
Write the user program to re-execute the instruction that is being executed at the time of power
interruption. The resend flow differs by whether a DB_Insert or DB_Update instruction is being
executed at the time of power interruption.
When a DB_Insert instruction is being executed
DB_CreateMapping
instruction
Create a DB Map Variable
(for DB record check)
Retrieve records from the DB
using information of the SQL statement
being sent at power interruption as
retrieval condition
Resend processing
required?
Create a DB Map Variable
(for resend)
Re-execute the DB_Insert
instruction
DB_CreateMapping instruction
Read output parameters
of Busy
and SendStatus output variables
Change the output parameters of Busy and
SendStatus output variables to initial values
Establish a DB Connection
1st cycle of the
operation
?
Values of output
parameter
s of Busy and
SendStatus
output
variables?
Resend processing required
Resend processing not required
Already reflected into
the DB?
(Records retrieved?)
Busy = TRUE and
SendStatus = _DBC_SEND_
SENDING