Result Management
This section describes how to customize the settings in the Query Results pane, including the column width, number of records to be obtained, and copy of column headers or row numbers.
- Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
- Choose Result Management > Query Results.
The Query Results pane is displayed.
- Select the required option.
The options of configuring the column width are as follows.
Option
Outcome
Content Length
You can set the column width based on the content length of the query result.
Custom Length
You can customize the column width.
NOTE:This value ranges from 100 to 500.
- Click OK.
Click Restore Defaults in Query Results to restore the default value. The default value is Content Length.
Set the number of records to be obtained in the query results:
- Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
- Choose Result Management > Query Results.
The Query Results pane is displayed.
- Select the required option.
Option
Outcome
Fetch All records
You can obtain all records in the query results.
Fetch custom number of records
You can set the number of records to be obtained in the query results.
NOTE:This value ranges from 100 to 5000.
- Click OK.
Click Restore Defaults in Query Results to restore the default value. The default value is Fetch custom number of records (1000).
Copy column headers or row numbers from query results:
- Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
- Choose Result Management > Query Results.
The Query Results pane is displayed.
- Select the required option.
Option
Outcome
Include column header
You can copy column headers from the query results.
Include row number
You can copy the selected content along with the row number from the query results.
- Click OK.
Click Restore Defaults in Query Results to restore the default value. The default value is Include column header.
Determine how the result set window is opened:
- Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
- Choose Result Management > Result Window.
- Select the required option.
Option
Outcome
Overwrite Resultset
After an opened result set window is closed, a new result set window will be opened.
Retain Current
After a new result set window is opened, the opened result set windows are not closed.
- Click OK.
Edit Table Data
Perform the following steps to determine the data saving mode:
- Choose Settings > Preferences from the main menu. The Preferences dialog box is displayed.
- Choose Result Management > Edit Table Data. The Edit Table Data pane is displayed.
Select the required option:
Table 1 Editing table data Database Type
Auto Commit
Reuse Connection
Table Data Save Option
Behavior
GaussDB(DWS)
ON
ON
Save Valid Data
Only the valid data will be saved and committed.
ON
ON
Do Not Save
No data will be saved when an error occurs.
ON
OFF
Save Valid Data
Only the valid data will be saved and committed.
ON
OFF
Do Not Save
No data will be saved when an error occurs.
OFF
ON
Save Valid Data
No data will be saved when an error occurs. Execute the COMMIT or ROLLBACK statement to save data.
OFF
ON
Do Not Save
No data will be saved when an error occurs. Execute the COMMIT or ROLLBACK statement to save data.
- Click OK.
Click Restore Defaults in Edit Table Data to restore the default value. The default value is Save Valid Data.
Result Data Encoding
Perform the following steps to
configure whether data encoding type is displayed in the Query Results, View Table Data, and Edit Table Data panes.
- Choose Settings > Preferences from the main menu.
The Preferences dialog box is displayed.
- Choose Result Management > Query Results.
The Query Results pane is displayed.
- Select Include result data encoding to display the Encoding drop-down list in the Query Results, View Table Data, and Edit Table Data panes.
- Click OK.
- Click Restore Defaults in Result Management to restore the default value. Include result data encoding will be unselected by default.
- To make the change take effect, you need to edit a table, view table properties, or execute a query again.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
