For the SQL modules under the SQL interface, there are input modules and output modules.

An SQL module is either a reading module with an SQL query or a writing module with an SQL command. That is why the terms SQL query module and SQL command module are used in the following text as well.

A module cannot be both simultaneously. That is why there is also no SQL module that can be seen simultaneously in the I/O Manager on both tabs Inputs and Outputs.

However, the modules are very similar in their structure and components.

The following applies to all SQL modules:

• The SQL modules have a reference to a database connection in the SQL interface.

• The SQL modules contain an SQL statement (query or command).

• The SQL modules offer an assignment table for parameters used in the SQL statements.

• The SQL modules can work cyclically or triggered.