Datasheet
11
Sysmac Studio
Function Specifications of DB Connection Function
Note: The DB connection service can be used if the NJ501-1@20 is selected with Sysmac Studio version 1.06 or higher.
The DB connection service can be used if the NJ101-@@20 is selected with Sysmac Studio version 1.14 or higher.
Function Specifications of EtherNet/IP Connection Settings
Note: Supported only by the Sysmac Studio version 1.10 or higher.
Function Specifications of EtherNet/IP Slave Terminal Settings
Note: Supported only by the Sysmac Studio version 1.11 or higher.
Item Function
Setting parameters −
DBMS settings The database to connect is selected.
Run mode setting of the DB connection
service
The Operation Mode is selected to send SQL statements when DB connection instructions are executed
or Test Mode is selected to not send SQL statements when DB connection instructions are executed.
Spooling settings
You can set the service so that SQL statements are spooled when problems occur and resent when
operation is restored.
Operation log settings
Settings are made for the execution log for execution of the DB connection service, the debug log for
execution of SQL statements for the DB connection service, and the SQL execution failure log for SQL
execution failures.
Database connection service shutdown
settings
Settings are made to control operation in order to end the DB connection service after automatically
storing the operation log files on an SD Memory Card.
Programming DB connection instructions
You can use the following DB connection instructions to write the user program for controlling the data in
the database.
DB_Insert (Insert DB Record), DB_Select (Retrieve DB Record), DB_Update (Update DB Record), and
DB_Delete (Delete DB Record)
Monitoring information −
Monitoring the DB connection service The status of the DB connection service is monitored.
Monitoring the DB connections The status of each DB connection is monitored.
Displaying the operation logs The contents of the execution log, debug log, and SQL execution failure log are displayed.
Item Function
EtherNet/IP Connection Settings Functions related to tag data link (connection) settings in the EtherNet/IP network are provided.
Setting
Connections
Editing Tag Sets You create tags and tag sets using network variables.
Editing Target Devices You add target devices to connect to.
Editing Connections You select tag sets from a list and create connections.
Adding EDS Files You can add the types of EtherNet/IP devices that can be set as targets.
Transferring
Connections
Synchronized Transfer and
Batch Transfer
All the connection settings in the Controller or the project are transferred at the same time.
Individual Transfer and
Comparison
You can transfer or compare the connection settings of each EtherNet/IP device individually.
Monitoring
Connections
Status Monitor
The operating status of one or more connections is displayed. You can start or stop all the connections
at the same time.
Tag/Tag Set Monitor
The detailed operation information of tags and tag sets, such as the presence or absence of tags and
connection times of tag sets, is displayed.
Ethernet Information
Monitor
The detailed operation information of EtherNet/IP devices, such as bandwidth usage (pps), is displayed.
Item Function
EtherNet/IP Slave Terminal Configuration and Setup
You create the configuration of Slave Terminal to be connected to the EtherNet/IP network on the Sysmac
Studio and set the NX Units that compose the Slave Terminal.
Registering the NX Units
You configure the Slave Terminal by dragging the NX Units from the device list displayed in the Toolbox
to the positions where to mount the Units.
Setting the NX Units You edit the I/O allocation settings, mounting settings and Unit operation settings of the NX Units.
Displaying the Width of Slave Terminal
Configuration
The width of the Slave Terminal configuration is displayed based on the Unit configuration information.
Comparing and Merging the Slave Terminal
Configuration Information
You can compare the configuration information on the project with actual configuration online, select the
Units with different information to correct, and merge the information.
Transferring the Slave Terminal
Configuration Information
You transfer the Unit configuration information to the Slave Terminal.