Unit test SQL PL routines by using db2unit framework in DB2 LUW

An introduction to xUnit framework for the SQL PL programming language

From the developerWorks archives

Andres Casanova

Date archived: January 12, 2017 | First published: January 09, 2015

SQL PL routines stored in DB2® databases contain business logic that can be used by all applications that access the database. However, these routines are not always completely tested. Until now, no standard procedure existed to perform automatic tests against them. With the incursion of test-driven development from the eXtreme Programming paradigm, it is important to write test cases that check all possible conditions. Doing so even before starting development ensures the quality of the software. db2unit is a framework that helps you follow these guidelines by writing better code and creating more reliable applications. Learn how to use the innovative framework that, automating unit tests for the SQL PL routines.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.



static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Information Management
ArticleID=994582
ArticleTitle=Unit test SQL PL routines by using db2unit framework in DB2 LUW
publish-date=01092015