Objectives
Effective use of the DBMS resources can avoid potential application problems. The first section of this chapter discusses important programming considerations and data manipulation strategies such as referencing system catalogs, creating complex database objects, creating UDTs, creating common table expressions, and using compound SQL statements. It will also look at the various cursor types, the advantages of prepared statements, and the usage of identity columns, table triggers, and the STAR schema. The second section reviews concurrency and transaction-management issues such as unit of work, locking strategies, isolation levels, and distributed unit of work. The next section discusses writing SQL stored procedures and using the ...
Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
