<< Click to Display Table of Contents >>

DB Initial/Final Query

Set Initial SQL to be executed immediately after DB connection and Final SQL to be executed immediately before DB disconnection.

Check the "Set query name" in the Add Database Connection Information dialog and enter the name. Then enter a Query statement and click the [Add] button.

To use the script query, Check the "Use Scripted Query".

Note

Query statement must be the standard SQL statement can be executed in JDBC. Also It must be a SQL statement(INSERT, UPDATE, DELETE) that does not support the result set. Query statements are executed in the order shown in the Query list.