Kbase P147080: How to set SQL Explorer properties using the commands on the SQL Explorer character tool?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/05/2010 |
|
Status: Verified
GOAL:
How to set SQL Explorer properties using the commands on the SQL Explorer character tool?
GOAL:
How to set SQL Explorer properties using the commands on the SQL Explorer GUI tool?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
All Supported Operating Systems
FIX:
All available SQL Explorer properties can be displayed with the following command on the SQL Explorer:
@Show
The following are displayed when @show is used
SQLExplorer>@show
Options values are:
AutoCommit false
ColumnWidthLimit 25
ColumnWidthMinimum 1
ConnectTimeout 180
Connect jdbc:datadirect:openedge://localhost:<port#>;databaseName=<db name>
DisableWarnings true
Disconnect true
EchoAll false
EchoCmd false
EchoComments false
EchoSql false
FetchLimit 101
HasColumnLimit false
HasFetchLimit true
Logfile /users/ts/osborne/SQLExplorerSession.log
Logging false
PageLimit 22
Pager false
ReportFormat Standard
SqlVerbose false
TransactionIsolation 1: Read Committed;
Ok: show. (8932)
The syntax to change the value for a specific property in both character and Windows SQL Explorer is:
SQLExplorer>@<property_name> <value> ;
For example,
SQLExplorer>@TransactionIsolation 0;
If you run @show again it will display the changed properties as
SQLExplorer>@show
Options values are:
AutoCommit false
ColumnWidthLimit 25
ColumnWidthMinimum 1
ConnectTimeout 180
Connect jdbc:datadirect:openedge://localhost:<port#>;databaseName=<db name>
DisableWarnings true
Disconnect true
EchoAll false
EchoCmd false
EchoComments false
EchoSql false
FetchLimit 101
HasColumnLimit false
HasFetchLimit true
Logfile /users/ts/osborne/SQLExplorerSession.log
Logging false
PageLimit 22
Pager false
ReportFormat Standard
SqlVerbose false
TransactionIsolation 0: Read Uncommitted;
Ok: show. (8932)
The values are written to SQLExplorer.properties file in the Progress working directory.