DB/Assist gives your ESL application static SQL access to all IBM DB2 databases and.

The benefits of using static SQL for application development follow.

•Executes quickly.

•Improves performance and security.

•Avoids parsing data into variables.

Static SQL executes more quickly than dynamic SQL, since static SQL statements are pre-compiled at development time.

Static SQL provides better performance and an increased level of security. Static SQL statements are pre-compiled and optimized at development time into a persistent access plan. You can grant privileges to users for specific access packages, thereby controlling user access to underlying database tables.

Using static SQL avoids the need to parse your data into ESL variables. This is because the EDB2 support that underlies DB/Assist returns the static SQL statement results directly to ESL variables.