Log in
 NESTU - An IBM i users group

*** May 21 with Paul Tuohy -Something for Everyone! YOUR PICK All-Day, Half-Day or Evening Only ***

  • 21 May 2015
  • 2:00 PM
  • Spice Grill (tentative)


  • Includes Dinner
  • Includes Dinner
  • Includes Dinner
  • Includes Dinner
  • Includes dinner
  • Includes Dinner
  • Dinner not included
  • Dinner not included

Registration is closed

Start Time: Registration at 1:30pm



Education Event with

Paul Tuohy

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:

Design Decisions

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

Using AJAX

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.

Powered by Wild Apricot. Try our all-in-one platform for easy membership management