Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » SQL Statements

DESCRIBE statement [Interactive SQL] Next Page

DETACH TRACING statement


Use this statement to end a diagnostic tracing session.

Syntax

DETACH TRACING { WITH | WITHOUT } SAVE

Parameters

WITH SAVE     Specify WITH SAVE to save data any unsaved diagnostic data in the diagnostic tables.

WITHOUT SAVE    Specify WITHOUT SAVE if you do not want to save any unsaved tracing data.

Remarks

Issue this statement from the database being profiled to stop sending diagnostic information to the diagnostic tables. If you specify the WITHOUT SAVE clause, you can still save the data later—assuming the tracing database is still running and another tracing session has not been started—by using the sa_save_trace_data system procedure. See sa_save_trace_data system procedure.

To see the current tracing levels set for a database, look in the sa_diagnostic_tracing_level table. See sa_diagnostic_tracing_level table.

Permissions

Must have DBA authority.

Side effects

None.

See also
Standards and compatibility