Pre-Conference Workshops
Sunday, March 26, 2006 * Minneapolis, Minn.
Get a "JUMP START" on your iSeries education with an
all-day pre-conference workshop
When you register for COMMON's Spring 2006 Conference & Expo in Minneapolis, consider signing up for additional education by registering for an all-day pre-conference workshop. In-depth technical workshops will take place on the first day of the conference (Sunday, March 26), beginning at 8 a.m. Each will break from noon to 1:30 p.m. so that attendees can go to the conference Opening Session. The workshops will end before the start of the iSeries Town Meeting at 4 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. Workshops may be subject to change.
Choose from the following:
WORKSHOP #1: Beyond the Basics with SQL Speaker: Skip Marchesani,
Custom Systems Corp. Fee: $295
You finally have a grasp of SQL (Structured Query Language) basics. In fact, you are comfortable doing the simple things with SELECT, UPDATE, INSERT, and DELETE. However, when you try to go beyond the basics, attempting more complex SQL statements, it is a challenging and/or a frustrating experience. If this is your experience, this six-hour workshop is for you. Bottom line is that this workshop is designed for those people that have a good understanding of SQL basics and want to take their SQL skills to the next level.
Morning: The workshop will start with a quick review of some SQL basics and then progress to using SQL built in functions for data manipulation and analysis to derive a new column, name a derived column, reformat data, change data types, summarize data, and more. Next you will explore basic subselect, scalar subselect, and the more advanced forms of subselect; and see how a single SQL statement with subselect can be used in place an RPG or Cobol (or C) program that would require many lines of code.
Afternoon: The afternoon part of this workshop will show how the information from the morning session can be put to work for you. You will learn how to embed SQL in an RPG or Cobol (or C) Program including: embedded SQL source statement format, processing single and multiple rows using embedded SQL, prompting of SQL statements within an RPG or Cobol source program, error handling, and program compilation tips. Next you will review the SQL procedure language and how it is used to create SQL stored procedures and SQL triggers. You will understand the difference between an external
procedure and an SQL procedure, and an external trigger and an SQL trigger. You will explore SQL triggers in detail and learn the difference between column, row, and statement level triggers, and you will learn the various parts that make up an SQL trigger and how to code the SQL trigger body.
After attending this workshop, you will understand how to use SQL built in functions to do data manipulation and analysis, and how to use subselect and scalar subselect to write complex SQL statements that reference multiple tables without having to do a table join. You will also understand how to embed and compile SQL statements in an RPG or Cobol (or C) program, create and use SQL (and external) stored procedures, and create and use SQL triggers. Skip Marchesani will combine lecture with live demonstrations (via the internet) to illustrate the SQL concepts and functions discussed in this seminar.
WORKSHOP #2 ( LAB): Getting Started with SOA on System i5 Speaker: Pat Fleming, IBM Corporation Fee: $395
Service Oriented Architecture (SOA) is about delivering business functions or tasks as re-usable components called services. Creating and accessing these services can be accomplished many different ways and iSeries is well positioned to help any sized company adopt this technology quickly.
This workshop will show you different ways to create services from traditional i5/OS programs. With lecture and hands on labs you will develop the skills necessary to create and consume web services from RPG. You will also leverage tools you probably already have like WebSphere Development Studio Client and the XML Toolkit for iSeries to accomplish these tasks. This allows you to simplify your Service Oriented Architecture and better position your company for change and future growth. By the end of the workshop you will have learned how to:
Create a web service from an existing ILE service program
Create a web service from a 5250 application using HATS
Call a web service from an existing RPG Program
Create a new application with EGL and generate a web services interface
Create web service accessing DB2 data
Call an RPG web service from a PHP program
Leverage new tools like WBI Server Express to choreograph business processes
WORKSHOP #3 (LAB): Liberating Your RPG Speaker: Jon Paris, Susan Gantner, Partner400 Fee: $395
With the advent of the V5R1 release of RPG IV, IBM finally made it possible to code completely free form calculation specifications. Simply knowing the syntax required is not enough though. A thorough understanding of many features introduced in earlier release of the language is also essential.
This workshop will provide you with all of the knowledge that you require in order to fully exploit /Free-form coding. The lecture is reinforced with hands-on exercises to ensure that you have everything you need to know to allow you to introduce the joys of free-form coding to your installation.
Topic areas to be covered include
Advantages of free-form programming
The basic syntax rules of /Free
Overview of the operation codes supported in /Free
The Built-in-Functions and other techniques used to replace unsupported operation codes.
Use of the “E” operation code extender and the %Error built-in
Coding Database I/O operations in free-form
Including new options that can only be used in /Free form
Display file support and “indicator-less” programming
CALLP and Prototyping for program calls
Coding RPG with style
WORKSHOP #4 (LAB): Everything You NEED TO KNOW About HMC! Speaker: John Davenport, IBM Corporation Fee: $395
Want to know what the Hardware Management Console (HMC) for IBM eServer i5 servers is all about? Do you want to learn how to install and configure it? Do you want to learn how to use it efficiently? Then you better register for this "HMC journey" as guided by John Davenport. Start the journey with an overview of HMC functions, followed by detailed information on how to install a new HMC, configure network settings and HMC user profiles, create a connection to a managed i5 system, and upgrade an existing HMC. This journey will include exploring the HMC's Graphical User Interface (GUI) to manage an eServer i5 system. Through online presentations and quizzes, develop the basic skills for backing up HMC and managed system configuration data, performing HMC and microcode software maintenance, and creating logical partitions (LPAR). Additionally, learn how to configure the HMC as a Service Focal Point, enabling the service call home function and to add or replace hardware. By the time you complete this extensive "journey", you will have the knowledge you need to take full advantage of HMC in your IT shop.
