About this course

Course code TPDBRE
Duration 2 Days

IBM's powerful procedural language, REXX, offers the mainframe professional the opportunity to code highly effective SQL queries rapidly, without the need to write complex host language programs.<br>This course describes and explains how DB2 for z/OS data may be accessed and manipulated using REXX. It also introduces the concepts of DB2 static and dynamic SQL.<br><br>This course is available 'on demand' (minimum 2 students) for public presentation and for one-company, on-site presentations.

Prerequisites

The ability to code REXX procedures. A basic understanding of Structured Query Language (SQL) would also be advantageous.

Delegates will learn how to

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

Outline

Introduction

What is REXX?; What is DB2?; Structured Query Language; Accessing DB2 data; advantages of REXX.

DB2 REXX Language Support

The REXX language; REXX DB2 language support; Controlling REXX DB2 language support interface; Connecting and disconnecting REXX procedures to a DB2 subsystem; executing SQL statements in a REXX procedure.

Introduction to SQL & DB2I

Static and dynamic SQL; Basic SELECT, INSERT, UPDATE, MERGE and DELETE syntax; handling errors; the SQL communications area; coding and testing SQL using DB2I.

Embedding SQL in REXX

Basic coding rules; REXX clauses; DB2 REXX language support; SQL coding rules; supported SQL statements; coding static and dynamic SQL in REXX; coding single and multi-row SELECTS in REXX; using parameter markers; INSERT, UPDATE, MERGE and DELETE in REXX; numeric and non-numeric literals; basic error handling; the SQL Communications Area (SQLCA); SQLCA contents; COMMIT and ROLLBACK processing.

Other SQL Options

DB2 column functions; GROUP BY and HAVING clauses; DB2 scalar functions; using joins; using nested table expressions; using UNION, INTERSECT and EXCEPT; using CASE expressions; using subqueries.

Advanced Options

Null values; indicator variables; handling null data; handling variable length character strings; passing values to REXX for inclusion in SQL; DB2 data integrity; DB2 locking; lock isolation; controlling isolation level in REXX; the SQL Descriptor Area (SQLDA); using SQLDA to retrieve data; passing data using the SQLDA; using files for input and output.

2 Days

Duration
Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method

Classroom

Face-to-face learning in the comfort of our quality nationwide centres, with free refreshments and Wi-Fi.

Find dates and prices

Online booking is currently not available for this course, to find out more please call us on 0345 074 7998 or email us at info@qa.com to discuss how we can help.

Trusted, awarded and accredited

Fully accredited to ensure we provide the highest possible standards in learning

All third party trademark rights acknowledged.