Home
About IBM i, SQL, RPG and anything else …
Posts
-
Automatically initializing ILE-RPG service programs
Sometimes your service program needs some initialization before it is able to run. But calling an initialization procedure in each of the programs, that uses the service program, is somehow inconvenient.
-
Avoiding SQL injections in ILE-RPG with embedded SQL (SQLRPGLE)
Dynamic embedded SQL is a great tool, if you have to create your SQL statements depending on user input. But “inserting” those user inputs directly into your SQL statement string, can be very dangerous. This kind of attack is called SQL injection.
-
Rational Developer for i 9.8 vs Windows 11 Version 24H2
Since Microsoft rolled out Windows 11 version 24H2 many users had massive problems using RDi 9.8 after the update. Other Java based applications - like IBM i Access Client Solutions (iACS) make problems, too.
-
Rational Developer for i Fix-Pack 9.8.0.4 available
Today IBM made the latest update for Rational Developer for i available. The new Version is 9.8.0.4.
-
IBM Champion 2025
To my surprise, I was selected to be an IBM Champion 2025.
-
Generating SHA-512 hashes using IBM i crypto APIs
My task was, to find differences between many source code files (members or IFS) on different systems. To achieve this, I settled on the idea, to build hash codes over the sources, and to compare the hashes. And calculating the hash values was easier as I initially thought, because IBM i has a great set of integrated crypto API’s.
-
QPGMR Blog Re-IPL’ed
After 6 years of using hosted WordPress I thought its about time, to change something. And as I’m a big fan of MarkDown and Git, I wanted to make use of this, for my blog.
-
Rational Developer for i 9.8 - Tips and Tricks
With the availability of RDi 9.8.0.3 and the latest compiler PTFs I updated my compiled list of RDi 9.8 tips and tricks that piled up since the first beta.
-
Multi threading with ILE-RPG
The POSIX API for multithreading - called
pthreads- is the classic way, to run multiple procedures parallel at the same time and in the same process. Using it in ILE-RPG is quite easy, if you know how. -
Consuming a web service with SQL on IBM i
Consuming web services on IBM i was never easier – but in fact, it’s nothing new, the DB2 SQL functions are available at least since Version 7.2.
-
IPL
Welcome to my blog.
subscribe via RSS