Tuesday, September 13th
IBM Oakbrook Terrace IL
Session I 8:00 - 9:10
Pattern to Good ILE with RPG
Scott KlementYou've learned all of the concepts of ILE, and this has given you a lot of new options. When you go back to the office, you find it's hard to use them! They just don't fit into the way you're accustomed to writing software. In your mind, you have a pattern for how programs should be written, and to use ILE effectively, you really need to learn a new pattern. This session discusses the new pattern of writing good, reusable ILE code.
Back to Grid HTML5 Shay HoweWork on HTML5 began in 2004 to improve the existing markup langugae which has been in place for the past decade. In this decade the web has grown and evolved quite a bit, leaving web designers and developers much to ask for. HTML5 responds to those request and helps pave the way for a new frontier in front-end development. HTML5 introduces new elements, a more semantic structure, improved form functinality, better media control and more for the growing web. In this session Shay will present HTML5 and show you how to start using within your development practices today.
Back to GridUpgrading Your i5/OS to 6.1 or 7.1Pete MassielloWhen doing an upgrade to i5/OS, there is more work involved in the planning of the upgrade than in the actual upgrade itself. When you have done the planning, the actual upgrade is simple. We will cover planning tips, pre-requisites, and then post installation requirements. Your upgrade isn't complete until this last step is done. While this presentation will focus on upgrading to 6.1, 6.1.1, and/or 7.1 If you are upgrading to an earlier release (V5R3 or V5R4) we will also cover those releases.
Back to GridBuilding a Database Foundation Using SQL DDLDan Cruikshank In this session you will be introduced to using SQL Data Definition Language (DDL) to define a database that will become the foundation for all existing and future application development. You will learn how to take advantage of DB2 for i data centric constructs such as the auto-generation of data through the use of identity columns, row change timestamps, sequence objects, row ids, etc. In addition you will learn about the core fundamental items that are the basic building blocks for any relational database, and, how to add these items to an existing database without recompiling programs or changing a single line of program code utilizing the IBM recommended "measure twice, cut once" approach.
Back to Grid From STRPDM to RDPCharlie GuarinoSo you keep hearing about this great tool RDP (Rational Developer for Power Systems Software) but are somewhat intimidated by the prospect of learning it? This session is a primer on RDP basics, including new terminology, connecting to the IBM i, and getting productive with its features, with a large focus on source code editing. The rich graphical environment far exceeds what PDM and SEU can do, and you will be glad you spent the time learning how to harness its power. The more you use this tool, the more you will want to use it. This session includes a live demonstration of the product. Back to GridSession II 9:30 - 10:40
Consuming Web Services from RPG with HTTPAPIScott KlementWeb services have taken the world of IT by storm. This session discusses what a Web Service is and how the free HTTPAPI tool can be used to access (i.e. "consume") them from your RPG programs. This session provides examples of consuming currency exchange and UPS package tracking web services from RPG.Back to Grid CSS3 Shay HoweThere is no better time to be a front-end web designer and developer than now and CSS3 proves it. What used to take a handful of images and nested elements now only takes one element with just a few CSS3 properties. Not only has development speed increased but so has the potential to stretch boundaries within web design. Thanks to CSS3 we now how the ability to embed fonts, create rounded corners, add shadows and gradients, build responsive design and more all without breaking a sweat. Shay will bring life to CSS3 and show you how to do more with less code.
Back to GridWORK MANAGEMENT WITH IBM i NAVIGATORLarry BolhuisWork management has traditionally been a 'green screen' oriented task but System i Navigator has become a true contender as best tool for the job. Learn how System i Navigator can be the best tool in your box for managing your IBM i workloads.Learning Objectives:How to do the things you would normally head straight to the command line for. How to customize iNav panels to show what's missing in the command line. How to leverage big screens and extended desktops to see all the data that is important to the task.
Audience:Any IBM i administrator or developer.Back to GridAccessing SQL Functions using Rational Open Access: RPG EditionDan Cruikshank Do you want to use the advanced capabilities of ILE service programs and embedded SQL but are overwhelmed by the volume of existing programs that would have to be changed? In this session you will learn how to create program handlers that will "bridge" in SQL. All it takes is one line of code to begin using the advanced capabilities provided y embedded SQL. The session will cover what you need to know to begin creating program handlers that can transform traditional IO to SQL functions.Read Dan's Rational Open Access Abstract on IBM's developerWorks
Back to GridFrom STRPDM to RDP Advanced (including STRSDA & STRRLU)Charlie GuarinoNow that you've seen RDP in action, let's review some of the more advanced topics to get the biggest return on our time learning investment. Some topics included will be how to work offline, comparing source code and understanding what preferences can be changed to increase your productivity even further! Back to Grid
Session III 11:00 - 12:10 Choices for Integrating RPG with the WebScott KlementI've written some business logic in RPG. Now how do I make it available through a web interface? It seems like there are a million ways to web-enable an RPG program, and choosing the right technology to do so is a daunting task. The April 2008 issue of System iNEWS magazine provided a service program containing RPG business rules, and showed how to write a web front end and call that service program from three different web development languages (CGIDEV2, PHP, and Java). So readers can get a feel for the differences between them. This presentation summarizes what you'll find in that issue, and will hopefully help you along the road to deciding on a technology for your own apps.Back to GridEmail Security TechniquesDavid GibbsSpam, viruses, worms, and phishers...the internet can be a dangerous place, and email is no exception. Come learn some techniques to help defend your organization from the worst they can throw at you. Best of all, many of the tools are open source.Back to Grid ADVANCED INTERACTIVE WORK MANAGEMENTLarry BolhuisAs systems drop their hard wired 'Twinax' devices, controlling interactive system use has become more and more a problem. With POWER7 system dropping twinax altogether, the only method to gain 5250 access to the system is via Telnet. And yet have even more power to run many applications on a single system image each with differing requirements for backups and maintenance. How can the users of these systems be controlled in a flexible manner that keeps them informed about the system state yet keeps them out of what is not currently available? In this session we will learn advanced work management techniques that will help you control when and in what subsystems interactive users may work. We'll learn how to keep their batch work out of interactive systems and how to keep them informed via the signon screen. You will be given access to all the code to use on your own system.Learning Objectives:In this session, you will learn how to: Build interactive subsystems. Create routing programs which direct users to the proper subsystem, or keep them off. Stop those nasty programmers from running jobs in interactive subsystems. Customize the Sign-On screen for dynamic updates.
Audience:IBM i System administrators with Interactive ('Green Screen') Users.Back to GridSQL DML and HLL Traditional IO Coexistence Dan Cruikshank DB2 for i has the unique capability of allowing both SQL Data Manipulation Language, or DML, and High Level Language, or HLL, to access database objects. This distinction allows legacy applications using traditional IO methods to coexist with modern applications using data centric set at a time processing techniques. In this session we will compare SQL to RLA and where the strengths of each can be exploited.Back to GridFrom STRDBG to the RDP Debugger Charlie GuarinoMaking the decision to abandon the green screen development environment takes a lot of patience. Once you made the leap though you'll be very glad you did. This session examines our old confort-zone friend STRDBG and shows the similarities, differences and productivity improvements in this new world of application debugging. Back to Grid
Lunch and Vendor Expo 12:10 - 1:15
Session IV 1:15 - 2:25
RPG and the IFSScott KlementHow to get started using the Integrated File System from your RPG programs. The IFS is typically used for reading and writing "PC-style" files on the iSeries, and is an important tool for integrating with other computers or business partners. Back to GridZend Building BlocksJerome HughesThe Zend Building Blocks session will provide an overview of PHP onthe IBM i as of 2011. We'll cover Zend Server, PHP, MySQL, PHPMyAdmin,and Zend Studio while looking at strategies for getting up to speedwith these technologies. Come see what all the PHP excitement isabout!Back to GridInside HMC / LPARLarry BolhuisWe'll cover everything from the options and pieces for the HMC comes it's basic usage. We'll discuss installation, software updates, connectivity, user profiles, user capabilities, things to watch for and some things NOT to do! We'll also discuss updating IBM i's FSP using the HMC. When you leave this session, you will be comfortable with what an HMC is, and how to get one up and running, and how to use it remotely. The session is based on HMC code level 7.3.5 so if you already have an HMC but would like to see what you're missing in the newer version come on down! What we will not cover is the detail of creating and working with partitions, this is an HMC session!Learning Objectives:At the end of this session you'll be able to: 1. Understand the components and capabilities of the HMC 2. Configure the HMC and its users and security. 3. Update the HMC software. 4. Connect to the HMC remotely to manage IBM i
Audience:IBM i System Administrators with partitions. Back to GridAccessing Non-Relational Data with SQLDan Cruikshank Since it's inception as a System/38 the IBM i has always had a rich set of metadata or data about data. In this session we will review the evolution of IBM i metadata, from the outfile support of the heritage DSP cross reference commands to the complete set of SQL ready DB2 and ANSI standard system catalog views. In addition, we will walk through the process of creating your own views of other types of system or non-relational data (objects, message files, jobs, etc) and how to access this data via SQL.Back to GridProgram Application and Other TricksCharlie GuarinoA well rounded programmer not only knows how to code efficiently, but also how to research and resolve those errors that are bound to occur. Attend this fast-paced and entertaining session to learn many field-tested techniques that are essential for application recovery and problem solving. This session explores some of the many tricks and techniques available to the programmer to help improve the debugging and problem resolution cycle. Some topics covered are triggers, journaling, and ensuring your batch jobs aren't accidentally cancelled by your users. Back to GridSession V 2:45 - 3:55
RPG User Defined Functions and Table FunctionsScott KlementRPG is the best language in the world for writing business rules. But what happens when you want to use those business rules from SQL? Or from a web application that accesses your business logic through SQL? DB2 for i lets you write User Defined Functions (UDFs) in high level languages like RPG. UDFs can be called from SQL statements run from anywhere, including ad-hoc queries, SQL run from web applications, and SQL run from the embedded SQL precompilers used by RPG and other languages.UDFs can even return a table (often called a UDTF, User Defined Table Function) which lets them do the same sort of work that a stored procedure would do -- but unlike stored procedures, they can return result sets to any language, including PHP, Java, .NET and embedded SQL written in ILE RPG. UDFs are a powerful tool for any programmer's toolbox.
Back to Grid
Zend FrameworkJerome HughesZend Framework is an open source PHP web application framework thatprovides a Model View Controller (MVC) solution allowing a developerto quickly create secure custom PHP web applications by leveraging"other people's code." These well-architected object-orientedapplications can be efficiently evolved and enhanced, thanks to easyrefactoring enabled by automated testing. Concepts and code involvedin creating a Zend Framework extranet application to show customerstheir DB2 for i data interpreted in attractive web application"panels" will be discussed and demonstrated.Back to Grid
MANAGING IBM i PTFsLarry BolhuisWhat are PTFs? Why do I need them? How do I get them? Which ones do I need? In this session we will describe PTFs, Cumultative PTFs, and other PTF Groups. We'll discuss how to find out what you have, how to get them, and how to put them in place. We'll help you determine what PTF strategy is the one for you and your system.Learning Objectives:What PTFs, and PTF Groups are and why you need them. How to get PTFs and load them onto your System i. The use of Virtual Image Catalogs and Virtual DVD drives to save time and problems in the PTF process. How to determine which PTFs you need for your system.
Audience:This session is for you if you are the person in charge of administering your IBM i.Back to Grid
Introduction to RDp Plug-In Development David GibbsRDp, RDi, & WDSC are very powerful application development environments ... but that doesn't mean they can't be improved. Providing your own extensions to the framework isn't as hard as you might think. This session will provide a basic overview of how to create a plug-in, hook it into RDp, RDi, & WDSC, write it, debug it, and deploy it.Back to Grid
System Director Navigator Console Pete MassielloAs Released in IBM i 6.1, the Systems Director Navigator Console is a powerful new tool to better manage your i environment. Get expert advice for installation and set up to make sure you get this powerful tool up and running at peak efficiency. Step through the functionality of this product and learn how to leverage the Performance Data Investigator to turn the collection services data into graphs you can use to identify performance issues. Find out how to create monitors to manage your environment and various workloads as well as how to set up alarms to notify you when certain events threaten your environment. See how this tool can help you select and install Logical files on your system to improve performance. Learn about the enhancements to this valuable tool in the release of version 7.1. Back to Grid
Closing 4:05 - 5:00
Skills Required Now and In The Future Pete Massiello Abstract coming soon Back to Grid
| Scott Klement Scott Klement is the I.T. Manager and Senior Programmer at Klement Sausage Co, Inc. He is also a technical editor for System iNEWS magazine and the editor of the popular System iNetwork Programming Tips e-newsletter. His efforts to help RPG programmers improve their skills have earned Scott a System i Innovation Award from COMMON and IBM, two Gary Guthrie Awards for Excellence in Technical Writing by the staff of System iNEWS magazine, Silver and Bronze Medals from American Society of Business Publication Editors (ASBPE) (West region), and silver and bronze medals in COMMON's Speaker Excellence Hall of Fame. Scott lives with his wife and son in the Milwaukee, Wisconsin area. |
Back to Grid
|Larry Bolhuis Frankeni Technology Consulting in Middleville, MI. Larry has grown up with computers since his father became a CE in 1967. He obtained a bachelor's degree in Computer Science and soon after began working on IBM midrange equipment with the S/34 and S/36. Larry began working on the As/400 at its introduction In 1988. Larry has held more than 30 IBM certifications on the platform, including IBM Certified Advanced Technical Expert and is a contributing author to many IBM Certification tests. Larry is a frequent and award winning speaker at user groups around North America covering Systems design and management, networking and connectivity, work management, PTF, and Hardware Management Console topics. He has been awarded Gold, Silver and Bronze medals at COMMON as well as it's highest Honor, the Distinguished Service Award. He is also the inagurual winner of the Al Barsa Memorial Scholarship. Larry brings extensive IBM i and Cisco connectivity knowledge to customer engagements. He has extensive troubleshooting skills in security, networking and performance. Larry is an IBM Certified Advanced Technical Expert on System i and an IBM certified expert in Systems design and implementation including migrations, upgrades and works with systems from the smallest of the small to extremely large systems supporting dozens of partitions. For the past 15 years he has been an IBM Business Partner and is now sole proprietor for Frankeni Technology Consulting in Middleville, MI.|
Back to Grid
|Pete Massiello Pete Massiello has been working with the AS/400, iSeries, i5, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions throughout his career. He is the President of iTech Solutions Group, an IBM Advanced Business Partner delivering solutions and services to IBM i shops throughout the US. He is a member of IBM's certification test writing team, an IBM Certified Systems Expert with certifications in iSeries Design, Administration, Implementation, LPAR, and HMC management. Pete has a BS in Computer Science from Hofstra University, and an MBA from the University of New Haven. He is President of COMMON, a COMMON Hall of Fame speaker, and a frequent speaker at user groups all over the world.|
Back to Grid
|Charlie Guarino With an IT career spanning over 25 years, Charles Guarino has been a consultant for most of them. Since 1995 he has been founder and President of Central ParkData Systems, Inc., a Long Island based IBM midrange consulting company. He has published several technical and strategic articles for the IT community and has served as a member of a technical publication's Editorial Review Board. He was inducted into COMMON's Speaker Excellence Hall of Fame in 2008 and also selected as one of LISTnet's Long Island's Twenty Top Techies for 2009. Charles is currently a COMMON Application Development Subject Matter Expert and a Board Member and monthly Q&A host of LISUG, a Long Island IBM System i Users Group. Charlie specializes in ERP implementation, deep industry knowledge of distribution and warehousing, electronic data interchange (EDI). Excellent system design, project management and communication skills and is an award winning public speaker on varied technical topics.|
Back to Grid
|David Gibbs David is a Sr. Software Engineer for MKS Software (a PTC company) and Operator of midrange.com. He has been working in the IBM i market for more than 25 years. He has been running midrange.com, and it's email based discussion forums, for more than 18 years. David also serves on the COMMON Education Foundation board and the COMMON Course of Study App Dev team.|
Back to Grid
|Shay Howe As a web and user interface designer, Shay Howe believes good design can change the way users interact and utilize the web. Shay is a designer because he has a passion for solving puzzles while creating pleasing visual solutions at the same time. He lives and works in Chicago Illinois where he also co-organizes a group of web designers and developers called Refresh Chicago.|
Back to Grid
|Jerome Hughes Jerome Hughes is an experienced Software Developer who was a System/3user, programmed on the System/38, and has consulted and specialized in Change Management, SQL and integration of web technologies on the ever-evolving midrange (now IBM i on Power) and many other platforms. He has deep experience implementing software design, development, integration and change management initiatives for notable companies and clients on a wide variety of web/server/client platforms. A proven technical leader with a wide view of business systems development and web technologies, Jerome brings fresh ideas which create successful systems and integrations that help companies achieve their business goals.|
Back to Grid
|Dan Cruikshank Dan has been an IT Professional since 1972. He has consulted on a number of different project areas since joining IBM Rochester in 1988. Since 1993, Dan has been focused primarily on resolving System i application and database performance issues at several IBM customer accounts. Dan has become proficient in several application development languages including RPG (all), CL, COBOL, PL/1, UIM, system APIS, DDS, SQL (DDL and DML). In addition, he has utilized or is currently using the following IBM application development tools: PDM, ADM, WDSc, RDP and InfoSphere Data Architect Dan is in strong demand worldwide and is frequently brought in to assist with executive briefings, customized education, technical conference and user group presentations and the occaisional proof of concepts. Dan has published several articles relating to i5/OS performance analysis and database optimization. More recently he has done webinars and user group presentations on application development methodologies and database re-engineering topics (eg DDS to DDL). In essence, Dan's main role at IBM is to illuminate, educate and enable IBM i customers in how to take advantage of this remarkable system and it's built-in relational database.|
Back to Grid