Skip to Content

Code Coverage tool for SQL Anywhere

Hi,

is anyone aware about Code Coverage tool for SQL Anywhere. E.g. to track which lines of code within stored procedure,functions, and triggers that have been tested by an application/test scripts? Or, suggest how this could be done in SQLA.


thanks,

L

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Apr 29, 2016 at 02:06 AM

    Hi,

    SQL Anywhere provide debugger to debug SQL stored procedures, triggers, event handlers, and user-defined functions you create. Simply start SQL Anywhere SQL Central connect to a database server, then click Mode -> Debug. The detailed information could refer to http://dcx.sap.com/index.html#sqla170/en/html/8196f2426ce210149629e49afd4e0833.html

    Best regards,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 29, 2016 at 10:15 AM

    Hi L,

    I think you request is best satisfied using the SQL Anywhere Profiler tool. In SQLAny 17, you can start it from the Tools drop-down in the SQL Anywhere plug-in of SQL Central. In previous versions, it was part of the Application Profiling mode of Sybase Central. Here, number of executions and execution time are tracked on all database-side logic without having to interact on individual logic objects.

    HTH

    Volker

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.