How to set or change the SQL properties of the Progress SQL Explorer Character Tool ( sqlexp )? - Progress Community

Loading

Skip to Main Content

How to set or change the SQL properties of the Progress SQL Explorer Character Tool ( sqlexp )?

This KB article shows how to set the SQL properties of the Progress SQL Explorer Character Tool (sqlexp) session by using its @ command or by directly editing the SQLExplorer.properties file. This KB also explains the sqlexp @Show command and its syntax.

2012-5-20
Knowledge

Title

How to set or change the SQL properties of the Progress SQL Explorer Character Tool ( sqlexp )?

URL Name

P147080

Article Number

000139447

Environment

Product: Progress Version: 9.x Product: OpenEdge Version: 10.x, 11.x, 12.x OS: All supported platforms

Question/Problem Description

How to set the SQL properties of the Progress SQL Explorer Character Tool (sqlexp) session using its @ command?
How to set or change the SQL properties of the sqlexp directly editing the SQLExplorer.properties file?
What does the sqlexp command @Show do?
What is the syntax of the sqlexp command @Show?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

1. Use the SQL Explorer @ command to change any of the available SQL Explorer properties. For example, to set the AutoCommit property to false, execute the following SQL Explorer command:

SQLExplorer>@AutoCommit false

Ok: AutoCommit false. (8932)

similarly to eliminate the default 101 row fetch limit, execute the following SQL Explorer command:

SQLExplorer>@HasColumnLimit false

Ok: HasColumnLimit false. (8932)

2. Any of the sqlexp SQL properties may also be set or changed by directly editing the SQLExplorer.properties file in any text editor. For example to change the FetchLimit from 101 t to 1000, open the SQLExplorer.properties in a text editor and change the line:

FetchLimit 101

to:

FetchLimit 1000

3. The sqlexp @Show command lists the current setting of one or more SQL properties of the current sqlexp session. When used with no arguments, it returns a list of all the sqlexp session properties and their current values:

SQLExplorer>@Show

Options values are:

AutoCommit true

ColumnWidthLimit 25

ColumnWidthMinimum 1

ConnectTimeout 180

Connect jdbc:datadirect:openedge://localhost:12345

DisableWarnings true

Disconnect true

EchoAll false

EchoCmd false

EchoComments false

EchoSql false

FetchLimit 101

HasColumnLimit false

HasFetchLimit true

Logfile C:\OpenEdge\WRK102B\SQLExplorerSession.log

Logging false

PageLimit 22

Pager false

ReportFormat Standard

SqlVerbose false

TransactionIsolation 1: Read Committed;

Ok: show. (8932)

Note: Attached PDF file has more details on the property values

When used with one or more arguments (property names), it returns a list of the specified properties and their values. For example, the following command returns the AutoCommit property current value:

SQLExplorer>@show AutoCommit

Options values are:

AutoCommit true;

Ok: Show autocommit. (8932)

And the following command returns the values of bothe the HasFetchLimit and the AutoCommit properties:

SQLExplorer>@show HasFetchLimit AutoCommit

Options values are:

HasFetchLimit true

AutoCommit true;

Ok: Show hasfetchlimit autocommit. (8932)

Workaround

Notes

Reference to Other Documentation:

https://documentation.progress.com/output/ua/resources/OpenEdge/91E/oe-91e-pdfs.zip

Progress Article(s):

How to remove the limit of number of records returned by SQL explorer?

Keyword Phrase

Last Modified Date

2/14/2022 4:26 PM

OpenEdge General DiscussionsOpenEdge DeploymentOpenEdge DevelopmentOpenEdge RDBMSOpenEdge ArchitectureOpenEdge Pro2

Drop Files

Upload FilesOr drop files

SQL explorer properties
SQL explorer properties
2022-2-14
594KB
pdf

Disclaimer

The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.

Loading

How to set or change the SQL properties of the Progress SQL Explorer Character Tool ( sqlexp )? - Progress Community