Try OpenEdge Now
skip to main content
Online Help
Introducing Progress DB Navigator : Reference : Preferences : DB Navigator preferences
DB Navigator preferences
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.
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.