5 Other Functions
5-9
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
5
5-2-6 How to Resend the SQL Statements Stored in the Spool Memory
5-2-6 How to Resend the SQL Statements Stored in the Spool
Memory
You can resend the SQL statements stored in the Spool memory automatically or manually,
which can be selected in the Resend Spool Data of the Spool Settings.
Auto Resend
The SQL statements stored in the Spool memory are automatically resent when the DB is
reconnected.
1. When communications are recovered (i.e. when
the DB is reconnected), SQL statements stored
in the Spool memory are automatically resent in
the spooling order.
Dedicated area for the Spool function
or EM Area (non-volatile memory)
Manual Resend
The SQL statements stored in the Spool memory are resent when a DB_ControlSpool
(Resend/Clear Spool Data) instruction is executed.
All of the SQL statements stored in the Spool memory are sent in the spooling order by one
execution of the DB_ControlSpool (Resend/Clear Spool Data) instruction.
DB Connection Instruction
1. When communications
are recovered (i.e.
when the DB is
reconnected), a
DB_ControlSpool
instruction is executed
to resend the SQL
statements stored in
the Spool memory.
2. SQL statements stored in the Spool
memory are resent in the spooling order.
Dedicated area for the Spool function
or EM Area (non-volatile memory)