Speaker: David Larsen, Software Engineer at Lagoon Corporation
Topic: SQL Tips and Techniques on the IBM i
Date: Wednesday, January 14th, 2015
Time: 11:00 a.m. – 12:00 noon
Location: Murray City Offices (City Council Chambers), 5025 South State Street, Murray, Utah.
Our user group presentation this month will be by David Larsen. He will be introducing the basics of SQL and its implementation on the IBM i. For some of you, SQL is a very familiar tool you use every day. But for others it is a mystery of what it actually is and why you would want to use it. David will give us an overview of SQL with examples of SQL generation with System Navigator, some embedded SQL examples and many tips on how to get started using SQL. So come and learn how to use this very powerful tool.
David Larson is currently a software engineer at Lagoon Corporation. Previously he was the Director of Information Systems at Murray City for 16 years and also served as IT Director and Manager with other companies. He is also a founding member of the user group and has worked on the IBM i for many years.
Our October meeting will be held on Wednesday, October 8th at 11:00 a.m. at the Murray City Offices (City Council Chambers), 5025 South State Street. Everyone is welcome to attend.
NOTE: This will be a 90 minute session so plan accordingly. Also, lunch will be served!
Topic: SQL for the System Admin: IBM i Commands, APIs and the role of DB2 for i and SQL
Speaker: Scott Fortsie, DB2 for i Business Architect (Via Webcast)
This presentation will focus on the ways in which SQL on IBM i can be used to accomplish a number of tasks that are unrelated to traditional uses of SQL. Although the central theme of these capabilities will be systems administration, benefits can be realized beyond that topic.
You’ll learn about the SQL capabilities that exist for systems management purposes. This presentation will include working SQL examples and some compelling reasons to add SQL to your set of skills.
Note that this session has been updated for IBM i 7.2 and will include a preview of the new services coming to 6.1, 7.1 and 7.2 in 4Q/2014.
Here is the basic outline for this presentation:
Traditional IBM i Interfaces
SQL is Key for IBM i
SQL’s TCP/IP Services
SQL’s Work Management Detail
Security with SQL
SQL Storage Devices
SQL Journal Details
Find SQL Catalogs and Services
Get Going with SQL on IBM i
There are a lot of great new SQL-based services for you to use on IBM i 7.1 (and 6.1). By coming to this presentation you will position yourself for success by having the recipe to get you started in learning and implementing SQL.
Scott Forstie is the DB2 for i Business Architect, SQL Development team leader, and IBM i developerWorks content manager. In addition to his development roles, he is a frequently published author on SQL and database topics. (http://iprodeveloper.com/author/scott-forstie) He has worked for IBM nearly 25 years, working primarily on IBM i. Scott can be reached by email at email@example.com or followed on Twitter at @Forstie_IBMi, where he is trying to mix DB2 for i, business, and social.