Debug step supported for SQL Procedures, Functions and Triggers

Created by Matthew Wiltzius on Mon, 12/23/2019 - 11:18
Published URL:
https://www.ibm.com/support/pages/node/1163854
1163854

News


Abstract

Debug step supported for SQL Procedures, Functions and Triggers

Content

You are in: IBM i Technology Updates > Db2 for i - Technology Updates > Db2 for i Functional Enhancements > Debug step supported for SQL Procedures, Functions and Triggers
SQL Procedures, Functions, and Triggers created with SET OPTION DBGVIEW = *SOURCE can be debugged using:
  1. The IBM i green screen debugger via the Start Debug (STRDBG) command
  2. The IBM i Navigator graphical debugger (System Debugger)

When an SQL Procedure, Function, or Trigger is built for debug, there are two debug views which can be used:

  1. SQL Object Processor Root View (default)
  2. Underlying ILE C listing view
     

Prior to this enhancement, when the Step function (F10=Step when using STRDBG or F11=Step Over when using System Debugger) was used within either of the IBM i debuggers at the SQL view debug level, the Step action applied to the underlying ILE C listing view.  It would normally take many steps at the SQL debug view level to get to the next statement, making the SQL debug view difficult to use. 

After this enhancement is installed, the Step action applies at the SQL Statement view level.  This enhancement makes it much easier to debug SQL Procedures, Functions, and Triggers.

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SWG60","label":"IBM i"},"Component":"","Platform":[{"code":"PF012","label":"IBM i"}],"Version":"< IBM i 7.2","Edition":"","Line of Business":{"code":"LOB57","label":"Power"}}]

Document Information

Modified date:
23 January 2020

UID

ibm11163854

Page Feedback