Db2 App Dev Exam -703 Details

IBM Test 703: DB2 V8.1 Family Application Development An IBM Certified Application Developer is an intermediate or advanced level application developer specializing in creating applications that run on any of the DB2 platforms: Linux, UNIX (including AIX, HP-UX, and Sun Solaris), and Windows, z/OS, s/390, and iseries. This individual has strong skills in all common programming tasks as well as strong skills in one or more of the speciality areas: embedded SQL programming, ODBC/CLI programming, or Java programming. Test information:

•

Number of questions: 63

•

Time allowed in minutes: 75

•

Required passing score: 57%

Section 1 - Database objects and Programming Methods (13%) a. Knowledge of naming conventions of DB2 objects (aliases, views, etc.) b. Knowledge of the authorities needed to access data in an application c.

Knowledge of complex database objects

d. Knowledge to identify the differences between dynamic and static embedded SQL e. Skill in determining when to use CLI/ODBC f.

Skill in determining when to use JDBC, SQLJ

g. Ability to determine when to use SQL routines and functions h. Determine when to use OLEDB Section 2 - Data Manipulation (26%) a. Ability to query database across multiple tables b. Ability to query tables across multiple databases (federated databases) c.

Knowledge of changing data

d. Ability to use DB2 SQL functions e. Ability to use common table expressions f.

Knowledge to identify when to use cursors in an SQL program

g. Knowledge to identify types of cursors h. Knowledge to identify the scopes of cursors i.

Ability to manipulate cursors

j.

Ability to manage a unit of work (transaction management)

Section 3 - Embedded SQL Programming (11%) a. Knowledge of identifying steps and output involved in creating an embedded SQL programming application b. Knowledge to identify when host variables are used (begin-declare) c.

Skill in declaring host variables

d. Skill in utilizing host variable in queries e. Ability to explain/analyze the content of the SQLCA f.

Knowledge of common errors, prep, and BIND database programs

g. Ability to connect to databases within an embedded SQL programming application Section 4 - ODBC/CLI Programming (13%) a. Knowledge of the different handle types b. Knowledge of configuring DB2 ODBC driver c.

Knowledge of problem determination (diagnostic records)

d. Knowledge of the correct sequence for calling ODBC/CLI functions e. Knowledge of various CLI cursor types and when to use them f.

Ability to connect to databases within an ODBC/CLI programming application

Section 5 - Java Programming (13%) a. Knowledge of various JDBC objects b. Knowledge of the difference between SQLJ and JDBC c.

Knowledge of problem determination (JDBC Trace, SQL exceptions, JDBC error log)

d. Skill in performing the steps to build SQLJ applications e. Ability to manage transactions across multiple databases (JTA) f.

Ability to connect to databases within a JAVA programming application

g. Ability to determine which connection types should be used to connect to the database Section 6 - Advanced Programming (16%) a. Utilize dynamic and static SQL within programs b. Skill in casting UDTs within a program c.

Knowledge to identify when to use Compound SQL

d. Knowledge of concurrency considerations within an application e. Knowledge of distributed unit of work f.

Knowledge of using parameter markers

g. Determine the approaches to programming using Unicode h. Use performance enhancement features (buffered inserts) Section 7 - User Defined Routines (8%) a. Knowledge to identify usage of UDFs b. Knowledge to identify when to use stored procedures c.

Skill in using the DB2 Development Center

d. Knowledge of programming languages using the DB2 Development Center