DB2 for zOS Application Development Classes

Barb Lidstrom

DB2 for zOS Application Development Classes
If you are interested in attending the classes below in Bellevue, please
let Tammy know.


Barb Lidstrom
Seattle DB2 User Group
http://www.db2seattle.org < http://www.db2seattle.org/ >
[login to unmask email]
425 865-1584


________________________________

From: Hale, Tammy [mailto:[login to unmask email]
Sent: Friday, March 30, 2007 1:31 PM
To: Lidstrom, Barbara
Subject: FW: DB2 for zOS Application Development Classes



All -

There is an effort underway to schedule two DB2 for z/OS Application
Development classes at the Bellevue IBM/MUX facility in the near term.
To do this, IBM needs 5 people to register for the class. If you plan
to attend, please send an email to Tammy Hale at [login to unmask email]
<mailto:[login to unmask email]> as an FYI. We are looking to schedule
classes between now and June 2007.

________________________________

Tammy Hale, Technical Specialist-Sr
DB2 Database Administrator, RBSS

Washington Mutual

1300 2nd Avenue, WMC0607, Seattle, WA, 98101

[login to unmask email] <mailto:[login to unmask email]>



Telecomuting Monday and Friday

1-253.863.5476 home

1-253.350.1592 cell





U5787 DB2 Family Introduction Mini-Curriculum




Course code U5787 Skill
level Intermediate

Duration 5.0 days
Delivery type Classroom
(Hands-on labs)

Public price USD $2,730 plus tax



This course is a combined offering of:

DB2 UDB Application Programming Workshop (CF820)

DB2 UDB for z/OS Stored Procedures using COBOL (CG730)

Acquire the skills necessary to produce application programs that
manipulate DB2 databases. Emphasize embedding SQL statements and
preparing programs for execution.



Audience

This is an intermediate course for database application designers and
database application programmers who need to write embedded SQL programs
in Common Business Oriented Language (COBOL) or Programming Language One
(PL/I), and who will be supporting DB2 stored procedures.



Skills taught

Incorporate static SQL statements in an application program

Prepare the program for execution

Validate execution results

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

Describe DB2 stored procedures and discuss z/OS-related platform
requirements and dependencies

Discuss and demonstrate DB2 Development Center capabilities

Describe and demonstrate Debug tool for z/OS capabilities

Create and test-drive a stored procedure

Create and run stored procedure client programs

Create and test-drive a stored procedure that returns result sets

Create and run stored procedure client programs that receive result sets


Discuss the use of stored procedures in Open Database Connectivity
(ODBC) client programs





CF820 Application Programming Workshop (DB2)




Course code CF820 Skill
level Intermediate

Duration 3.0 days
Delivery type Classroom
(Hands-on labs)

Public price USD $1,725 plus tax



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.



Audience

This is an intermediate course for application programmers who need to
write embedded SQL programs in Common Business Oriented Language (COBOL)
or Programming Language One (PL/I).

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




---------------------------------------------------------------------------------
Welcome to the DB2 User Group - Seattle list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/DB2-UG-Seattle.html. From that page select "Join or Leave the list". The IDUG Listserv FAQ is at http://www.idugdb2-l.org. The DB2 User Group - Seattle List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm