| Team-Fly | | | DB2 Universal Database for OS/390 v7.1 Application Certification Guide By Susan Lawson | Table of Contents | | Appendix A. IBM Certified Solutions ExpertDB2 UDB Family Application Development | Certification Test Objectives The IBM certified solutions expert for DB2 UDB in application development requires an in-depth knowledge of the difference between programming types (ODBC, JDBC, OLEDB, Embedded SQL) and when to use the different programming types: -
The difference between embedded dynamic and static SQL -
Basic and intermediate SQL -
Concepts and usage of binding and prepping, isolation levels, basic database objects, and data types (schema, naming conventions) -
Transaction concepts (commit scope, states) and cursor concepts Furthermore, the solutions expert in application development should have a basic knowledge of -
Diagnostic information -
Advanced SQL (recursive, DDL, temporary tables, and compound) -
Locking -
Privileges and authorities -
SQL routines and functions -
Complex database objects (UDTs, UDFs, triggers) -
SQLDA -
SQLCA -
Host variables -
Parameter markers -
Connection types -
Transaction manager The following are some of the topics covered on the exam. I. Database Objects -
Knowledge of naming conventions of DB2 objects (aliases, views, etc.) -
Knowledge of the authorities needed to access data in an application -
Knowledge of complex database objects (temporary tables, summary tables, triggers) II. Data Manipulation -
Ability to query database across multiple tables -
Ability to query tables across multiple databases (federated databases) -
Knowledge of changing data -
Ability to use DB2 SQL functions -
Ability to use common table expressions -
Knowledge to identify when to use cursors in a SQL program -
Knowledge to identify types of cursors -
Knowledge to identify the scopes of cursors -
Ability to manipulate cursors -
Ability to manage a unit of work (transaction management) III. DB2 Programming Methods -
Knowledge to identify the differences between dynamic and static embedded SQL -
Skill in determining when to use CLI/ODBC -
Skill in determining when to use JDBC and SQLJ -
Ability to determine when to use SQL routines and functions -
Ability to determine when to use OLEDB IV. Embedded SQL Programming -
Knowledge of identifying steps and output involved in creating an embedded SQL programming application -
Knowledge to identify when host variables are used begin-declare) -
Skill in declaring host variables -
Skill in utilizing host variable in queries -
Ability to explain and analyze the content of the SQLCA -
Knowledge of common errors, prep, and BIND database programs -
Ability to connect to databases within an embedded SQL programming application V. ODBC/CLI Programming -
Knowledge of the different handle types -
Knowledge of configuring DB2 ODBC driver -
Knowledge of problem determination (diagnostic records) -
Knowledge of the correct sequence for calling ODBC/CLI functions -
Knowledge of various CLI cursor types and when to use them -
Ability to connect to databases within an ODBC/CLI programming application VI. JAVA Programming -
Knowledge of various JDBC objects -
Knowledge of the difference between SQLJ and JDBC -
Knowledge of problem determination (JDBC trace, SQL exceptions, and JDBC error log) -
Skill in performing the steps to build SQLJ applications -
Ability to connect to databases within a JAVA programming application -
Ability to manage transactions across multiple databases (JTA) -
Ability to determine which connection types should be used to connect to the database VII. Advanced Programming -
Ability to utilize dynamic and static SQL within programs -
Skill in casting UDTs within a program -
Knowledge to identify when to use Compound SQL -
Knowledge of concurrency considerations within an application -
Knowledge of distributed unit of work -
Knowledge of using parameter markers -
Ability to determine the approaches to programming using Unicode -
Ability to use performance enhancement features (CLI Load, buffered inserts ) VIII. Stored Procedures and User-Defined Routines -
Knowledge to identify usage of UDFs -
Knowledge to identify when to use stored procedures -
Skill in using the DB2 Development Center -
Knowledge of programming languages using the DB2 Development Center |