4 Basic Operations and Status Check
4-2
NJ/NX-series Database Connection CPU Units User’s Manual (W527)
4-1 Run Mode of DB Connection Service
and Start/Stop Procedures
This section describes the Run mode of the DB Connection Service and start/stop procedures.
4-1-1 Run Mode of the DB Connection Service
The DB Connection Service has two Run modes, Operation Mode and Test Mode. You can
change the Run mode according to whether to actually access the DB.
This section describes the operations and usage of each Run mode of the DB Connection
Service.
Run Mode of the DB Connection Service
You can change the Run mode according to the purpose. In Test Mode, you can test the
operations of the DB Connection Service without connecting to the DB. In Operation Mode, you
can perform practical operation or trial operation by connecting to the DB.
Test Mode ï‚– SQL statements are not sent to the DB when
DB Connection Instructions are executed.
ï‚– DB Connection Instructions end normally.
However, the instructions for retrieving from
the DB do not output anything to the specified
DB Map Variable.
ï‚–
Spool function is disabled.
Operation check of
user program using
DB Connection
Instructions when the
DB is not connected.
When the DB does not
exist,
or
when the DB exists, but
not connected
Operation
Mode
ï‚– SQL statements are sent to the DB when DB
Connection Instructions are executed.
ï‚– Spool function is enabled.
Practical or trial
operation of the
system when the DB is
When the DB is connected
4-1-2 How to Start/Stop the DB Connection Service
You can use the following three methods to start or stop the DB Connection Service.
ï‚– Starting the service automatically when the operating mode of the CPU Unit is changed to RUN
mode.
ï‚– Starting/stopping the service by online operation from Sysmac Studio.
ï‚– Executing a DB_ControlService (Control DB Connection Service) instruction.
Please note that the Run mode of the DB Connection Service cannot be changed while the
service is running. To change the Run mode, you need to stop the DB Connection Service, and
then start the service again.