This course focuses right from the start on what you need to know to access and process DB2 data in your application programs using embedded SQL.

You will learn:

• Critical DB2 concepts that let you understand how DB2 works so you can program more easily and logically
• Basic DB2 coding features you’ll use in every program you write
• Use features like outer joins and the explicit syntax for inner joins that simplify your coding
• Work with column functions, scalar functions, and subqueries to manipulate DB2 data
• Handle the complications caused by variable-length data and null values in DB2 tables
• Use error handling techniques and ROLLBACK to protect DB2 data
• Why program efficiency is vital under DB2…and how to use the locking features right so you don’t tie up the whole system
• Use SPUFI and QMF to create the test tables you need to debug your programs
• Develop DB2 programs interactively (using DB2I, a TSO facility) or in batch