Kbase P83107: How to get the SQL statement passed from Progress DataServer to the data source
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/28/2006 |
|
Status: Unverified
GOAL:
How to get the SQL statement passed from Progress DataServer to the data source
GOAL:
How can be seen what SQL statement the Progress DataServer is passing to the data source
GOAL:
How to debug an ODBC DataServer Query.
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
There are several ways to obtain the SQL statement
that is passed by DataServer to the data source:
1. Add the QUERY-TUNING to your FOR EACH, OPEN QUERY,
DO PRESELECT or REPEAT PRESELECT statements with
the options DEBUG SQL which will print out the SQL statement
that DataServer executes against the ODBC data source.
FOR EACH customer, EACH order OF customer, EACH
orderLine OF order BY customer.custnum QUERY-TUNING(DEBUG SQL):
This will print the resulting SQL statement in the dataserv.lg file.
2. You can use Progress session startup parameter, or schema
holder connection parameter as in:
CONNECT mssholder -db mssdemo -dt MSS -Dsrv qt_debug,SQL
and again the resulting SQL statement will be in the dataserv.lg.
3. In case the ODBC driver is used for the DataServer connection
to the datasource, you can activate Tracing in the Windows "ODBC Data Source
Administrator" and examine the generated log file after executing
your query.