Articles & Content
Topic: 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.
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.