2009 EU

DB2 and the Joy of Rexx (F14) 

Oct 07, 2009 03:00 PM

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.

pdf file
EU09F14.pdf   404 KB   1 version
Uploaded - Jun 05, 2020

Related Entries and Links

No Related Resource entered.