When you debug a procedural object and execution is suspended, the Referenced Tables view opens automatically in Database Debug perspective. From there, you can view, sort, and filter data in tables and views referenced in the procedural object, and open the Table Data editor to edit tables.
Referenced Tables view actions for database tables and views
| Task | Allowed for tables | Allowed for views |
|---|---|---|
| View table data | Yes | Yes |
| Enter a select statement to filter or sort the data displayed | Yes | Yes |
| Refresh the table from the database | Yes | Yes |
| Open the Table Data editor | Yes | — |
| Insert, update, or delete data rows displayed in the Referenced Tables view, using the Table Data editor | Yes | — |
| Set data cell to Null in Table Data editor | Yes | — |
| Revert changes in Table Data editor | Yes | — |
| Commit Table Data editor changes to the database | Yes | — |
The Referenced Tables view supports these table types:
Base tables or views referenced in the procedural object
Adaptive Server Enterprise sharable and nonsharable temporary tables referenced in the procedural object in the current session
Referenced Tables view does not show proxy tables, or Adaptive Server Anywhere and Sybase IQ local and global temporary tables.
Opening a Table in Referenced Tables View
Setting Display Options for Referenced Tables View
Viewing Text and Image Data in Referenced Tables
Setting SQL Debugger Preferences
Launching a Database Debug Session
Send your feedback on this help topic to Sybase Tech Pubs: pubs@sybase.com