home 
 
 
 
nlfr
 
Home
About ABIS
Services
Courses
Resources
Contact
MyABIS
All CoursesbalkjeGeneral » Introduction to HW & SW » TracksOperating systems » MVS - z/OS » UNIX - Linux - AIX » VMwareDatabases, transaction systems and middleware » DB2 for z/OS » DB2 UDB for Linux, UNIX and Windows » Oracle » SQL Server » MySQL » IMS » CICS » WebSphere MQ » WebSphere Application Server » Business intelligence and data warehouseApplication development » Methods and techniques » TOGAF » PRINCE2 » Programming languages » Internet development » Object Oriented systems » Java » IBM development tools » SAS » XML » SOA & web servicesSystems management » ITILbalkjePractical informationRegistration 
DB2 for z/OS advanced programming

Intended for

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

Background

Participants should be familiar with embedded SQL (DB2) in COBOL or PL/I (see course DB2 for z/OS fundamentals course) within ISPF. Some months of practical experience is recommended.

Training method

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

Course leader

Peter Vanroose.

Duration

2 days.

Schedule

datelanguageplacepriceremarks
05/03/2012 Leuven940 EUR
Legend
  • You can enrol by clicking on the dates in the calendar.
  • N: Dutch; F: French; E: English; No code: language depends on the participants.
  • All prices are VAT excluded.
  • Countries:
    Belgium 
    Netherlands 
    Elsewhere 

Objectives

During this course participants learn:

  • the principles of adapting DB2 to a TP environment (IMS/TM, CICS TS, or TSO); attention is given to the integrity of data, as well as to performance.
  • to coordinate the development of batch-oriented applications with the characteristics of DB2.

This goal can be achieved through a thorough analysis of the cursor concept and the use of techniques in order to investigate the behaviour of DB2, especially regarding materialisation.

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

Main topics

  • Embedded SQL: new and advanced possibilities: rowsets • extra 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 REOPT()
  • Locking: selection of the most suitable options for optimal concurrency