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, March 30), 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.
WORKSHOP: All You Need to Know About SQL in Six Hours Speaker: Skip Marchesani, Custom Systems Corp.
This workshop will serve as an excellent introduction to SQL on the System i, iSeries, and AS/400 for those people that may not be familiar with it, or it will be an excellent review for those that need a refresher course. Live demos via the Internet are included. After attending this workshop, you will have an understanding of SQL basic concepts and theory, and will be able to create and execute simple SQL statements.
The morning part of this workshop will be spent building a firm SQL foundation. It will start with a discussion of SQL basic theory and terminology, and progress to SQL statement format and structure and the more frequently used SQL statements: SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP. It will show you how to use SQL functions such as MIN, MAX, AVG, SUM, COUNT, AS, and Subselect to query and analyze data. After covering these basics, the seminar will move on to some intermediate level topics. First it will look at the SQL software support that is available in version 5 of i5/OS so you can understand which part is included and which part is a separate licensed product. Next it will show you the groups of SQL statements used to query and work with data, to define and manage data base objects, and used for miscellaneous functions. The morning will end with a discussion of the various SQL interfaces available on the System i, iSeries, and AS/400.
The afternoon part of this workshop will take you on a detailed exploration of some more advanced SQL topics that include: Interactive SQL, the SQL Statement Processor (RUNSQLSTM command), the SQL Script Center in System i Navigator, Embedding SQL in a High Level Language program (RPG, COBOL, C), and Dynamic SQL. The workshop will conclude with a detailed discussion of how you can use SQL, in place of DDS and the native interface, to create and manage your database objects.
Pricing: $345 for members, $395 for non-members
WORKSHOP: Implementing i5/OS Security
Speaker: Carol Woodbury, SkyView Partners, Inc.
This workshop will provide the information to understand the fundamentals of security in general and i5/OS security specifically, as well as equip you to implement changes in your workplace. Attendees of all skill levels will benefit from the practical advice and real-life examples of implementing every aspect of i5/OS security.
Topics covered:
Laying the Foundation of i5/OS security, including access control options, role-based access and security-relevant system values.
Getting the Most out of your Audit Journal, including generating reports and using the information to debug problems.
Integrated File System Security, including securing and auditing.
Step by Step Approach to Implementing i5/OS security, including tips and techniques for avoiding breakage.
Case Study - implementing object level securityand changing the security scheme of an application.
Pricing: $345 for members, $395 for non-members
WORKSHOP: Modernizing RPG Applications Speaker: Paul Tuohy, ComCon
Still stuck in an RPG/400 World? Well, this exciting Workshop will show you how modern programming practices and tools can transform your old monolithic RPG applications into a modern, highly modularized form that will position your business for the future. Rather than just throw hours of theory at you, this seminar takes a sample application and follows it through the process of converting from RPG/400 or basic RPG IV to full usage of RPG IV and ILE features, modularizing the code, adding DB2 UDB features and even replacing the green-screen with a graphical or browser-based interface.
Pricing: $345 for members, $395 for non-members
WORKSHOP: (LAB) Deploying Open Community Solutions Speaker: Erwin Earley, IBM Corporation
The adoption of PHP in i5/OS provides the ability to develop customized web applications that provide dynamic content hosted on i5/OS, including DB2 data and native i5/OS resources. Along with MySQL, these two open community technologies provide the ability to implement an open community based web development and deployment stack to facilitate the deployment of cutting-edge open community solutions, such as customer relationship management (CRM), wiki(s), blogs, bulletin-boards, etc.
This workshop will give you an opportunity to become familiar with both PHP and MySQL. The first section will focus on PHP and the ability to use PHP to develop web applications leveraging i5/OS resources. The second section will look at MySQL: how to install it in i5/OS and how to setup/configure open community applications in i5/OS. The format of the workshop will be both lecture and hands-on and you will be provided with opportunities to develop customized PHP applications as well as implement open community solutions.
Pricing: $445 for members, $495 for non-members
WORKSHOP: (LAB) Getting Started with DB2 Web Query Speaker: Gene Cobb, IBM Corporation
Are you Using Query/400 and want to modernize the reports generated? Are you looking to do more advanced reporting? Do you have lots of different report needs from different end users? DB2 Web query may be just the tool to solve your needs. Come and get a jump start on DB2 Web query.
In this workshop you will learn:
How to import Query/400 queries into DB2 Web Query and "Web enable" the output.
How to easily build new reports using DB2 Web Query Report Assist.
How to build many different types of Graphs using DB2 Web Query Graph Assist.
Techniques to secure your reports and data.
Learn about advanced report development capabilities using the Developer Workbench client.
Performance optimization tools and techniques.
Pricing: $445 for members, $495 for non-members
WORKSHOP: (LAB) WDSc/RSE for RPGers Speakers: Susan Gantner and Jon Paris, Partner400
Come find out for yourself how the Remote System Explorer (RSE) part of WDSC
delivers the productivity gains it promises when building RPG applications.
You will see for yourself the Eclipse-based workbench that replaces SEU and
PDM. Find out how and why RSE is more than a colorful version of SEU. You'll
experience hands on RSE's editor, outline view, verifier, and other highly
productive programming tools. Take RSE for a spin, but beware that it can
become very addictive!
