Start the debugger to run the debugger_tutorial stored procedure and find the bug.
This lesson assumes that you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Getting started with the debugger.
Create the copy of the sample database that is used in this tutorial.
Create a directory, for example c:\demodb, to hold the database.
Run the following command to create the database:
Start Sybase Central. Click Start » Programs » SQL Anywhere 16 » Administration Tools » Sybase Central.
In Sybase Central, connect to demo.db as follows:
Click Connections » Connect With SQL Anywhere 16.
In the Connect window, complete the following fields to connect to the database:
In the User ID field, type DBA.
In the Password field, type sql.
In the Action dropdown list, select Start and connect to a database on this computer.
In the Database file field, type c:\demodb\demo.db.
In the Server name field, type demo_server.
Click Mode » Debug.
In the Which User Would You Like To Debug field, type * and then click OK.
The Debugger Details pane appears at the bottom of Sybase Central and the Sybase Central toolbar displays a set of debugger tools.
Specifying * allows you to debug all users. To change the user being debugged, you must exit and re-enter debug mode. When you provide a user ID, information for connections with that user ID is captured and appears on the Connections tab.
In the left pane of Sybase Central, double-click Procedures & Functions.
Right-click debugger_tutorial (GROUPO), and then click Execute from Interactive SQL.
Interactive SQL opens and the following result set appears:
This result set is incorrect. The remainder of the tutorial diagnoses the error that produced this result.
Close any open Interactive SQL windows.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|