Procedure Profiling results in Sybase Central v5 & v6

[Justin Willey]

Hi

Is there any way (except screenshots) to copy / save the profiling results
data. I can select the procedure text, or one line of profiling data, but
not the whole thing.

Same in SC v5 & v6 (SQLA v10.0.1 & v11.0)

File | Print, just prints the procedure text.

Many thanks

Justin Willey
IQX

[Glenn Paulley [Sybase]]

Yes - you can export procedure profiling data to a file using the

sa_procedure_profiling()

system procedure.

The profiling data is saved, line by line, in a comma-delimited format.
You can reload that profiling information later (after a server
shutdown, say) and then in Sybase Central re-review the procedure
profiling numbers along with the procedure text.

Glenn

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/databasemanagement/sqlanywhere/technicalsupport