Month: November 2021

Posted on

21st Century RPG: /Free, ILE, and MVC

IBM i professionals are known for their dedication to the i. But while the platform has evolved, not all i programmers’ skills have kept pace. Perhaps you still code in fixed-format RPG. Or maybe you are just getting started with RPG. Whether you’re an IBM i programmer who has not yet made the leap to modern coding with free-format RPG, ILE, and the Model-View-Controller (MVC) design pattern, or you need more practice with these technologies, you will benefit from this book.

Author David Shirey’s aim in 21st Century RPG: /Free, ILE, and MVC is simple: to help programmers who have been left behind in the IBM i’s evolution, so they can use newer coding methods to boost productivity, modernize applications, and upgrade their skills. Shirey uses a friendly, humorous teaching style to explain the concepts, along with plenty of code examples and exercises that let readers practice what they’ve learned. The book is structured so that whether you’re running the latest IBM i OS or an older version, you will learn ways to improve your coding and applications.

Upon reading this book, you will:

Be familiar with ILE RPG, free-format RPG, and MVC
Know the differences between free-format and fixed-format RPG
Understand the key elements of ILE: programs, service programs, procedures, sub-procedures, and modules
Become comfortable with free-format coding
Learn how to create, compile, and call ILE programs using free-format
Learn the benefits of working with MVC and how to use it in an ILE and free-format RPG program
Gain insight into Web programming with RPG

Table of Contents
Introduction
Sample Chapter
Index

David Shirey is president of Shirey Consulting Services (www.shireyllc.com), providing technical and business consulting services for the IBM i world. Among the services provided are IBM i technical support, including application design and programming services, ERP installation and support, and EDI setup and maintenance. He is also a contributing author at MC Press Online (mcpressonline.com).

Item Number:
5158
Author Name:
David Shirey
Publication Date:
June 27, 2017
Edition:
First
Pages:
360
ISBN-10:
1583474056
ISBN-13:
9781583474051
Format:
Paperback
Product Dimensions:
7 x .75 x 9 inches
Shipping Weight:
1.3 pounds
Language:
English

Posted on

Using SQL LIKE with a Subselect

This is the second part of a two part story. In the first part I described how I had downloaded a list of libraries from an IFS file to a DDL table just using SQL. In this part of the story I want to check any of job descriptions on this IBM i partitions contain one of these libraries.

In the “real world” there were 58 libraries. In this example I am only using five. To check what these libraries are called I can using the following SQL statement over the file I built in part one:

SELECT * FROM OLDLIBS

The libraries I will be using are:

Read more »

Posted on

Sequel | Sequel Web Interface

Interested in learning more about Sequel Web Interface? Request a trial here: https://www.helpsystems.com/cta/start-your-free-sequel-web-interface-trial

Sequel Web Interface (SWI) will help your organization make real-time business decisions wherever you are.

SWI is the easiest, most cost-effective way to access and work with Sequel objects. Access your dashboards, views, reports, tables, scripts, and applications—all from a web browser.

Plus, use Sequel Web Interface to display results, download data to your PC, print, email, and so much more.

Watch Now!

Posted on

Sequel | Import Query400 Queries

Interested in learning more about Sequel Data Access? Request a demo here: https://www.helpsystems.com/cta/request-live-sequel-data-access-demonstration

Change can be challenging. Switching business intelligence tools shouldn’t also mean losing all the work that has been put into writing your queries over the years. Today I’m going to show you how you can take your current Query/400 queries you have built, import them into the Sequel BI Interface and start using them in seconds.

And the possibilities don’t stop there.

You can also use Sequel to perform data manipulation and reporting tasks far beyond the abilities of Query/400. Like creating runtime prompts for uses to access data in different ways. There are two methods for importing and converting queries from Query/400, green screen and GUI.

Lastly, I will be showing the preferred method of using the GUI through the Viewpoint Client.

Watch Now!

Verified by MonsterInsights