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 as AutoCommit. 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 of true to the override setting of false.

Echo

Prohibits Windows SQL Explorer from displaying output to the bottom pane when set to false. Default is true.

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 the HasFetchLimit property to false.

HasFetchLimit

The HasFetchLimit property allows you to change the default value of true to the override setting of false. This property is related to the FetchLimit property. Setting HasFetchLimit to false allows you to disable the fetch limit completely, without requiring you to set an artificially high FetchLimit.

NOTE: Earlier releases of SQL Explorer enforced a fetch limit. The default for the FetchLimit property remains at 101 records. Setting HasFetchLimit to false allows you to disable the FetchLimit completely, without requiring you to set an artificially high FetchLimit.

Logfile

Allows you to change the name and/or location of the Logfile by setting the Logfile property to the full path and filename of an alternate log file. The default Logfile, 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 is false.

Pager

Allows you to change the default setting of false to the override value of true. When Pager is set to false, all of the output data is returned to the screen. When you choose true, SQL Explorer returns the number of lines specified in PagerLimit, which has a default value of 22 lines. You can then page up and down to review the output.

The Pager and PagerLimit 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 the Pager property to true. If the Pager property is set to the default value of false, SQL Explorer ignores the PagerLimit 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 the by 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
EXAMPLES

The following example displays current property settings, for both character and Windows SQL Explorer:

SQLExplorer> @show ;
 
 
Option values are:
     autocommit false
     columnwidthlimit 25
     columnwidthmin 1
     connecttimeout 180
     disablewarnings true
     echo true
     escapetimeout 15
     fetchlimit 101
     hasfetchlimit true
     logging false
     logfile .\SQLExplorerSession.log
     reportformat standard
     run <sqlFilename>
     transaction 3: Serializable
     useurl false; 

This example displays the available options for setting properties, for both character and Windows SQL Explorer:

SQLExplorer> @help ;
 
 
Available options include:
     @help
     @autocommit {true|false}
     @columnwidthlimit <numericValue>
     @columnwidthmin <numericValue>
     @connecttimeout <numericValue>
     @disablewarnings {true|false}
     @echo {true|false}
     @escapetimeout <numericValue>
     @fetchlimit <numericValue>
     @hasfetchlimit {true|false}
     @logging {true|false}
     @logfile "<logfilename>"
     @reportformat { standard | by label }
     @reset < property_name property_value>
     @run <file_name>
     @show options
     @transaction { 0 | 1 | 2 | 3 }
          - or -
     @transaction { Uncommitted Read| Committed Read 
                  | Repeatable Read | Serializable } 
     @useurl {true|false}; 

This is syntax for changing the value for a specific property, both in character and Windows SQL Explorer:

SYNTAX
SQLExplorer> @property_name value ; 

Windows Only

Follow these steps to change property settings for Windows SQL Explorer only:

  1. Choose File Options. The Properties Editor dialog box appears.
  2. Change any properties you want, then click OK. Any changes you make are applied immediately.

Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095