DB2 for z/OS: Using REXX

Objectives
On successful completion of this course, attendees will be able to:

• list the benefits of using REXX in a DB2 environment
• manipulate DB2 data using SQL
• code SQL requests using REXX to select, insert, update and delete DB2 data
• identify data integrity issues.

Who Should Attend
IT professionals needing to access DB2 data using REXX.
Prerequisites
The ability to code REXX procedures. A basic understanding of Structured Query Language (SQL) would also be advantageous.
Duration
2 days

Course Code
DBRE
Contents
Introduction
Why use REXX with DB2?: advantages, potential pitfalls.
This segment examines the benefits of using REXX in a DB2 environment.

DB2 REXX language support
Connecting and disconnecting REXX procedures to a DB2 subsystem; executing SQL statements in a REXX procedure.
This segment discusses how a REXX procedure communicates with a DB2 subsystem.

SQL overview
Static and dynamic SQL; SELECT, INSERT, UPDATE and DELETE syntax; SQL communications area.
This segment describes the main SQL data manipulation language syntax.

Embedding SQL statements in a REXX procedure
Using the EXECSQL statement; using cursors; REXX host variables and data types.
This segment discusses how SQL statements are embedded into a REXX procedure and how data values may be passed toand from the DB2 subsystem using REXX.

Using indicator variables
Null values; indicator variables; handling null data.
This segment discusses the handling of null values.

Other considerations
Data integrity issues; setting isolation levels.
This segment discusses other issues such as data integrity and how this is controlled.