Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Stored procedures and triggers » Debugging procedures, functions, triggers, and events » Tutorial: Getting started with the debugger

 

Lesson 1: Connect to a database and start the debugger

 To start the debugger
  1. Create a directory to hold the copy of the sample database you will use in this tutorial, for example c:\demodb.

  2. Copy and rename the sample database from samples-dir\demo.db to c:\demodb.

    For information about samples-dir, see Samples directory.

  3. Click Start » Programs » SQL Anywhere 12 » Administration Tools » Sybase Central.

  4. Choose Connections » Connect With SQL Anywhere 12.

  5. In the User ID field, type DBA and in the Password field, type sql.

  6. From the Action dropdown list, choose Start A Database On This Computer.

  7. Click Database File, and then in the box below, c:\demodb.

  8. Click Connect.

  9. Choose Mode » Debug.

  10. In the Which User Would You Like To Debug field, type * and click OK.

    If you want to debug a different user, you must exit Debug mode, and then re-enter Debug mode.

    The Debugger Details pane appears at the bottom of Sybase Central and the Sybase Central toolbar displays a set of debugger tools.

    When you provide a user name, information for connections with that user name is captured and appears on the Connections tab.

    The Debugger Details pane.
  11. (optional) Restore the sample database (demo.db) to its original state by following the steps found here: Recreate the sample database (demo.db).