Hi all,
I'm using ASA 9.0.1.
How I can see (using Sybase Central) or log ANY sql statement (SELECT
query too ....) is executed from ASA engine ?
Thanks.

This will write all sql statements processed to a text file:

call sa_server_option( 'request_level_logging', 'SQL' );
call sa_server_option( 'request_level_log_file', 'c:\theLogFile.txt' );

Then turn it off with:
call sa_server_option( 'request_level_logging', 'none' );
call sa_server_option( 'request_level_log_file', '' );

--
Paul Horan[TeamSybase]
Cynergy Systems
www.cynergysystems.com

"Nicola Cisternino" <ncister (AT) cointa (DOT) it> wrote

Nicola Cisternino wrote:
As an alternative to Paul's response, from Sybase Central:

1. right click the server icon
2. select "Properties"
3. click the "Options" tab
4. check "Enable request logging"
5. enter the path to a log file
6. click "OK"

You can analyse the log file after it has accumulated SQL statements
using the stored procedures sa_get_request_profile() and
sa_get_request_times().

In the SQL Anywhere 9.x online docs, see:

ASA SQL User's Guide
Monitoring and Improving Performance
Performance analysis tools
- Request logging

Hope this helps,
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/