Articles & Content


DB2 and the Joy of Rexx (F14)

Topic: 2009 EU

Subtopic: DB2 for z/OS

DATE: 2009-10-7 (17:00 - 18:00)
SPEAKERS: Ron Brown (Ronek Consulting)

This presentation aims to cover the use of Rexx and O-Rexx languages to access DB2 on z/OS and LUW platforms. It will give a brief description of the languages, their standard and non-standard interfaces to DB2, explain some advanced methods of coding for DB2 access, suggest solutions to some common problems, and provide a set of useful code fragment samples.

EXP. LEVEL: Intermediate,Advanced


A brief history of Rexx and O-Rexx languages on VM, z/OS and LUW, including the differences from other languages and the advantages of using Rexx.

Standard interfaces from Rexx to DB2 for SQL, commands, IFI and stored procedures on z/OS and LUW.

Advanced invocation and debugging of SQL on z/OS, including third-party interfaces, DSNREXX considerations and invocation of DSNTIAR.

Invocation and debugging of SQL on LUW, including SQLEXEC considerations and code for transporting cross platforms.

Samples of Rexx-DB2 code showing: cross platform code, Unicode considerations, multi-row fetch, DBRM interpretation, use of 3 part object names, DB2 message processing, SPUFI invocation and DB2 command processing.

This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.