The following list describes the preferences you can set in the DB Navigator Preferences page:
| Preview row limit | Specifies the number of rows to return in the Preview tab folder. The recommended range is 1- 100. The default is 80. |
| SQL Results row limit | Specifies the number of rows to return after execution of SQL Select statements. The recommended range is 100 - 5000. The default is 2000. |
| SQL Results rows to batch | Specifies the number of rows to batch when retrieving records. The default is 100. |
| SQL Editor separator | Specifies the separator to use for separating multiple SQL statements. The default is a semicolon. |
| Auto commit | Determines the default
AutoCommit mode for a connection. If you select the Auto
commit option in the DB Navigator preferences,
AutoCommit is selected by default for each SQL connection profile.
(You can, however, select or deselect
AutoCommit for any connection profile
individually.) When you select AutoCommit,
all executed SQL statements that update the database are
automatically committed. If you do not select
AutoCommit, you must manually commit
all transactions by either clicking the
Commit button in the Connections view or issuing
a COMMIT statement.
Note: You see the Auto
commit option only if you do not have the
Auto-Login on connect option
selected for the connection profile.
|
| Commit On Close | Specifies that commit is performed on closing of the connection. You can enable this option only if the AutoCommit option is not selected. |
| Columns auto-completing assistance | Enables auto-completion for columns within the SQL Editor. If this option is not selected, columns are available in the auto-completion pop-up only if the column's table node has been expanded. Be aware that auto-completion can slow performance during connection. |
| Save and restore last selected node in Database Structure View | Saves the last selected node in the DB Structure view, then expands and selects the saved node when the connection is restarted. |
| Append table name to column | Causes the table name to be appended when column names are pasted to the clipboard (for example, Customer.Name). |
| Enclose in quotes | Causes quotes to be added to column names, table names, or schema
when copied to the clipboard (for example, "CustNum", "Name") when
generating SQL
select statements or creating a table script.
Note: Column names that contain leading underscores (for
example, _Buffer-ID) must be enclosed by quotes. Otherwise, the
SQL Editor does not recognize them.
|
| Delimiter | Specifies the character used as a delimiter when multiple objects are copied to the clipboard. |
| Show catalog or Show schema | If Show catalog is selected and the
database supports catalogs, then all catalogs are listed beneath the
root node and all objects per catalog (tables, views, etc.) are
grouped together. If Show schema is selected,
all of the schemas are listed beneath the root node. Note: When you
change from one preference to the other, you must refresh the DB
Structure view, or close and reopen the
connection.
|