Debugger support for EVAL within SQL Routines and SQL Triggers

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

News


Abstract

The IBM i Debugger, graphical debugger packaged with iAccess for Windows and the Start Debug (STRDBG), green screen debugger have been enhanced for SQL users.

Content

You are in: IBM i Technology Updates > Db2 for i - Technology UpdatesDb2 for i Functional Enhancements > Debugger support for EVAL within SQL routines and SQL triggers

Any debugging SQL procedures, functions and triggers will be evaluate variables without having to change the source view to the Db2 for i generated ILE C source code.  Note: while this is a major step forward for debugging SQL at the application layer, the EVAL enhancement does not support all data types at this time.

image-20200117131614-1

[{"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:
26 October 2021

UID

ibm11163860