DUMP-LOGGING-NOW( ) method

Writes the accumulated query statistics for the specified query to the log file.

Return type: LOGICAL

Applies to: Query object handle

Syntax

query-handle:DUMP-LOGGING-NOW(reset-expression)

query-handle

A variable of type HANDLE that represents the handle to a query object.

reset-expression

A logical expression where TRUE indicates that the AVM clear the query statistics after writing the statistics to the log file, and FALSE indicates that the AVM leave the query statistics unchanged.

If the AVM writes the query statistics to the log file successfully, the method returns TRUE. If the AVM does not write the query statistics to the log file, the method returns FALSE. The AVM does not write query statistics to the log file under the following conditions:

QryInfo logging for the specified query was not turned on before the query started.
To turn on basic logging for an individual query, you must set the BASIC-LOGGING attribute to TRUE before a query starts. For a dynamically opened query, this is before the QUERY-PREPARE( ) method. For a statically opened query, this is before the OPEN QUERY statement.
QryInfo logging was turned off for the specified query, or all queries, before the query completed.

You can use the DUMP-LOGGING-NOW( ) method only when the logging level of the QryInfo log entry type is set to level 2 (Basic) or higher. To set the logging level of the QryInfo log entry type, use the LOG-ENTRY-TYPES attribute or the Log Entry Types (-logentrytypes) startup parameter with the logging level option.

If the logging level of the QryInfo log entry type is set to level 2 (Basic), the DUMP-LOGGING-NOW( ) method writes query statistics to the log file only if the BASIC-LOGGING attribute is set to TRUE before the query started.

For more information about the Log Entry Types (-logentrytypes) startup parameter, see OpenEdge Deployment: Startup Command and Parameter Reference.

For more information about logging query statistics, see OpenEdge Development: Debugging and Troubleshooting.

OpenEdge Release 10.2B

Copyright © 2009 Progress Software Corporation