Back to Search Results

Training Course Summary:

This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases in Linux, UNIX and Windows environments. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution

Pre-Requisites:

Prior to attending this course, you should already have experience with the C programming language on Linux, UNIX or Windows. DB2 UDB on Windows will be used for the practical sessions. You are also expected to be able to construct and use SQL statements.

Who Should Attend:

Application programmers who need to write embedded SQL programs in the C language on Linux, UNIX or Windows.

Training Course Overview/Content:

On completion you will be able to:
Incorporate static SQL statements in an application program
Prepare the program for execution
Validate execution results are correct
Produce code to support multiple rows being returned from the database manager using cursors
Identify considerations regarding units of work, concurrency, and restart of programs
Identify differences between static and dynamic SQL
Provide test data for applications
Discuss program and DB2 options relative to performance of static SQL.