Add in-depth learning with a Pre-Conference
Workshop!
When you register for the conference, consider signing
up for additional education by registering for an all-day
pre-conference workshop (additional fee required).
In-depth technical workshops are either labs or lecture,
and take place on the first day of the conference
(Sunday, April 26), beginning at 8 a.m. There will be a
morning coffee break, a lunch break, and all workshops
will end at 3:15 p.m., in time for the conference Opening
Session at 3:30 p.m.
You can sign up for the workshop of your choice when you register for the conference. Space in each workshop is limited and available on a first-come, first-served
basis.
LAB - Getting Started with DB2 Web Query Speaker: Gene Cobb, IBM
This session is designed for the developer and database administrator who would like a modern query and reporting tool to deliver timely and quality reports, graphs, and dashboards to meet the reporting requirements of their company. This session introduces, DB2 Web Query for IBM i, the strategic query and reporting tool for the IBM i operating system. The instructor uses lecture, demonstrations, and labs to help attendees understand the capabilities of the new product and the steps and skills necessary to deliver this content back home in their production environment.
Learning Objectives:
The attendee will learn how to create metadata and understand the advantages of this abstraction layer.
The attendee will learn how to take existing Query/400 objects and "webify" them using the DB2 Web Query import tools.
The attendee will learn how to create reports and graphs using the DB2 Web Query development tools.
The attendee will learn best practices, several tips and techniques to enhance the implementation, and pitfalls to avoid.
Workshop Syllabus/Agenda:
DB2 Web Query demo
Metadata
Creating reports and graphs using the development tools
Modern report output formats such as HTML, Excel spreadsheets, PDF, and Active Reports
DB2 Web Query Tips and techniques.
Audience: This workshop is designed for programmers and database administrators who understand the query and reporting needs of their company and need a modern tool to deliver those requirements. Attendees should have an understanding of the DB2 for i database and the general database design of their company. Knowledge of SQL is helpful but not required.
Pricing: $445 for members, $495 for non-members
RPG Meets the Web Speaker: Paul Tuohy, ComCon
What is the fastest way to get your System i applications talking to the web? You don't need Java, ASPs, JSPs or Websphere. You already have everything you need in RPG IV, the System i HTTP Server and CGIDEV2 a free tool from IBM to enable RPG programs to interact easily with a browser.
Learning Objectives:
Understand and write basic HTML
Understand how a browser communicates with a program through the HTTP server powered by Apache (including basic configuration).
Understand the basic principle of the CGI APIs (and why it is better not to use them directly)
Use the CGIDEV2 APIs.
Code RPG programs to write data to and read data from a web page using CGIDEV2 and externally defined HTML.
Write the equivalent of print programs, subfile programs, and maintenance programs.
Understand how Javascript and AJAX may have a part to play.
Workshop Syllabus/Agenda:
Introduction
System i HTTP Server powered by Apache.
Basic HTML
The System i CGI APIs.
Printing to the Web
Interacting with a Browser
HTML Forms
External HTML with CGIDEV2
Debugging
Considerations for Javascript and AJAX
Audience: Programmers and Analysts who wish to leverage their existing skills to enable them to write programs to interact with the web.
