DB2 and SQL for Programmers (3 days)

Designed for: Applications programmers who will be using SQL

Primary Objective: To use SQL to access and manipulate data held in DB2 tables

Introduction
Comparison of DB2 tables with VSAM files and hierarchical databases (e.g. IMS, TOTAL).  Tasks and personnel involved in implementing a DB2 system.  Sample uses of DB2.

Tables
How data is arranged; views; basic table design, table splitting.  Typical disk requirements.  Physical storage considerations.

Accessing DB2 data
How programs can access DB2, SQL language; precompile and BIND process; EXPLAIN.  Access from TSO and batch.  Functions and use of QMF, DXT, DBEDIT, DB2I and SPUFI.  SQL communication area.

SQL programming
SELECT statement, predicates, join queries; column functions: BETWEEN, NULL, LIKE, EXISTS, IN; scalar functions; UPDATE, DELETE, INSERT.  Dynamic SQL.  Outer joins.

Security considerations
Facilities which can be controlled.  Overview of locking. COMMIT, ROLLBACK

OS/390, JCL, DB2, CICS, VSAM, REXX

Home Page  |  About Oakwood  |  VSE/ESA, JCL, POWER  |  UNIX, Scripts, INGRES  |  COBOL, PL/1, Assembler  |  Easytrieve, SELCOPY  |  3rd Party Software  |  New Graduate Schemes

oakcomp@globalnet.co.uk