About this Course

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.


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.



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

Training delivered by an IBM Global Training Provider
Delivery Method

Delivery method


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 0113 220 7150 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.