The API Corner: So Just What Changed in This Record? PDF Print E-mail
Programming - APIs
Written by Bruce Vining   
Wednesday, 18 March 2015 00:00

Learn about flexibly tracking field changes.

bruce viningWritten by Bruce Vining

On the IT Knowledge Exchange, Luissimon recently posted, "I need to get which field changed in a file, instead of writing multiple (IF this field changed THEN DO…) for each field in each file. I was wondering if I could use some tool in RPG for doing that?" While I can't say that I'm familiar with an RPG built-in to accomplish this, I can see how using a few system APIs within an RPG application program can meet this need.

Add a comment
Last Updated on Tuesday, 17 March 2015 16:08
User Rating: / 2
Bridging Vertical Software Silos with ASNA Visual RPG PDF Print E-mail
Programming - RPG
Written by Roger Pence   
Wednesday, 18 March 2015 00:00

With a little out-of-the-box thinking, you don't need an IBM i to solve challenges with RPG skills—you just need AVR's modern implementation of RPG and a little creativity.

roger penceWritten by Roger Pence

Rick Schuster is one of us. He learned how to write RPG when Ronald Reagan was president. He cut his RPG teeth on the S/36 and then moved to the AS/400 when it came out in 1988. Despite Rick being a card-carrying RPG programmer, RPG is now mostly just his hobby. He spends his workdays now being the Chief Information Officer for Marous Brothers Construction in Willoughby, Ohio (which is just outside Cleveland). As CIO, he isn't a coder, but rather directs Marous Brothers Construction IT resources.

Add a comment
Last Updated on Tuesday, 17 March 2015 15:46
Controlling RPG Program Flow with If/Else/Elseif/Endif PDF Print E-mail
Programming - RPG
Written by Jim Martin   
Wednesday, 11 March 2015 00:00

Four free-format operations help you construct programs that execute conditional logic in a structured way.

jim martinWritten by Jim Martin

Editor's Note: This article is an excerpt from Chapter 6, "Program Flow Using Free Format," of Free-Format RPG IV, 3rd Edition (MC Press, 2015) by Jim Martin.

In nearly every program you write, you need to control the flow of instructions. Free-format RPG IV offers experienced RPG programmers a new style for controlling program flow. In this article, we look at the operations available for controlling flow in free format through conditional logic: If, Else, Elseif, and Endif.

Add a comment
Last Updated on Friday, 06 March 2015 09:26
Practical SQL: DB2 at Home, Part 3, Using XML Data PDF Print E-mail
Programming - SQL
Written by Joe Pluta   
Wednesday, 04 March 2015 00:00

Now that we have XML data, it's time to learn how to use it.

joe plutaWritten by Joe Pluta

In previous articles (parts 1 and 2), we began to explore DB2's pureXML capabilities. While DB2 provides exceptional XML data-handling, it's not enough to simply be able to store and retrieve XML data. In any real world business application, you'll also need to integrate that XML data with your existing relational data. This article shows how to do just that.

Add a comment
Last Updated on Thursday, 05 March 2015 11:25
RPG Academy: BIF Up Your Code! More on Moving MOVE and MOVEL out of Your Code PDF Print E-mail
Programming - RPG
Written by Rafael Victoria-Pereira   
Wednesday, 04 March 2015 00:00

Understanding how to use the EVAL op code and the %CHAR, %EDITC, %EDITFLT, and %EDITW BIFs will help you remove even more of those MOVE and MOVEL statements from your code.

rafael victoria preiraWritten by Rafael Victória-Pereira

One of MOVEL's many uses is the implicit data type conversion from numeric to character. You probably have quite a few of these conversions in your code and don't even realize it. While they're not as error-prone as the reverse operation, it's preferable to have a more controlled conversion, especially because many of these operations are part of something that the end-user will seeeither a message on the screen or a line on a printout, for instance. As usual, there are several ways to do this.

Add a comment
Last Updated on Wednesday, 04 March 2015 00:00
User Rating: / 1
The CL Corner: A More Flexible Interface to the RUNSQL CL Command PDF Print E-mail
Programming - CL
Written by Bruce Vining   
Friday, 27 February 2015 00:00

In this article, we'll building the SQL request dynamically.

bruce viningWritten by Bruce Vining

In the January 2015 CL Corner, Enhancing WRKQRY Reports the Easy Way, we saw how to create an SQL view for use by WRKQRY using the Run SQL (RUNSQL) CL command. I received quite a few notes asking, among other things, for an example of how to build the RUNSQL SQL parameter using variables rather than the static approach taken in the previous article. So today we'll look at what's required to build the SQL parameter using variables/parameters. For demonstration purposes, we'll continue to use the PROJECTS file that was introduced in the previous article.

Add a comment
Last Updated on Thursday, 26 February 2015 10:49
Modernization on the IBM i: Getting Started PDF Print E-mail
Programming - General
Written by Brian May   
Monday, 23 February 2015 00:00

The only true mistake you can make with regard to application modernization is doing nothing.

brian mayWritten by Brian May

Modernization. Everyone is talking about it. Everyone wants it. But we cannot always agree on exactly what it is. It can mean a few different things, depending on your needs and environment. This of course leads to confusion for those who need it most.

Add a comment

Last Updated on Friday, 20 February 2015 16:11
User Rating: / 1
What Change Control Is PDF Print E-mail
Programming - Change Management
Written by David Shirey   
Wednesday, 18 February 2015 00:00

Change control: is it a tool or is it an attitude? Maybe it's a little of both.

david shireyWritten by David Shirey

Last month, we talked about some of the myths that seem to surround change management. Now let's take a few moments and talk about what a change control system should be.

Add a comment
Last Updated on Wednesday, 18 February 2015 00:00
<< Start < Prev 1 2 3 4 5 6 7 8 9 10 Next > End >>

Page 1 of 215



See What i Can Do With Modern RPG Development

Your applications deserve more than just a new look! Change the perception of the IBM i as “old” with modern development tips from IBM and Profound Logic Software.
Watch as Barbara Morris, Brian May and Alex Roytman dive beneath the GUI surface to show the benefits of:


  • Working with free-format RPG in IBM i TR7
  • Breaking free from “The Cycle” of traditional RPG development
  • Going beyond the 10 character limit in display and database files
  • And more!

You'll also see a live demonstration of these techniques as the presenters create a modern web application before your eyes! 


Watch the Webinar Now!



MS Office Connector for Query/400

NGS' Qport Office enables Windows users to run IBM Query/400 queries to: 

 - Create and update Excel spreadsheets and Access databases

 - Create Word documents

 - Send to Windows screen and PC printers

No query conversion is required. Works with i5/OS V5R1 & above. Installs in minutes!

If you don’t have a budget to replace IBM Query/400, but want your users to have one click enhanced output of their queries.… Request the online license agreement and product download instructions today!

Offer good through December 31, 2013.