During this course participants learn

• to coordinate the development of batch-oriented applications with the characteristics of Db2, specifically regarding restartability, i.e., how to make long-running applications restartable;
• how Db2 is to be used in an interactive context: as a back-end of a web interface, or in combination with a Transaction Processing environment (CICS TS, IMS/TM, or ISPF);
• to give attention to the integrity of data manipulations, as well as to performance;
• how to set up pseudo-conversations.

These goals can be achieved through a thorough analysis of the cursor concept, and by finding out when Db2 materialises its result set.

At the end of this course you will be able to build optimal applications independently, both for interactive use and for batch.

• Embedded SQL: new and advanced possibilities: row sets • indicators • less known cursor options • more about subqueries
• Cursor processing: internal functions • link with integrity • performance aspects • materialisation
• Pseudo-conversations: scrolling • positioning • repeatable read • scrollable cursors
• Batch oriented application: synchronisation • restartability • bulk processing of data • off-line alternatives
• SQL solutions versus programmed solutions: integrity • performance
• Increasing importance of packages, of dynamic SQL, and of BIND options like REOPT
• Locking: selection of the most suitable options for optimal concurrency
• New(er) possibilities of Db2 in this context, like package versioning, optimistic locking, multi-row fetch, piecemeal delete, and pagination

Apart from theory, ample time will be spent on several examples and exercises.

Delivered as a live, interactive training – available in-person or online, or in a hybrid format. Training can be implemented in English, Dutch, or French.

Participants should be familiar with embedded SQL (Db2) in COBOL PL/I, SQL PL, or an other programming language (see course Db2 for z/OS fundamentals course). At least a few months of practical experience is recommended.

Application developers, DBAs, and everyone involved in designing, writing, or supporting Db2 applications.