Start Time: Registration at 1:30pm
Education Event with
Your Pick - Half-Day, Full-Day or Evening Only
An RPGer's Adventures in Webland
(Starting at 2pm)
At System i Developer we like to practice what we preach. The company web site is designed for and is served from a System i. An application is used to manage conference information which, in turn, is used to generate web pages. There are also interactive web pages that communicate directly with RPG programs (e.g. selecting your session grid and repeat sessions).
This session shows you how the web site was built and how the following items played a key part in the development of the web site:
Tools Used - Rational, Navigator
Creating the Database using DDL (SQL)
Externalizing the Database
The public and the private web sites
Maintaining information (using CGIDEV2)
Making use of PHP
Generating Static Web Pages
Using and tuning embedded SQL
ILE by Example
(Starting at 4pm)
This session takes a small sample RPG IV application and examines the issues involved in integrating it into an ILE application. This includes decisions on Dynamic Binding, Static Binding, Bind by Copy or Reference, structure of Service Programs, Binder Language, Binding Directories and Activation Groups.
By the end of this session, attendees will be able to:
1. Understand the benefits of ILE
2. Understand the decision process in using components of ILE
Dinner about 6pm
I Didn't Know You Could Do That Using SQL
(Starting at 7pm)
You have started to master SQL but you have a sneaky suspicion that there might be more to it.
In this session you will learn valuable and time saving techniques with SQL that let you avoid writing code. You will learn how to use SQL Subquery or Subselect in an SQL SELECT, INSERT, UPDATE, DELETE or CREATE TABLE statement to reference multiple tables without having to do a join of the tables involved. You will see how to use CASE and UNION statements, Common Table Expressions (CTEs) and where to use Full Outer Join and Hidden Time Stamp columns.
This session is based on the SQL function available in V5R4, V6R1, and V7R1 of OS/400 or i5/OS, assumes you have a basic understanding of relational database concepts and SQL.