Manual > Server Creation Guide > Actions > Action Reference

How to read the manual

This chapter is for reference information only.

For construction procedures, please refer to "Executing SQL on the server side" in the monitoring system construction guide.

Features of this action

Issues a SQL command to the database.

The database is accessed via an ODBC driver.

c_action_0370

Action Settings

The settings for this action are explained below.

Action specifications
Parameters	none
dialog	■ODBC settings ▪Data Source Please refer to "ODBC Settings" in the common settings. ▪ODBCTimeout If necessary, set the timeout times for ODBC connections and Execute SQL. ▪SQL String Write the SQL statement. The syntax of the SQL command you write must conform to the specifications of the database you are connecting to. Example) DELETE FROM TABLE01; To specify a schema name, specify the schema before the table name, separated by a "." (schema name).[table name].

Action specifications

Parameters

none

dialog

■ODBC settings

c_action_0053

▪Data Source
Please refer to "ODBC Settings" in the common settings.

▪ODBCTimeout
If necessary, set the timeout times for ODBC connections and Execute SQL.

▪SQL String
Write the SQL statement. The syntax of the SQL command you write must conform to the specifications of the database you are connecting to.

Example) DELETE FROM TABLE01;

To specify a schema name, specify the schema before the table name, separated by a "." (schema name).[table name].

SQL statements registered in Execute SQL (ODBC) actions cannot be edited dynamically after going online. For example, if you need to issue more complex SQL commands, such as when you want to switch the contents of the SQL statements issued using some logic, you can use a script in the Script Ver2 action. For details, see "Accessing the DB from Script Ver2".

In the "Advanced Settings" tab, you can specify the timing for executing a script (SC1) before an action is executed, or the timing for adjusting the execution of the action (setting the execution wait time). For details on the advanced settings of each action, see "Settings on the Advanced Settings tab of an action".