Articles & Content

Archives

DB2 and the Joy of Rexx (F14)

Topic: DB2 for z/OS

Subtopic: 2009



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

OBJECTIVES:

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.



Click Here to Download

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