Topic: Darn... Cursored Again! - Using SQL & Cursors in Your Programs!
| Date: | Tuesday May 19th |
| Time: | 6:00 EDT |
| Location: | GoToMeeting Only |
| Speaker: | Jim Buck |
| Notes: | Connect by GoToMeeting from your computer, tablet or smartphone. You can also dial in using your phone. (For supported devices, tap a one-touch number below to join instantly.) United States: +1 (646) 749-3117 Canada: +1 (647) 497-9373 - One-touch: +1 (646) 749-3117,569927301# Access Code: 569-927-301 New to GoToMeeting? Get the app now and be ready when your first meeting starts. |
| Presentation: | Darn... Cursored Again! - Using SQL & Cursors in Your Programs! |
This session demonstrates the use of SQL in your programs. After a short discussion of the differences between Dynamic and Static SQL in your programs; we demonstrate the important concepts in creating a robust SQL program. Topics include host variables, data-structures, error trapping and using tables with SQL.
Learning Objectives:
- Internalize the benefits of using SQL in your programs.
- Correct use of SQL and CURSORS in your RPG Programs
- Understand error handling in SQL subprocedures and service programs
About the Presenter
Jim is the president and founder of imPower Technologies where he provides professional IBM i online/onsite training (imPowerTechnologies.com) . He is active in the IBM i community working to help companies train their employees in the latest IBM technologies and helps companies develop the next generation of IBM i professionals. Jim Buck’s career in IT has spanned more than 36 years, primarily in college education, manufacturing, and healthcare industries. Past president (13 years) of the Wisconsin Midrange Computer Professional Association (www.wmcpa.org) and has served on several teams developing IBM and COMMON certification tests. Jim has co-authored several IBM i books with Bryan Meyers that are used by many companies and in colleges worldwide, “Programming in ILE RPG” 5th Edition being the latest in 2015. Other accomplishments include; recipient of the 2007 IBM System i Innovation – Education Excellence Award, 2014 COMMON Presidents Award and named 2013/2016/2017/2018 IBM Champion – Power Systems.