中国大陆 台湾 香港/澳门 返回首页
IBM在线课程
首页>IBM在线课程>课程信息

DB2 11 for z/OS Application Programming Workshop Code: 1V722G

课程编号
Course Code
1V722G 课程级别
Skill Level
中级 课程分类
Curricula
Information Management 面授课程编号
Face2Face
Course Code
授课语言
Language
英文 上机实验
Hands-on Labs
价格 (元)
Price
¥ 500        时      长
Duration
3D
课程描述/Course Description:
This course enables you to acquire the skills necessary to produce application programs that manipulate DB2 databases. Emphasis is on embedding Structured Query Language (SQL) statements and preparing programs for execution.
授课对象/Target Audience:
This course is for application programmers who need to write embedded SQL programs in COBOL or PL/I (on z/OS).
预备技能/Prerequisites:
You should already have experience with one of the supported programming languages, COBOL or PL/I for z/OS. You are also expected to already be able to construct and use SQL statements.
课程目标/Skills Taught:
Incorporate static SQL statements in an application program Prepare the program for execution Validate execution results are correct Produce code to support multiple rows being returned from the database manager using cursors Identify considerations regarding units of work, concurrency, and restart of programs Identify differences between static and dynamic SQL Provide test data for applications Discuss program and DB2 options relative to performance of static SQL
主要课题/Course Outline:
DB2 Concepts Program Structure I Program Preparation Program Structure II Recovery and Locking Concepts Dynamic SQL Introduction Managing Test Data Performance Considerations