Why do you need DB2Factory?
The Short Answer:
Speed
Speed of development
Experience shows that at least 80
percent of the code volume of every database application can be determined based
on the application's data definition language (DDL).
Using
DB2Factory
can give you a huge head start
on your next DB2 development project at a fraction of the cost of manual coding
efforts.
Speed
of execution
There are two basic ways to access DB2 data:
Dynamic SQL and Static SQL (Static SQL is sometimes referred to as embedded
SQL).
DB2Factory
produces SQL that will be statically bound
against your DB2 database. Statically bound SQL will always result in the
fastest possible response time for any given DB2 query.
Be careful in your
selection of middleware,
ODBC and JDBC drivers use dynamic SQL.
You can read for yourself what IBM has to say about Dynamic vs. Static SQL.