You can save the data from a Monitor session as a binary file (.mlm), as a text file with comma-separated values (.csv), as tables in a relational database, or as a Microsoft Excel file.
To save the data as a file, choose File » Save As.
In the .csv file format, time durations are stored in milliseconds.
You can specify that you want data to be saved automatically to a file. To do this, choose Tools » Options, and enter an output file name on the General tab. The output file is overwritten by new data.
You can also export Monitor data using an ODBC connection. You can export to any relational database that is supported by MobiLink, as well as to Excel.
When you export data, all the columns in your Monitor session are exported, as well as a column called export_time that identifies the time the export was performed. Data from the graph is not exported.
The data source must have quoted identifiers enabled, because some of the columns are reserved words. The Monitor enables quoted identifiers automatically for SQL Anywhere, Adaptive Server Enterprise, and Microsoft SQL Server databases. If the quoted identifiers option is not enabled, the export fails.
To export the data to a database or Excel
After collecting Monitor information, disconnect from the MobiLink server.
In the MobiLink Monitor, choose File » Export To Database.
The Export To Database window appears.
Select options for the output.
A Connect window appears that allows you to connect to the database or Excel spreadsheet using ODBC.
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|