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.
DB2 for z/OS: Using REXX
The ability to code REXX procedures. A basic understanding of Structured Query Language (SQL) would also be advantageous.
- 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.
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 firstname.lastname@example.org to discuss how we can help.
Fully accredited to ensure we provide the highest possible standards in learning