Author Archives: Dave Parnin

  • -

2017 Summer Break

Category : Meeting

Greetings!

STATUS has just wrapped up a great year and we are now taking our traditional break for the summer.  Our next meeting will be in September.  If there are any topic or speakers you would like to hear or if there’s anything else you want to communicate to us, please use our Suggestion Box to send us a note.  See you in the fall!


  • -

2017 May Meeting: Temporal Tables

Category : Meeting

Have you ever found yourself wanting to record history of updates of a table? Stuff that you could do by customizing maintenance and writing out to a log file, or querying the journals associated with that file? Or, have you ever found yourself want to query on historical data, such as what was the average hourly rate from a year ago? Or what was the price of this item a year ago? IBM has added some wonderful capabilities with IBM i 7.3 with their Temporal Table support. You can set this up without adding or modifying a line of code. And, you can often do it without interrupting existing applications.

Rob Berendt has been with Group Dekko for 30 years. He helps to administer their 15 lpars of IBM i (all running IBM i 7.3), 2 lpars of AIX, and 6 lpars of VIOS spread out over 3 Power 8’s. With his extensive history of upgrading IBM i, working with Domino, assisting with security audits, and more he brings a lot of experience to the table.

Date:
May 9, 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):
Tossed Salad
Char-Broiled Filet of Beef
Baked Potato
Sugar Snap Peas & Baby Carrots
Dinner Rolls & Butter
Assorted Fruit Pies

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

To make your reservation, click here:
Meeting Reservation


  • -

2017 April Day-With

Category : Meeting

The April evening meeting has been replaced by the day-long Day With Aaron Bartell.

For more information, click here.


  • -

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.


  • -

You’ve Got STATUS!

Category : Announcement

Welcome to the STATUS IBM i user group in Fort Wayne, IN.