Category Archives: Meeting

  • 0

2017 March Meeting: Database Revitalization

Category : Meeting

It has been more than a decade since IBM published the redbook which covered DDS to DDL modernization.  In the same period, IBM has shipped numerous releases and many technology refreshes which include many enhancements that simplify database reengineering and make SQL more attractive as a data centric development language.  So what does modernization mean today?  Is it a simple matter of transforming our objects from their old DDS definitions to new SQL definitions?  It can and should be so much more.  This presentation provides an overview of “low impact” modernization which includes both data definition and data access.  It also describes the core fundamentals which can revitalize your database while improving programmer productivity and database integrity.  This includes datacentric programming, autogenerated columns, constraints, writing better set-based SQL, OLAP enhancements, programming in SQL, and more.  The emphasis will be on pragmatic and practical solutions which you can start implementing now to create a robust modern database that is extendable and scalable.

Jim Denton is a senior consultant in the Lab Services DB2 for i team where his responsibilities include both customized skills transfer and hands on consulting.  Jim specializes in SQL performance, data-centric programming, and database modernization.  Jim has been with IBM since 1981 when he was a S/38 operating system programmer.

Before joining the consulting team, his key assignments included ten years as a systems performance specialist, five years as the lead “JDE on i” performance analyst, three years as a consultant at the IBM Benchmark and Briefing Center in Montpellier France, and a total of eleven years as an operating system developer, including five years designing and implementing enhancements to DB2 for i.

Date:
March 14, 2017

Time:
6:00 P.M.  Networking & Social
6:30 P.M.  Dinner
7:15 P.M.  Speaker

Location:
Goeglein’s Reserve
7311 Maysville Road
Fort Wayne, IN

Menu (buffet):
Marinated Vegetables
Creamy Cole Slaw
Rosemary Chicken
Swiss Steak
Whipped Potatoes & Gravy
Whole Kernel Corn
Dinner Rolls & Butter
Assorted Cookies

Cost:
$25.00 per person, Status members
$35.00 per person, Non-members

To make your reservation, click here:
Meeting Reservation


  • -

February Meeting: Business Intelligence, Reporting, & SQL Server

Category : Meeting

NOTE:  This meeting will be a morning meeting
                BUT WILL BE AT GOEGLEIN’S
Although our primary systems may be IBM i’s, we don’t live in an isolated world anymore.  Data lives in more than one place.  As such, it often needs to be collected and organized for business reporting.  This month we look beyond the electronic walls of the i and will discuss leveraging SQL Server’s existing tools for your reporting needs.

Starting with SQL Server 2012, Microsoft started including many of the tools necessary to manage and/or automate reporting and data consolidation needs “out of the box”.  At the meeting, Luke will give a brief overview of how you can utilize the tools you may already own to:

  • Quickly automate your data consolidation needs using SQL Server Integration Services
  • Subscribe to reports in SQL Server Reporting Services and
  • Have them delivered to your email inbox at pre-determined times

Utilizing SQL Server Analysis Services, create a method for users to quickly analyze data without the need of IT managed reports.

This month our speaker is Luke Bailey of ASCC.  Joining ASCC in January 2016, Luke has been developing and maintaining MS Windows applications for several ASCC customers.  Prior to joining ASCC, Luke served as a Web Developer, an Applications Developer and a Business Intelligence Developer for several area businesses.  Luke is a Microsoft Certified Professional with the following certifications:
– Querying MS SQL Server 2012/2014
– Administering MS SQL Server 2012/2014 Databases
– Implementing a Data Warehouse with MS SQL Server 2012/2014.

Date:
February 14, 2017

Time:
7:15 A.M. Continental Breakfast
7:30 A.M.  Speaker

Location:
Goeglein’s Reserve
7311 Maysville Road
Fort Wayne, IN

Menu:
Continental Breakfast

Cost:
$10.00 per person, Status members
$15.00 per person, Non-members

To make your reservation, click here:
Meeting Reservation


  • -

2017 January Meeting: Art of the Possible – Modernization on IBM i

Category : Meeting

Application modernization can mean different things to different people—ask 10 people and you will get 10 different answers.  One thing they all have in common though is the big question “How can I deliver modern applications to our business?”  With the delivery of our Modernization of IBM i Applications Redbook, we will dive into what modernization looks like and give some general principles that can be leveraged when you get home.  In addition, we will go take a look at what other IBM i customers are actually doing from a Modern perspective on IBM i.

This month our speaker is Tim Rowe of IBM.  Tim is the Business Architect for Application Development and Systems Management for IBM i.  He is responsible for the content in the operating system and ecosystem that our IBM i Applications need to be successful today and into the future.  In addition, he owns the tools for Accessing and Managing the IBM i operating system.  He spends much of his time “preaching” the modernization story to our IBM i users.  In his free time he works as a sound engineer, specifically, live mixing.

Date:
January 10, 2017

Time:
6:00 P.M.  Networking & Social
6:30 P.M.  Dinner
7:15 P.M.  Speaker

Location:
Goeglein’s Reserve
7311 Maysville Road
Fort Wayne, IN

Menu:
Tossed Salad
Beef Stroganoff
Parsley Potatoes
California Blend
Dinner Rolls & Butter
World Famous Texas Sheet Cake

A PDF version of the presented PowerPoint can be found here:
Handout

To make your reservation, click here:
Meeting Reservation


  • -

2016 November Meeting: Everything You Wanted to Know About SQL But Were Afraid To Ask

Category : Development , Meeting

Do you use SQL to query or update files? Do you use it in your RPG programs or do you tend to stick with naïve I/O? If not, why? Have you wanted to access a file but didn’t quite have the logical file that you needed? What’s the overhead of creating a logical file “on the fly”? How about building new files? Do you use DDS or SQL? SQL offers many benefits and is quite flexible for many tasks. If you’ve tried SQL before and deemed it unworthy, it’s time you take another look. IBM is continually updating SQL. It’s also a standard means for accessing non-DB2 databases on other platforms.

 

This month you get two presenters for the price of one—Dave Parnin and Dave Roehling, both developers at Brotherhood Mutual Insurance. Dave Parnin is a RPG Developer II at Brotherhood and has worked on the IBM i platform for over 25 years. Dave Roehling, a former STATUS scholarship winner, is a RPG Developer III at Brotherhood and has worked on the IBM i platform for over 26 years. Both are Purdue/IPFW graduates and have earned the Certified Application Developer-ILE RPG on IBM i on Power certification from COMMON.