Kbase P104202: How to set AutoCommit property in SQL Explorer Tool character version.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/11/2010 |
|
Status: Unverified
GOAL:
How to set AutoCommit property in SQL Explorer Tool character version.
GOAL:
What is the syntax to change the value for a specific property in SQL Explorer Tool character version.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
The syntax to change the value for a specific property in both character and Windows SQL Explorer is as follows:
SQLExplorer> @ property_name value ;
SQLExplorer>@autocommit true;
The values are written to WRKDIR/SQLExplorer.properties file.
or,
You can edit the SQLExplorer.properties file found in the working directory once you exit the first character sqlexp connection.
Change the AutoCommit from the default of =false to =true
#C:\wrk102a\SQLExplorer.properties
#Nov 11, 2010 3:17:09 PM
EchoSql=false
Connect=jdbc:datadirect:openedge://localhost:6000;databaseName=joe
AutoCommit=true
HasFetchLimit=true
ColumnWidthLimit=25
ColumnWidthMinimum=1
HasColumnLimit=false
Logging=false
EchoAll=false
SqlVerbose=false
FetchLimit=101
ReportFormat=Standard
DisableWarnings=true
Pager=false
Run=
Logfile=C:\wrk102a\SQLExplorerSession.log
ConnectTimeout=180
EchoComments=false
ResultSetLimit=24
TableFormat=true
Help=
TransactionIsolation=Read Committed
PageLimit=22
Echo=true
Show=
Reset=
Disconnect=true
UseUrlFormat=false
EchoCmd=false