New in V7R5 Part 3

New in V7R5 – Part 3. %CHARCOUNT, %LEFT, %RIGHT, %UPPER, %LOWER Hello everyone and welcome to part 3 of V7R5 News. In this article I am going to show five new built-in functions that I think you may find useful. Of course there will be a program to support the use of this built-in functions […]

ILE RPG and SQL Data Types

ILE RPG and SQL Data Types Hello everyone and welcome to this new article, this time about SQL Data Types that don’t have ILE RPG matching type. As you can see in the picture that illustrates the article, there are many SQL data types that can be defined (there are more SQL types like XML […]

Block Fetch In Embedded SQL

Block Fetch in Embedded SQL Hi to everybody and welcome to a new post, in this case an embedded SQL tip. If you are an ILE RPG programmer, I am sure you have used SQL in your RPG code. If not, start doing it right now. There are many advantages to using it instead of […]

New in V7R5 – Part 2 

New in V7R5 – Part 2. FOR-EACH, ENUM, %SPLIT, %SUBARR Hello everyone and welcome to part 2 of V7R5 News. In this article I am going to show four new opcodes and built-in functions that I think you may find useful. I’ll show you how to use the FOR-EACH opcode, which is very useful when […]

New in V7R5 – %LIST, %RANGE, WHEN-IS, WHEN-IN

New in V7R5 – Part 1. %LIST, %RANGE, WHEN-IS, WHEN-IN Hello everyone and welcome to this new series in which I am going to write about all the new operating codes and enhancements to ILE RPG that were introduced with IBM i’s V7R5 and subsequent TRs, including the one that has just become available for […]

Dynamic Arrays

Dynamic Arrays Dynamic arrays or Varying dimension arrays were introduced to IBM i in V7R4 and this is the minimum version and release in which they can be used. When you define a varying dimension array you are defining the maximum length you want the array to be not the actual size of the array. […]

Using Activation Groups – Part 4

IBM i Activation Groups – Part 4 In this fourth and last article about Activation Groups you’ll have the opportunity to test what happens in this situation: Use an *NEW activation group Let me tell you how this tests is done. There is one main program called ACTGRP111, a secondary program called ACTGRP2 and a support […]

Using Activation Groups – Part 3

IBM i Activation Groups – Part 3 In this third article about Activation Groups you’ll have the opportunity to test what happens in this situation: Use a user-named activation group Let me tell you how this tests is done. There is one main program called ACTGRP11, a secondary program called ACTGRP2 and a support program called […]

Using activation groups – Part 2

IBM i Activation Groups – Part 2 In the previous article about Activation Groups, Activation Groups – Part 1, you got a theoretical approach about the topic, now it’s time to test it. In this second part you’ll have the opportunity to test what happens in this situation: Use only default activation group Let me […]

Using Activation Groups – Part 1

IBM i Activation Groups – Part 1 Once upon a time an RPG programmer discover some files remained opened after the program that used them had ended. The very first thing that came to his mind was that *inlr=*on wasn’t present in the code as the program had ended without issues. So he opened the […]