Assertions for Result Set

angoca / db2unit

db2unit is a testing framework for IBM DB2 SQL PL

https://angoca.github.io/db2unit/

GNU General Public License v3.0

11 stars 3 forks source link

Assertions for Result Set #20

Open angoca opened 10 years ago

angoca commented 10 years ago

Compare two result sets. They can be returned from a stored procedure or from a cursor (even dynamic statement) of a table, view or join.

Check the following:

Empty result or non-empty result set (first fetch is empty)
quantity of elements? (fetch several times until not-found)

A temporary table with the structure of the table can be created, and insert the data there. Once the two tables (expected, and actual) are created, the content can be compared.

angoca commented 10 years ago

With the built-in modules, a dynamic cursor could be analyzed. http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.db2.luw.apdv.sqlpl.doc/doc/r0055145.html