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