If a Failure Occurred in Information Exchange with the DB when Resending the
SQL Statements
If a failure occurred again when the SQL statements stored in the Spool memory are resent, the
unsent SQL statements are kept in the Spool memory. The SQL statements are resent again by
auto resend or manual resend. The resend order is not changed.
5-2-7 Clearing the SQL Statements from the Spool Memory
The SQL statements are cleared from the Spool memory in the following cases.
ï‚– When the specified clear condition is met.
ï‚– When a DB_ControlSpool (Resend/Clear Spool Data) instruction is executed
ï‚– When the Clear Spool Data operation is executed from Sysmac Studio
ï‚– When the automatic clear condition is met
When the Specified Clear Condition is Met
When Auto is selected for Resend Spool Data in the Spool Settings, you can set the condition for
clearing the SQL statements from the Spool memory for each DB Connection in Clear condition
under DB Connection Settings - Spool Settings on Sysmac Studio.
Select from the following options.
When DB connection
established
The SQL statements are cleared from the Spool memory when the DB Connection is
established (i.e. when the status changes from Closed to Connected).
If you select this option, the SQL statements are cleared from the Spool memory without
When a DB_ControlSpool (Resend/Clear Spool Data) Instruction is Executed
You can clear the SQL statements from the Spool memory by executing a DB_ControlSpool
(Resend/Clear Spool Data) instruction.
To Next Page
Loading...
Need help?
General
