Kbase P113116: Is there a way to use GUI Progress SQL Explorer in OpenEdge 10.1x / 10.2x ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
01/11/2010 |
|
Status: Verified
GOAL:
Is there a way to use GUI Progress SQL Explorer in OpenEdge 10.1x / 10.2x ?
GOAL:
Is there a way to use GUI Progress SQL Explorer in 10.1x?
GOAL:
Is there a way to use GUI Progress SQL Explorer in 10.2x?
GOAL:
Is GUI Progress SQL Explorer 10.0x supported in 10.1x?
GOAL:
Is GUI Progress SQL Explorer 10.0x supported in 10.2x?
GOAL:
Does the SQL Explorer only have a character mode for 10.1x?
GOAL:
Does the SQL Explorer only have a character mode for 10.2x?
GOAL:
What was the first release of OpenEdge 10 not to have the GUI SQL Explorer?
FACT(s) (Environment):
OpenEdge 10.1x
OpenEdge 10.2x
Windows
FIX:
Starting with OpenEdge 10.1A, SQL Explorer can only be run in character mode. The GUI mode of SQL Explorer is not delivered in OpenEdge 10.1A or later versions due to JDBC3 specification changes.
You may use the IDE DB Navigator or other GUI tools that conforms to the JDBC3 specification in the JDBC type 4 driver in 10.1A and higher releases.
DB Navigator is found under OpenEdge Architect. First time use of OpenEdge Architect displays a welcome screen. DB Navigator is located under the welcome screen in the upper left-hand corner.
The SQL Explorer Character Client may still be used to execute SQL queries by executing command in a Proenv session. For example:
sqlexp -char -db DbName -S nnnnn -infile Query.sql -outfile Query.out -user UserName -password UserPassword
Where:
DbName : The the connected database name
nnnnn : The integer number value of the connection service port
Query.sql : The file containing the SQL script to execute
Query.out : The file where the result set or the errors will be logged.
UserName : The name of the user executing the query
UserPassword: The password of the user executing the query