Using SQL Select and Verify

The component might update Db2 and we can select and verify data in Db2 by using an SQL Select element followed by a Verify element. The SQL Select element defines a SQL statement that will return a number of rows, each with the output columns specified in the element. The content of rows and columns can be examined with an Iterate that can run through all rows, and a Verify element can be used to check the validity of column values. Let us look at a simple example. A component updates a Db2 table with employee information. We want to check that the rows in the table do not contain empty first names. This can be written as: