Checking the execution results
It describes how to check the result of SQL execution.
DBMS Output
The DBMS Output tab displays SQL execution result messages, error messages, and response time. In addition, the following operations can be performed.
Clear
Deletes all output messages.
Save as File
Saves the output message to a file.
Find
Finds the desired text via the Find menu in the context.
Statistics
The Statistics tab is created only when the users run a Task that contains DML statements except SELECT statements, and they can check the statistics of the Task's execution results. The users can view the following information in Statistics.
Query Count
The number of SQL included in the Task
Updated Rows
The number of rows added, modified, or deleted due to DML.
Execute Time
Time spent on execution (ms)
Fetch Time
Time spent on fetching data (ms)
Start Time
The time to execute Task
Finish Time
The time to end Task
Result
The users can view the execution result of the SELECT statement. For a detailed description of the features, refer to [Manipulating Result]](control-result-data.md).
On the Result tab, The users can view the following information.
Executed SQL
Executed SQL
Column list
The list of columns in the viewed object
Value list
The list of values in the viewed object
Row per page
The number of rows to display on a page
Page Number
The current page number
Execution Information
The number of Rows Fetched from Database - Execution Time (ms), on SQL Execution Time
Error
1. Check an error on the Result Tab
The users can check the error message on the Result Tab, and run the highlighting of the SQL where the error occurred by clicking the 
button.
2. Check an error in Editor
The red underline is displayed in the SQL area where the error occurred, and the detailed error message is displayed in the form of a tooltip when the cursor is placed on it.
3. Error for multiple SQL operations
When an error occurs during multiple SQL operations, the users can manage whether to add more operations in the dialog.
Applicable to Only this Error
After checking the error for this SQL, the next SQL will be run normally.
Applicable to All Same Errors
Based on the JDBC error number, skip all errors that are the same as this error.
Applicable to All Errors
Skips all errors.
Stop Running Task
Stops the currently running Task from running.
Last updated