Progress
SQL-92
Guide and Reference
Modifying SQL Explorer Properties
You can modify SQL Explorer properties in order to change how SQL Explorer behaves.
SQL Explorer property name strings do not contain blanks, and property names are case insensitive. To distinguish property names from other text, the names are presented here in mixed case. For example, the
autocommit
property is presented asAutoCommit
.AUTOCOMMIT
,autocommit
, or any mixed case combination is valid.Each property is available for both the character interface and the graphical interface, unless noted otherwise.
AutoCommit
Automatically commits all changes to the database when set to
true
.False
is the default.ColumnWidthLimit
Truncates the output column width when set less than the SQL column width. Default value is 25 characters. Increase the value to prevent truncating an output column that is greater than 25 characters.
ColumnWidthMin
Controls the minimum width of columns output to the bottom pane or standard output. Default value is 1.
ConnectTimeout
Allows you to specify the maximum number of seconds the SQL Explorer should wait when attempting to establish a connection, before terminating the connection request. The default value is 180 seconds.
DisableWarnings
Allows the SQL Explorer to send warning messages to the output screen. To enable the display of warning messages, change
DisableWarnings
from the default value oftrue
to the override setting offalse
.Echo
Prohibits Windows SQL Explorer from displaying output to the bottom pane when set to
false
. Default istrue
.FetchLimit
Specifies the maximum number of records to be retrieved from the database when the default value of 101 is increased or decreased. To disable the
FetchLimit
completely, set theHasFetchLimit
property tofalse
.HasFetchLimit
The
HasFetchLimit
property allows you to change the default value oftrue
to the override setting offalse
. This property is related to theFetchLimit
property. SettingHasFetchLimit
tofalse
allows you to disable the fetch limit completely, without requiring you to set an artificially highFetchLimit
.NOTE: Earlier releases of SQL Explorer enforced a fetch limit. The default for theFetchLimit
property remains at 101 records. SettingHasFetchLimit
tofalse
allows you to disable theFetchLimit
completely, without requiring you to set an artificially highFetchLimit
.Logfile
Allows you to change the name and/or location of the
Logfile
by setting theLogfile
property to the full path and filename of an alternate log file. The defaultLogfile
,SQLExplorer.log
is located in the current working directory.Logging
Logs all SQL statements and their output to the specified log file when set to
true
. Default value isfalse
.Pager
Allows you to change the default setting of
false
to the override value oftrue
. WhenPager
is set tofalse
, all of the output data is returned to the screen. When you choosetrue
, SQL Explorer returns the number of lines specified inPagerLimit
, which has a default value of 22 lines. You can then page up and down to review the output.The
Pager
andPagerLimit
properties are available in the character interface only. The graphical interface does not require these properties.PagerLimit
Allows you specify how many lines SQL Explorer displays on your screen. You can set this value to the maximum available display area on your screen, or to the number of lines you choose to use for output display. A typical setting is twenty-two lines. For
PagerLimit
to take effect, you must first set thePager
property totrue
. If thePager
property is set to the default value offalse
, SQL Explorer ignores thePagerLimit
property setting.ReportFormat
Allows you to override the standard format display for output data. Setting this property to
by label
directs SQL Explorer to return data in an alternative format. A single output line in theby label
format returns the record id, column name, and column value for one column in the result set.Reset propertyname propertyvalue
Resets the property settings to their original values. Enter
@reset
to reset all property values. You can also reset one or more specified properties by supplying the property name and the new property value.Run filename
Executes the specified file named. The file itself contains SQL-92 statements and SQL Explorer command statements (
@
and!
). Different applications may have different requirements for database operations, such as transaction isolation level or automatic commit operations. You can create a custom file for each application.Transaction
Sets the transaction isolation level to
COMMITTED READ
. The isolation levels specify the degree to which one transaction can modify data or database objects being used by a concurrent transaction. See the SET TRANSACTION ISOLATION LEVEL Statement and LOCK TABLE Statement in "SQL-92 Statements," for complete information on isolation levels. You can set the default to any of these values:useurl
Controls the format in which the Connect dialog box prompts users for database connection information in Windows SQL Explorer.
Character and Windows
EXAMPLESThe following example displays current property settings, for both character and Windows SQL Explorer:
This example displays the available options for setting properties, for both character and Windows SQL Explorer:
This is syntax for changing the value for a specific property, both in character and Windows SQL Explorer:
Windows Only
Follow these steps to change property settings for Windows SQL Explorer only:
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |