Covering installation, writing code, and tips and tricks. Three large focuses will be using Visual Studio Code as the daily driver, setting up and configuring the RPGLE linter, and using git with your existing ILE RPG/COBOL/etc. Bring a laptop. Comes with interactive handouts that you can take home with you!
1. Understanding how to utilise all of Visual Studio Codes features when writing ILE code 2. Writing the best and cleanest RPGLE code 3. Learning how to use the available git tools and IDE tools with local RPGLE
Abstract: SQL is IBM's relational database language that can be used to query, update and delete data from the database. SQL is becoming the 'de facto' industry standard for accessing distributed data. Record Level Access can only be used with RPG and Cobol, while in all other programming languages data access is performed through SQL. Additionally, SQL provides a lot of great features, such as aggregating rows and building sub-totals or updating a bunch of rows with a single statement. SQL also includes various scalar functions for example for date and time calculation, that are not available in RPG or Cobol. Embedded SQL allows SQL commands to be included and executed directly from within RPG or Cobol and thereby profiting from all the powerful SQL features without additional programming. Learning Objectives: In this session you will learn how to embed and execute SQL commands from within an HLL respectively RPG. It provides an overview of the commands to use in an application program to exploit SQL scalar functions as well as for updating, deleting and accessing data located in database objects. Audience: Developers who already discovered the power of SQL and want to profit from those features from within RPG or Cobol. Developers originally coming from other programming languages who want to access data in the same way they are used to do. Developers working in a “multi-(programming)lingual” environment who need or want to embed the same or slightly modified source code in different programming languages.
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Installation, writing code, developer tools, creating programs, and much more: 1 - Learning about what VS Code is 2 - How does it work with IBM i 3 - Writing/compiling ILE languages inside of VS Code.
REST APIs have become a major part of business programming. We live in a world where virtually everything is connected to the Internet, and REST APIs are how they communicate with each other. In this session, you will learn how to call (or "consume") REST APIs from good ol' RPG. In addition to showing you the basics of how APIs work, this session explains how to use several free tools to consume them. The tools will be compared so that you can determine which one would work best for you.
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Open source delivers new interfaces and functionality for your IBM i applications—and broadens the talent pool for your development team. Python, PHP, and Node.js are among the most popular open source tools on IBM i, for good reason. Combined with today’s ODBC database connectivity, API standards, and RPG/ COBOL integration, they are a powerful way to extend traditional applications to the web, mobile devices, and APIs.
In applications multiple steps have to be consolidated and executed as a unit (Transaction), That means either all steps or none of the steps must be performed. Example: an order has to be completely delivered or not at all. No problem if everything is okay, but what if there is suddenly not enough inventory for one position? Everything has to be reset … and this can become tricky, because multiple programs were executed, multiple rows in different tables were updated and may be even a trigger was activated. The solution is Commitment Control. Even though Commitment Control is not new, it is only rarely used in (traditional) IBM i applications. … but it is essential for keeping data consistent, especially when using techniques such as referential integrities and triggers. … and it is even for traditional applications important. … so, it is time to start!
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
This overflowing session is designed to help ensure every IBM i administrator and operator has at least a backpack full of valuable tips for when they return home. From command line to shell to IBM Navigator for i, Steve will sprint through these tips at a pace of at least two tips per minute, for at least 150 tips! This session is updated every quarter with new and relevant information so that you don't miss good foundational tips but are keeping up with what updates IBM is releasing on a regular basis.
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
Your business data is in RPG. Your users want Microsoft Excel. This session discusses how an RPG program can build and modify Excel spreadsheets by calling the POI Java classes.
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
It’s time to move to git. One of the first and hardest processes is moving your sources to a git repository as well as choosing where to host your code. This will cover the available methods to achieve that as well as creating the git repository in one of the many repository hosts.
Alan and Charlie will open the floor for an open discussion about the value of custom code, and how it gives businesses their proprietary advantages. What are the responsibilities and roles for everyone in your organization to promote better business continuity, workflows, and overall user experiences?
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
After the dust settles after a security breach, the next logical questions are: “What happened and how can we prevent it from happening again?” We will deconstruct a number of security failures that will provide lessons that you can take home and put to use immediately
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Tuesday May 9, 2023 10:15am - 11:15am EDT
Captain's Room
Learn to think like a spy! Many shops use journaling for a variety of reasons, but may not be familiar with how to use these journals for forensic purposes. Mining your journals for the who, what, when, where, how - and sometimes even why - can be very useful, not to mention fun! Come join us for a lighthearted and entertaining "Mission: Impossible" themed look at one of the most useful things you can do with your journals. This session will introduce journaling concepts and share tuning tips to optimize your journal environment for forensics. After reviewing the "old fashioned" way to dig into your journals, we will demonstrate how much easier this is with the right tools. The DMPJRN and CVTJRNDTA commands used in this presentation will be made available as a free download to all attendees, including source code!
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
Tuesday May 9, 2023 10:15am - 11:15am EDT
Chandler
ILE (Integrated Language Environment) Concepts are not new but in a modern and modular programming essential! When working with ILE concepts we are no longer restricted to programs. We can code multiple (exported) procedures in a single source member. These members will be compiled into modules. And modules have to be bound into programs and service programs. As far as good! But if you have to change something or need some information. Do you know … Where your modules are bound? Where your service programs are used? How many procedures are exported? What Service-Program-Signature is bound to the caller (service-)program? if and which binder source was used?...For analysis we may use CL commands … but they are a little clumsy. As alternate IBM provides a bunch of (SQL) services which make the analysis of your ILE objects much easier!
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Sloppy code, beautiful code. They both produce the same results, so who cares how it looks? If you have heard this before, or are living with this scenario, this is a MUST ATTEND session. Learn about code refactoring (aka "modernization") and see how to rejuvenate old code into maintainable, flexible, and scalable components
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Understanding how to use git with VS Code or Merlin IDE, writing RPGLE locally, deploying and building to IBM i. You'll also see the available git and IDE tools to make your development life so much simpler.
Alan will compare several open source languages commonly used for APIs and web development and the role of RPG alongside them. Languages include Node.js (javascript), PHP, and Python. The session contains concrete information about each as well as a lively discussion.
In this session, we'll discuss what you need to think about when moving to the cloud. It’s not as easy as just moving your workload from one machine to another. Pete will cover: Costs associated with moving to the cloud, what you should be moving, undestanding planning, migration, testing and more.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
Tuesday May 9, 2023 11:30am - 12:30pm EDT
Captain's Room
A deep dive into the IDE that comes with Merlin: IBM i Developer. We’ll look at what it takes to use the IDE, setting up a Workspace, writing + compiling code, and how it integrates with git.
Do you have monolithic programs that you have to start breaking up into manageable pieces? Have you been tasked to start unit testing and don’t know where to start? This session is meant for you. We will work through the benefits to modernizing your code and why you want to adopt unit testing. We will work through breaking apart monolithic programs and how to write their respective unit tests. We will discuss some best practices in unit testing and how you can take some of those best practices and apply them to your everyday development processes.
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a Senior Programmer Analyst at Everbrite and her primary development... Read More →
JSON (JavaScript Object Notation) is quickly becoming an important document format for business data interchange, so what's the best way to process it from RPG? JSON provides the same benefits as XML, but is smaller (and so transmits over a network more quickly) and is much more efficient than XML to work with in web applications. Naturally, this means that your RPG business applications need to learn how to speak JSON in order to talk to many of the newer web services or exchange data with many tech-savvy business partners. In this session, Scott will explain how the open source YAJL tool can be used from an RPG program to process or generate JSON in an efficient manner.
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Are you intimidated by spreadsheets? Do you use Excel for the basics, but know you could be so much more productive with it if only you knew how? Do you cringe when other business people within your company ask for data in spreadsheet form? Excel is a wonderful tool, especially when paired with the IBM i! It's incredibly powerful, and can save you lots of time. This session will begin with the basics and then progress through more advanced Excel topics such as functions, pivot tables, and array formulas. Using real life examples, you'll see how these new skills will help you in your career. Finally, we'll review powerful methods of pulling data from your IBM i directly into Excel spreadsheets! You'll even leave with sample code you can leverage within Excel to give you one click access to run an SQL statement from your desktop, and have the results returned in a spreadsheet. After each of the 25 topics covered, we’ll review by playing Excel Bingo, for prizes! Learn some great new Excel skills, have some fun, and maybe leave with a prize!
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
SQL is great for accessing data located in a relational database. But in a modern world it is also necessary to consume data that is located in the IFS (Integrated File System) or provided by web services. With each Technology Refresh IBM introduces and enhances Db2 for i Services. With Release 7.4 Technology Refresh 3 IBM provides new SQL Stored Procedures for reading data from and writing Data into the IFS. In composition with other SQL Functions it is easy to scan through IFS files or decompose *.csv files or JSON files or XML documents located in the IFS.
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Come get your first look at Python and learn some of the basics! Also, learn about the product offerings that enable you to do software development with the language on the platform. Upon completing this class, you will be able to acquire, install, and use the language on IBM i, as well as extend its power using contributions from the larger open source community. We will also explore Db2 Data Access and IFS file system access as primary use cases for Python on IBM i.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
In today's hyper-competitive world, we're all striving to be the best employees we can be. We want to impress our boss, finish that big project on-time and under-budget, and earn that big promotion with a hefty raise. But how? What if I told you that the secrets to being the ideal employee aren't secrets after all? That you've known them for a very long time... since kindergarten! Remember when you learned to always be kind, play fair, and say thank you? Those life lessons still apply today! Come to this fun and lively session to learn how to apply these and many other timeless bits of wisdom you learned as a child, to make you the ultimate employee!
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
An SQL SELECT can be much more than a simple SELECT * FROM query. Among others it includes with the GROUP BY clause a powerful data aggregation capability. A bunch of aggregate functions allows to count or summarize rows, to calculate the average over multiple rows, to determine the minimum and maximum row value. The GROUP BY clause may be widely known and used, but the HAVING clause which goes hand in hand with the GROUP BY is often a mystery. There may be other secrets waiting for being revealed … or did you know you can create all kinds of sub-totals and grand-total with an SQL GROUP BY?
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
When doing an upgrade to IBM i, there is more work involved in the planning of the upgrade than in the actual upgrade itself. When you have done the planning, the actual upgrade is simple. We will cover planning tips, pre-requisites, and then post-installation requirements. Your upgrade isn’t complete until this last step is done.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
See the lifecycle for how traditional ILE programs can be exposed as consumable APIs with the use of SQL and open-source technologies. We’ll go from slides with modern and legacy program examples to doing a demo showing how to utilise those programs.
IBM i provides a cross-platform ODBC driver for Db2. What does this mean for web and open source developers? Developers can now code “locally” on their PCs, then deploy the same code to IBM i for production. Learn best practices for using ODBC with open source languages, including Node.js, PHP, and Python, and R, as well as .NET, and how to convert proprietary Db2 driver functions to standard ODBC functions. Special tips and hints help you avoid common mistakes and get the best performance.
Do you know the differences between IBM i password levels? How about password rules that aren’t used or actually used too much to be effective? What about common patterns from keyboards to mobile devices that make it easy for someone to just guess your password? Steve will talk about how good and bad passwords are constructed as well as how to break them with social engineering, dictionary attacks, brute force attacks and more. Learn why most passwords stink so you can protect yourself and your users.
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Do you use SQL? Do you use it to its full capabilities? SQL is an amazingly powerful tool, but can seem overwhelming at first. In fact, it can sometimes seem like magic! Come join us for a session on SQL that begins with the basics and builds into very useful techniques you can use every day. Using magic to help explain some key concepts will make this session entertaining as well as educational. Discover how to use SQL not only for data definition and data manipulation, but also as a wonderful ad-hoc query tool. Save time writing reports and get the answers your business needs in seconds. Learn how to easily execute an SQL statement on your PC that will pull data from your IBM i into an Excel spreadsheet! We will cover other practical examples, such as easily processing a job log for the information you need.
Steven Wolk is the Chief Technology Officer for PC Richard & Son, a family owned and operated chain of 66 appliance and electronics superstores located throughout NY, NJ, CT, and PA. Founded in 1909, PC Richard has always been known for honesty, integrity, and reliability throughout... Read More →
You are here to learn about the latest and greatest for all things IBM i. But after the conference, how can your IT organization overcome the forces of the dark side (e.g., OPM, RPGIII, DDS), take advantage of the latest capabilities in the platform, and deliver new services while operating efficiently and securely?
Bring your questions. Our panel of experts will give you tips on how to advance modernization and security, automate IT processes, use open source in your environment to deliver new capabilities, develop IBM i skills for new team members, and more.
Join us Tuesday evening for an entertaining and informative panel discussion! Relax, have fun, and exchange ideas with your friends, colleagues, speakers, and IBM i experts.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
Charles has been asked this question a _million_ times (Editor’s note: this might be slightly exaggerated…). He will demonstrate how similar functions are done using each technology and also what’s different between the two.
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Wednesday May 10, 2023 8:00am - 9:00am EDT
Edgewood
In this session, learn about the OpenAI group, what it stands for, and what it does. Then we run through some examples that may or may not be IBM i centric. We wrap up with a live demo of Copilot, an AI extension to your favorite IDE that helps you write code.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
Wednesday May 10, 2023 8:00am - 9:00am EDT
Chandler
PHP is moving fast these days. PHP 8.1 and 8.2 include features that help developers reduce bugs and enjoy writing high quality code. In this fast-paced session, Alan will share his favorite new features in PHP 8.1 and 8.2, and how to prepare for them. Alan will also show tips on upgrading from older releases and will go over recent security enhancements.
While IBM i is arguably the most "securable" operating system in the world, your environment may have some wide open doors that you can't ignore. This session will highlight the importance of encrypting data in transit and show you how to do it easily with minimal interruption to the business.
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Wednesday May 10, 2023 8:00am - 9:00am EDT
Captain's Room
When talking about application modernization database most think about converting from DDS to DDL and redesigning the database … and yes, this might be the final goal. But there is much more! We have to move from an application-centric thinking to a data centric thinking. In short, instead of coding everything in whatever programming language, we should move as much business logic as possible into the database. It may even include foreign data that is provided and accessed by Web-Services. But …what does that mean? At first, using encapsulated (complex) SQL Statements wrapped in SQL Views or User Defined Table Functions, externalizing Data Access, adding constraints and triggers, Row And Column Access Control (RCAC) … With all these techniques we cannot only reduce our source code to a minimum but also secure our data!
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
Maybe you've heard about the Internet of Things (IoT) - where programs interact with things in the physical world - even RPG Programs.
In this session, Scott shows some simple examples of controlling physical devices with a Raspberry Pi communitying to an IBM i program (RPG or Node.js) so that it can be integrated into a business application.
Maybe you don't really want to open or close a garage door with RPG, but there may be other things in your business that you could control from RPG with IoT. This will help you get started.
Learning Objectives:
What is Raspberry Pi?
Communicating from an RPG Program
Use OPEN/CLOSE opcodes to open and close a Garage Door
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Wednesday May 10, 2023 9:15am - 10:15am EDT
Baldwin
We have all unfortunately seen really bad code or really bad practices. Have you ever wanted to take that code and throw it against the wall and start over? This session will give you the steps and guidelines that will help you start the discussion so you and your colleagues can implement standards and guidelines and start the process of cleaning up your code or the code you have inherited. We will look over various different recommended programming standards and guidelines. We will look at bad code vs new code and make recommendations that you can take back and implement in your shop. We will learn why its important to have standards and guidelines and how you can start the standards discussions at your shop.
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a Senior Programmer Analyst at Everbrite and her primary development... Read More →
Wednesday May 10, 2023 9:15am - 10:15am EDT
Captain's Room
Think your IBM i is immune to ransomware, malware…even viruses, colds and flus? Think again! Steve will walk you through exactly what malware can actually do to a system that hasn’t been properly secured.
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Wednesday May 10, 2023 9:15am - 10:15am EDT
Edgewood
Today data get more and more exchanged between multiple platforms and interfaces, in JSON or XML or other text formats. SQL includes methods for consuming XML and JSON. But quite often the data is not in the format, so we can consume it directly. For example, the first and last name is returned as a single value separated with a comma and must be split. On the other hand, data must sometimes be prepared in a specific way, for example a numeric value must be right adjusted padded with asterics and edited with group and decimal separators. And finally, it is necessary to check the passed data or to search character data if they match a specific format or include a specific sequence. For example, to find all column values that consist not only of digits. Did you know, you can do this directly with SQL? SQL includes a lot of scalar functions for string manipulation including regular expressions for scanning, preparing and converting strings.
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
IBM has turbocharged Navigator for i, with a new fresh look. Come see what the new tool has in it, the new features and functions to more easily manage your IBM i. How do you get the new version, and what the new features and functions do, and how you can take advantage of them.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
Wednesday May 10, 2023 9:15am - 10:15am EDT
Chandler
We will learn how to unit test your RPG code using IBMiUnit, an RPG unit testing framework written by Marina Schwenk and Steve Johnson-Evers. We will learn how to automate your testing process once you get your test written and you have to run them over and over again.
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a Senior Programmer Analyst at Everbrite and her primary development... Read More →
Wednesday May 10, 2023 10:30am - 11:30am EDT
Captain's Room
In this session we walk through the step-by-step process of creating a service program. We will discuss modules, service programs, program signatures and binder source.
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
With each new release of the IBM i operating system and with Technology Refreshes, IBM has given us some new features in RPG. This session tells you about the new and exciting features of RPG and how you might like to use each feature in your own applications.
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Wednesday May 10, 2023 10:30am - 11:30am EDT
Baldwin
Python on IBM i has been around for a while now. In this session we explore many of the various tips I’ve run across over the last few years. These tips apply to both Python and/or the IBM i environment running the Python scripts. Tips include best practices, IFS features, pathing and MUCH more.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
Wednesday May 10, 2023 10:30am - 11:30am EDT
Chandler
In this session, Pete Massiello will talk about key points to take note of when backing up your data so you can recover, and recover quickly. Pete will cover: How to know you’re backing up the right stuff, key points when testing your recovery, various options for backup, including cloud, VTL, remote testing, and more.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
Wednesday May 10, 2023 10:30am - 11:30am EDT
Edgewood
Just released! Valence 6.2, the latest incarnation of the popular web and mobile framework for IBM i, includes a browser-based low-code development utility called Nitro App Builder (NAB), through which anyone with a solid understanding of their IBM i database can create dazzling web or mobile apps, including dashboards and data grids with download-to-Excel functionality, all in a matter of minutes! Running entirely on IBM i, the NAB tool can also be used to create intricate file maintenance apps, through which users can adjust content in one or more physical files — you control which fields they can see and/or edit.
All of this can be achieved with no coding, though IBM i developers can easily extend the app's functionality with RPG or SQL code to handle business logic as needed. Advanced programmers comfortable with HTML5 and JavaScript code can take things even further, creating super elaborate data-entry apps that work hand-in-hand with server-side RPG logic through the Valence Portal.
The bottom line: With Valence, whether you're a seasoned RPG developer or a super user with intimate knowledge of your system's physical files, you can crank out highly functional web and mobile apps on IBM i in no time — no prior experience in web or mobile development required. Come to this quick demo session to see the latest release of the Valence framework, and how easy it is to quickly build and deploy such an app on your system.
Rob has worked as an in-the-trenches IBM i developer since 1992, with the past 15 years focused on developing modernization efforts for legacy systems written in RPG. Currently serving as Senior Partner for CNX Corporation in Chicago, Rob is a strong advocate of introducing highly... Read More →
Wednesday May 10, 2023 11:45am - 12:15pm EDT
Edgewood
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Experience gained from leading major projects, including application modernization, at 100s of corporations has given Donna a well-rounded view of development needs, audit requirements, and testing principles.
Wednesday May 10, 2023 11:45am - 12:15pm EDT
Baldwin
Do you ever find yourself thinking, "There has to be a better way to do this?”
Regardless of organizational size, most IT groups have little to no documentation and applications are built by many hands over many years. This makes it challenging to manage applications and onboard new teams & skills. Having the right tools significantly reduces the time to manage applications, onboard new employees and removes the risk, especially when managing applications you didn’t write . Join Fresche’s Stephen Flaherty for a session on ways to move projects forward faster and reduce the effort & risk when making changes to your code with automated analysis and modernization tools. Stephen will demonstrate the business value derived from application documentation, analysis and better understanding of your IBM i applications.
You’ll see:
Automated graphical documentation that makes it easy to visualize & understand application design and flow
Powerful impact analysis that tracks “where used” information so you can make code changes with confidence
How IBM i organizations have used X-Analysis to save significant developer time and better understand their applications.
Stephen Flaherty began RPG programming in the early 1980s and worked for many types of organizations in the manufacturing, retail, and software development industries before joining Fresche. As a strategist and IBM i application development expert, Stephen helps clients transform... Read More →
Wednesday May 10, 2023 11:45am - 12:15pm EDT
Chandler
Join this session to learn about Maxava, a company with over 20 years of experience in developing and supporting IBM i solutions. The session will discuss the advantages of switching to Maxava HA software and will cover their unique monitoring software Mi8 and rollback software, Maxava CPR, which is included in the Maxava Enterprise Bundle. The presentation will also share information about the market and provide insights into Maxava's development roadmap.
Key takeaways:
Learn about Maxava HA’s rapid implementation and excellent support for their high availability solution.
Blue chip companies in the US have already experienced the benefits of switching to Maxava.
Maxava's Enterprise Bundle includes unique file recovery and monitoring solutions.
Amal has over 10 years of experience in the IBM i market, first in Security, and more recently, in the HA/DR space.She is well-known in the IBM i world and has a long record of productive relationships with clients based on trust, professionalism, and her ability to quickly home in... Read More →
Modernization and innovation go hand in hand. Transitioning from a traditional data center to a secure Hybrid cloud architecture can be made simple. We demonstrate Cloud solutions for IBM on AWS/Azure, Cloud Architecture, Data Protection & DR strategies. Connectria Hybrid accelerates the modernization journey with a traditional lift and shift migration by refactoring the core IBMi/AIX systems On-Net directly to public Cloud.
3 Reasons Why Cloud Computing is Important for Businesses
Vice President of Solutions Architecture, Connectria
David Wilderman is Vice President of Solutions Architecture at Connectria which helps customers cloud enable their Power Systems platforms (IBM i & AIX). David has been with Connectria for nearly twenty years and has grown within the company through his experience in various systems... Read More →
Wednesday May 10, 2023 11:45am - 12:15pm EDT
Captain's Room
Curious about what is the latest in technology? Are you tired of being the “deer in the headlights” when others talk tech? As technologists, it is incumbent upon us to be able to speak to what is new. This session will highlight key technologies to give you some basic awareness.
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Wednesday May 10, 2023 1:00pm - 2:00pm EDT
Chandler
So, you’ve been learning about Python and maybe even playing a bit. Building upon the introductory session, this session will address the object oriented ODBC, Web Services and much more.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
Wednesday May 10, 2023 1:00pm - 2:00pm EDT
Edgewood
We help IBM i remain a critical part of IT when we know how to connect to other systems flexibly and securely using APIs. Learn how to both send and receive data, safely, using IBM i business logic using various tools, including RPG, PHP, Python, and Node.js.
Calculating dates and times correctly within commercial applications are can be critical. SQL has become very powerful in date calculation and date operation functions. In this way SQL includes functions for retrieving the day of the week (as number of name), calculating the week according the ISO guide lines, determining the month end or the date of the next Wednesday or Friday. Additionally, SQL includes scalar functions that allow to convert almost any (valid) character representation of a date, time or timestamp into a real timestamp and vice versa. This session will give you an overview over the latest SQL scalar functions for date and time calculation and for conversion between numeric and character date/time.
Database and Software Architect, IBM Champion, Independent Consultant
Birgitta Hauser worked on the IBM i and its predecessors since 1992. She graduated with a business economics diploma, and started programming on the AS/400 in 1992. She worked and works as traditional RPG Programmer but also as Database and Software Engineer, focusing on IBM i application... Read More →
The new enhanced GUI is really nice, but if you haven't used it, it is very different from the classic GUI. It is time to get on this GUI. It seems that you can't find anything, and things work and behave differently. Come to this session to learn where familiar functions are located now and how they work.
Pete Massiello has been working with the AS/400, iSeries, IBM i since 1989, focusing on systems management and technical support. He has held numerous technical positions through out his career. He is the President of iTech Solutions Group, an IBM Premier Business Partner delivering... Read More →
Wednesday May 10, 2023 1:00pm - 2:00pm EDT
Captain's Room
DATA-INTO has the same power and ease of use that RPGers have enjoyed with XML-INTO for years. Unlike XML-INTO, however, DATA-INTO is not limited to XML documents! With DATA-INTO, RPGers can read JSON documents, as well as other structured documents like CSV, or just about any format you can imagine. This session discusses the basics of DATA-INTO, and how it makes it easy to process structured documents in RPG. Then, it explains the basics of adding support for your own structured documents by writing your own parser.
Development & Solutions Architect, Midrange Dynamics
Scott volunteers as a member of COMMON's Board of Directors, Strategic Education Team, Certification Committee and Innovation Awards. He is the author of around 1000 articles and a dozen open source projects. Scott's efforts to help out the IBM i Community have resulted in dozens... Read More →
Wednesday May 10, 2023 2:30pm - 3:30pm EDT
Baldwin
We will learn and explore how you can go from record level access to embedded sql and from that how can you streamline your programming process by using embedded sql. We will look at how to handle sql exceptions and go through why you should convert to using embedded sql instead of record level access.
Marina started her career in January 2015 at Everbrite LLC in Greenfield WI after graduating from Gateway Technical College in May of 2014 with an Associate’s degree in IT Software Development. Marina works as a Senior Programmer Analyst at Everbrite and her primary development... Read More →
Wednesday May 10, 2023 2:30pm - 3:30pm EDT
Edgewood
Charles Guarino believes in the “power” of IBM Power Systems. His career reflects his dedication and interest in bringing the platform and its solutions to others and as a result has been recognized as an IBM Champion.He is a member of COMMON’s Speaker Excellence Hall of Fame... Read More →
Database access is at the center of any programming languages usefulness and Python can access several different databases including Db2 for IBM i. In this presentation we will explore some different database options and dig deep on Db2 data access.
Mike Pavlak has been working with IBM midrange solutions since 1992 and IBM Mainframes before that. After years of developing applications using RPG, CL and PHP he managed IT development and IT for power protection manufacturer Tripp Lite. Later Mike was instrumental in developing... Read More →
Wednesday May 10, 2023 2:30pm - 3:30pm EDT
Chandler
Now that you’re aware of how IBM i can be destroyed down to the bare metal by malware, how do you intend on handling malware events of all shapes and sizes? Have a plan? Steve will walk you through identifying a recovery in progress, how to stop it and the steps to recover.
Account Executive and Security Engineer, Service Express
Steve has been involved with IBM i since 2001 primarily in the manufacturing and distribution industries. Over that period he’s been a systems administrator, developer, IT Manager and IT Director. He joined iTech Solutions in 2017 in a combined sales/technical role, bringing additional... Read More →
Wednesday May 10, 2023 2:30pm - 3:30pm EDT
Captain's Room
