On-site & Public, Instructor-led, Hands-on IT Training
800.756.3000
(International 01) 908.233.8900
  400+ Course Offerings:


Search for Course:

DB1042 DB2 for z/OS Advanced Embedded Programming
 
 
Duration 2 Days
Delivery Method Instructor Led, Hands-on Workshops
Public Price $1125.00


DESCRIPTION (Return to Top)

Have you been coding SQL in embedded programs such as COBOL for a while and looking to fine tune your skills? If so, this course is for you. Learn some advanced techniques for coding cursors including some of the new features in the latest releases of DB2. Also learn how DB2 locking affects the way programs should be coded. The course concludes with a primer on SQL optimization and the toolset provided by IBM for optimizing the queries in a program.



AUDIENCE (Return to Top)

Developers who code SQL queries embedded in host languages such as COBOL.



TOPICS (Return to Top)
  • DB2 and SQL Components
  • Using Scrollable Cursors
  • Multi-Row Operations
  • Locking Strategies & Concurrency
  • SQL Performance


PREREQUISITES (Return to Top)

DB1010 or equivalent experience.