Setting Database Profiling Options with Interactive SQL

Use sa_server_option to set database profiling options in Interactive SQL. Your server must be running, and you must have DBA authority, and be connected to a database.

In Interactive SQL, run sa_server_option, and set the procedure_profiling options.

For example:

CALL sa_server_option ( 'procedure_profiling', 'ON')

For other options, see SQL Anywhere Server - SQL Reference > System procedures > Alphabetical list of system procedures > sa_server_option system procedure.

Note: This reference points to SQL Anywhere documentation.