TestBase Db2 Query Build is a quick and easy way to build complex SQL queries. Simply specify the tables to be joined and pick the relationships for a two table join. If Db2 RI is not defined, TestBase Db2 Subset can be used or users can define their own join criteria. Even bill of material explosions can be specified.
As Db2 SQL has evolved over the last 30+ years, it can do more and more. Taking advantage of the new features and concepts means writing more and more complicated SQL– joins – inner – left outer – right outer -full outer, unions, table expressions,recursive bill of material explosion –and many other new concepts. Making Db2 do more work in a single SQL call generally means a better performing application. Fully exploiting these SQL changes is another matter – someone has to write the new SQL.
Db2 Query Build is menu driven SQL. Using a familiar ISPF interface, users can build complicated SQL in seconds rather than minutes or even hours.