SQL Tricks and Techniques on the iSeries and AS/400
Skip Marchesani
SQL Tricks and Techniques on the iSeries and AS/400
Do you know that there are at least 11 different ways to execute SQL on the AS/400 and iSeries? Do you know how to execute an SQL statement in a CL program? If not, you need to come to this session to leam SQL's tricks and see how it can improve your productivity as an application developer. This session will take an in depth look at SQL as a tool on the AS/400 and iSeries and will show many of the ways SQL can be used. It will review the different types of SQL statements, explore interactive SQL, embedding SQL in RPG programs. Query Manager, the SQL Statement Processor, Predictive Query Governor, join support, and more. A basic understanding of SQL is required.
Skip Marchesani retired from IBM after 25 years and is now a consultant with Custom Systems Corp, an IBM Business partner. Recognized as an industry expert on DB2/400 and author of the book 'DB2/400': The New AS/400 Database', he specializes in providing customized education for any area of the AS/400, does database design and design reviews, and general AS/400 consulting for interested clients. He has been a speaker for user groups, technical conferences, and AS/400 audiences around the world. Skip is an award winning COMMON speaker and has received their Distinguished Service Award.