Nous contacter
Private area
-Accueil- -Nouvelles- -Agenda- -Meetings- -Divers-
November 2007
Luxembourg, November 7th, 2007
Common Europe Luxembourg is proud to invite you at its next event :
COMMON/ITSO Roadshow '07
featuring Jarek Miszczyk and Claus Weiss from ITSO Rochester
Agenda - November 7th 2007, at Hotel Novotel Kirchberg Luxembourg

On November 7th 2007, the COMMON/ITSO Roadshow will be held at Novotel Kirchberg-Luxembourg : book your agenda today !

The experts from Rochester will propose 5 technical topics, presented in english, focused on DB2/UDB and New Development Tools.

  • From 08:30 to 09:00 : Members Welcome - Coffee
  • From 09:00 to 10:00 : Session #1 by Jarek Miszczyk
  • From 10:00 to 10:15 : Coffee Break
  • From 10:15 to 11:15 : Session #2 by Jarek Miszczyk
  • From 11:15 to 11:30 : Coffee Break
  • From 11:30 to 12:30 : Session #3 by Jarek Miszczyk
  • From 12:30 to 14:00 : Sandwich Lunch
  • From 14:00 to 15:00 : Session #4 by Claus Weiss
  • From 15:00 to 15:15 : Coffee Break
  • From 15:15 to 16:15 : Session #5 by Claus Weiss
  • Starting 16:15 : Event Closing - Drink

Un détail des présentation est disponible ci-après ...
COMMON/ITSO Roadshow '07 - About logistics

You'll be free to follow the session(s) that interest you, individually or the whole set !
However, with the aim to achieve the best organization, we ask you to register to the session(s) you intend to participate.

Registrations will be closed on Monday, 5th of November !
COMMON/ITSO Roadshow '07 - About speakers

About Jarek Miszczyk

Jarek Miszczyk is a Senior Software Engineer at the ISV Solutions Enablement organization in Rochester, MN. He has been with IBM for 15 years. His mission is to provide consulting services to ISVs, large IBM Clients, and other IBM organizations on DB2 for i5/OS related issues. He also writes extensively and teaches IBM classes in all areas of the System i database. Before joining the ISV Solutions Enablement organization in 2000, he has worked for several years at the IBM ITSO in Rochester, where he was the leading author of several popular database Redbooks. Jarek holds a Masters degree in computer science and has over 18 years of experience in the computer field. His areas of expertise include cross-platform database programming, database performance tuning, and database integration with emerging technologies (XML, Java, Microsoft .NET).

About Claus Weiss

Claus Weiss is an advisory software consultant with the Rational Software System i – Ecosystem team at the IBM Canada Toronto Laboratory. He has degrees in industrial engineering and computer science from the University of Hamburg in Germany. He worked as a systems engineer with IBM Germany and joined the IBM Toronto Laboratory in 1984. He was a developer and team leader for System/38 development tools. He was a member of the Design Control Group for the AS/400 development tools. He has worked as a consultant for System i Application Development for the past 10 years specializing in Visual Tools. Claus is a frequent speaker at COMMON and other System i conferences. He is a 6 time winner of COMMON’s Speaker Excellence award. He is the lead author of the book Understanding the IBM WebFacing Tool, published by IBM Press, and has co-authored several IBM Redbooks.
COMMON/ITSO Roadshow '07 - More about the agenda

Session #1 - The ABCs of Coding High Performance SQL Apps - by Jarek Miszczyk

If you are thinking about using or have used SQL on the System i, then you need to understand how the System i database engine handles SQL requests. This session covers performance concepts that apply to any SQL interface (embedded SQL in applications, JDBC, ODBC).

In this session, youw will learn:
  • The basics of access plans, open data paths (ODPs), and reusable ODPs.
  • How these concepts directly affect performance.
  • How to code high-performing SQL on the System i.
Presentation au format PDF : Common 2007/11-A

Session #2 - DB2/UDB : SQL Stored Procedures - by Jarek Miszczyk

Stored Procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedural language that is comparable to those of other DB Servers such as Oracle & SQL Server.

By the end of this session, attendees will be able to:
  • How to create and invoke an SQL Stored Procedure.
  • Understand error handling techniques in SQL Procedures.
  • How to move an SQL stored procedure into production.
Presentation au format PDF : Common 2007/11-B

Session #3 - DB2/UDB : SQL Triggers and Other New Trigger Functions - by Jarek Miszczyk

The announcement of Version 5 Release 1 of OS/400 brought with it significant new capabilities for Triggers in DB2 for i5/OS.

Come to this session and learn about:
  • SQL Triggers
  • Column-Level Triggers
  • Trigger Mode
  • Trigger Condition
  • Trigger Body
  • Increase in maximum number of Triggers per Table
  • System Wide Trigger Catalog
  • New Command to Enable and Disable Triggers
Presentation au format PDF : Common 2007/11-C

Session #4 - Introduction to Remote System Explorer - by Claus Weiss

The Remote Systems Explorer (RSE) is the development environment within WebSphere Development Studio Client that allows you to develop RPG and COBOL applications. This development tool is the 21st century follow-on to the world of SEU, SDA, PDM, etc and even CODE/ 400. All the things that a developer might wish were possible with a green screen are in the RSE and some that you haven't even thought of yet!! Other benefits include improving programmer productivity and morale, off-loading host development workload and allowing existing applications to be maintained more effectively.

Presentation au format PDF : Common 2007/11-D

Session #5 - Remote System Explorer (RSE) Advanced Topics - by Claus Weiss

The Remote System Explorer in WDSC provides rich functions for creating and maintaining of RPG, COBOL, DDS, and CL code. If you understand the basics, then come to this session to learn how to customize the environment. Learn also about Projects. There are many additional functions and features that can make your day to day development work even more effective and more fun.

Presentation au format PDF : Common/2007/11-E