Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

Workshops

VIEWS: 43 PAGES: 4

									Workshops
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.


                                                                            WORKSHOP 1: Beyond the Basics
                                                                            with SQL
                                                                            11MA: Sun 8 - 4, 201 A/B, Minneapolis Conv Ctr

                                                                                              This workshop will be held from 8:00am -
                                                                                              4:00pm with the following breaks:
                                                                                              10:15-10:30am and 11:45-1:30pm.

                                                                                              Attendance at this workshop is by registration
                                                                                              only and additional fee of $295.00. Register for
                                                                                              the workshop via the conference registration
                                                                                              form, or call 800-777-6734.

                                                                                              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
ID:500148
                 to create SQL stored procedures and SQL
                 triggers. You will understand the difference
Level:
                 between an external procedure and an SQL
Advanced
                 procedure, and an external trigger and an SQL
                 trigger.
Course:
                 You will explore SQL triggers in detail and learn
Workshops
                 the difference between column, row, and
                 statement level triggers, and you will learn the
Speaker:
                 various parts that make up an SQL trigger and
Skip
                 how to code the SQL trigger body.
Marchesani
Custom Systems
Corporation      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.




                                 COMMON S06 Spring 2006, page 1
WORKSHOP 2 (LAB): Getting Started                                    WORKSHOP 3 (LAB): Liberating Your
with SOA on System i5                                                RPG
11LA: Sun 8 - 4, 200 A, Minneapolis Conv Ctr                         11LB: Sun 8 - 4, 200 B, Minneapolis Conv Ctr
ID:500149                                                            ID:500150
                  This workshop will be held from 8:00 am - 4:00                   This workshop will be held from 8:00 am - 4:00
Level:            pm with breaks from 10:15-10:30 am & 11:45         Level:        pm with breaks from 10:15-10:30 am & 11:45
All               am-1:30 pm.                                        All           am-1:30 pm.

Course:           Attendance at this workshop is by registration     Course:       Attendance at this workshop is by registration
Workshops         only and additional fee of $395.00. Register for   Workshops     only and additional fee of $395.00. Register for
                  the workshop via the conference registration                     the workshop via the conference registration
Speakers:         form, or call 800-777-6734.                        Speakers:     form, or call 800-777-6734.
Pat Fleming                                                          Jon Paris
IBM Corporation   Service Oriented Architecture (SOA) is about       Partner400    With the advent of the V5R1 release of RPG IV,
George            delivering business functions or tasks as          Susan         IBM finally made it possible to code completely
Weaver            re-usable components called services. Creating     Gantner       free form calculation specifications. Simply
IBM Corporation                                                      Partner400
                  and accessing these services can be                              knowing the syntax required is not enough
Elena Lowery
                  accomplished many different ways and iSeries is                  though. A thorough understanding of many
IBM Corporation
Nitin Raut        well positioned to help any sized company adopt                  features introduced in earlier release of the
IBM Corporation   this technology quickly.                                         language is also essential.

                  This workshop will show you different ways to                    This workshop will provide you with all of the
                  create services from traditional i5/OS programs.                 knowledge that you require in order to fully
                  With lecture and hands on labs you will develop                  exploit /Free-form coding. The lecture is
                  the skills necessary to create and consume web                   reinforced with hands-on exercises to ensure
                  services from RPG. You will also leverage tools                  that you have everything you need to know to
                  you probably already have like WebSphere                         allow you to introduce the joys of free-form
                  Development Studio Client and the XML Toolkit                    coding to your installation.
                  for iSeries to accomplish these tasks. This
                  allows you to simplify your Service Oriented                     Topic areas to be covered include:
                  Architecture and better position your company                    -Advantages of free-form programming
                  for change and future growth.                                    -The basic syntax rules of /Free
                                                                                   -Overview of the operation codes supported in /
                  By the end of the workshop you will have                         Free
                  learned how to:                                                  -The Built-in-Functions and other techniques
                  1. Create a web service from an existing ILE                     used to replace unsupported operation codes.
                  service program                                                  -Use of the "E" operation code extender and the
                  2. Create a web service from a 5250 application                  %Error built-in
                  using HATS                                                       -Coding Database I/O operations in free-form
                  3. Call a web service from an existing RPG                       -Including new options that can only be used in /
                  Program                                                          Free form
                  4. Create a new application with EGL and                         -Display file support and "indicator-less"
                  generate a web services interface                                programming
                  5. Create web service accessing DB2 data                         -CALLP and Prototyping for program calls
                  6. Call an RPG web service from a PHP                            -Coding RPG with style
                  program
                  7.Leverage new tools like WBI Server Express
                  to choreograph business processes




                                                                                                  COMMON S06 Spring 2006, page 2
WORKSHOP 4 (LAB): Everything You
NEED TO KNOW About HMC!
11LC: Sun 8 - 4, 200 C, Minneapolis Conv Ctr
ID:500151
                  This workshop will be held from 8:00 am - 4:00
Level:            pm with breaks from 10:15-10:30 am & 11:45
All               am-1:30 pm.

Course:           Attendance at this workshop is by registration
Workshops         only and additional fee of $395.00. Register for
                  the workshop via the conference registration
Speaker:          form, or call 800-777-6734.
John
Davenport         Want to know what the Hardware Management
IBM Corporation   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.




                                                                      COMMON S06 Spring 2006, page 3

								
To top