QSYS2.GENERATE_SQL stored procedure
QSYS2.GENERATE_SQL stored procedure Welcome to a new article about the best server in the world, yes IBM i. This time I will write about a DB2 for i Service that can be used to obtain SQL Data Definitions statements (DDL) from any database object. This can be very useful in case you want to convert […]
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 […]
Common Iberia
Common Iberia 2023 (English Version) Common Iberia 2023 is near to take place and I’m very excited to announce that I will be speaking there. If you want to know more, keep reading. You can find the Spanish version of this post below. Yes, Common Iberia is here and this time it will take place […]
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 […]
Common Europe 2023 – The place where you should have been
Yes, I’m back from Prague, the place where took place Common
Common Europe Congress 2023
Yes, Common Europe Congress 2023 is here. And this year is a very special year for IBM i. This year IBM i is celebrating 35
Welcome to the blog
“Welcome to the jungle, we got fun and games…” Yeah it’s the beginning of the first Guns N’Roses song I ever heard.
