 |
| |
| home >> speakers >> Howard Arner |
| |
|
Howard Arner, Client Server Development, Inc.
Howard F. Arner, Jr. is the Vice President of Client Server Development, Inc. and has over twenty- five years of IT management and programming experience. He has created systems for industries such as health care, highway construction project management, hazardous waste disposal, media advertisement statistical reporting, hospital quality assurance and facilities management. Mr. Arner has chaired several academic and industry conferences on the Prolog language, knowledge discovery and data mining and has published several peer reviewed papers. In addition to his work at CSD, he was the editor of the Microsoft Computing section of Midrange Computing magazine and has published over 250 articles in the iSeries trade press. He is also the author of the book, iSeries and AS/400 SQL at Work. Mr. Arner is recognized as an industry expert on the DB2 platform, its implementation on the System i and client server based data access methodologies on the iSeries platform. He currently programs in C#, F#, C++ and VB on the Microsoft .Net platform and in C on the System i. |
|
SATURDAY SEMINAR: Advanced i5 SQL
Howard’s Saturday seminar begins with a intense look at how joins can be coded into queries on the i5. You will learn how to join tables to other tables, and queries to other queries in order to create powerful reports with a single SQL statement. Howard will then teach you how the i5 Query Optimizer looks at a query, creates an execution plan and what information it uses in making these choices. He will then show you techniques that you can use to better understand the data on your system and that will help you improve SQL performance at your shop. Next he will cover how to use the i5 Database Monitor program to spot misbehaving queries and programs and impart the techniques for dealing with this incorrigible behavior. Finally, the day ends with a through review of advanced features like the creation of stored procedures, user defined functions, triggers and creation of summary data cubes on the i5.
Morning:
- Basics of set theory
- Understanding Inner, Outer, Exception and Cartesian Joins
- Self Joins
- Optimizer Information in the Job Log
Afternoon:
- Using the Database Monitor Program
- Exploring Data about your Data: Metadata!
- Advanced Reporting Techniques
- Creating Procedures and Functions to do mundane tasks
|
Really Understanding Joins
This session takes you through all the types of join operations available on the iSeries. Along the way, you will review how the database sees join operations and how they relate back to set theory and relational algebra. It may sound geeky but I guarantee that you will learn things about joining sets and how the iSeries optimizer thinks. You will learn how to write queries that do percent to group and percent to total, how to effectively use Cartesian products, how the optimizer views outer and inner joins, how to perform exception joins and how to join tables to query results. All of this material is presented as easy to understand queries that actually solve real world problems. |
Programming Procedures and User Defined Functions
The iSeries supports the PSM (persistent stored modules) language as the language for defining stored procedures, user-defined functions, and triggers. In fact, this language is portable to all versions of DB2 on all operating systems, and is very similar to the procedure languages in products like SQL Server, MySQL, and Oracle. This session will introduce you to the PSM language and show you how to use PSM to define stored procedures, triggers and user defined functions. You will learn how to code a function to convert JD Edwards dates to DB2 dates, calculate percentage change, code a procedure to call CL programs, and create functions that return tables of information. A passing familiarity with SQL is required. |
Using Visual Studio Express to Program Graphical .Net Applications
Visual Basic 2005 is easy and a very powerful language that is included in the Visual Studio line of tools. Visual Basic Express Edition makes web and Windows development easy by allowing you to graphically design and program .Net applications. Did you know that Microsoft gives this product away for FREE? Visual Basic allows you to program Windows and Web applications that can talk to the i5 database vis Client Access. In this session, Howard introduces you to Visual Basic and walks you through the development of a simple i5 query tool. The tool allows you to execute a query, view its results and export the data directly into Excel via automation. You get to take the source code and a copy of Visual Studio home with you so that you can explore the code at your leisure, and extend the query tool for your own use! During the session Howard will also cover aspects of web development and deployment with Visual Studio. |
Making an Intranet to Document Your iSeries
In this session, Howard will demonstrate how to use Visual Studio to create a web site that documents all you’re your physical and logical files on your iSeries. Not only will you take home a useful tool that you can use at your shop, but you will be introduced to creating data driven websites using Microsoft’s .Net programming languages and the Visual Studio Express tool. Howard shows you how to leverage the metadata that is already on your iSeries using SQL Queries and stored procedures to create a database knowledge base for your development team and end users. |
|
| |
| |
