Let’s upgrade this super simple HELLO WORLD program to add some more standards and functionshttps://www.nicklitten.com/course/rpg-101-tweaking-hello-world-to-make-it-a-bit-more-fancy/ Read More
Security Bulletin: IBM HTTP Server (powered by Apache) for IBM i is vulnerable to a denial of service attack using HTTP/2 protocol. [CVE-2023-44487]
IBM HTTP Server (powered by Apache) used by IBM i is vulnerable to a denial of service attack due to mishandling of multiplexed streams in HTTP/2 protocol as described in the vulnerability details section. This bulletin identifies the steps to take to address the vulnerability as described in the remediation/fixes section. Read More
SQL and data area RPGPGM
[[{“value”:”Capturing the results of a #SQL statement into a data area.
https://www.rpgpgm.com/2024/03/capturing-sql-results-into-data-area.html
[ #IBMi #rpgpgm #IBMChampion ]
submitted by /u/RPGPGM[link][comments]”}]] Read More
Establishing the Visibility Needed for Effective IBM i Security
Tue, Mar 19, 2024 12:00 PM CDT (6:00 PM Europe/Stockholm) Read More
Capturing SQL results into a data area Simon Hutchinson
[[{“value”:”The idea for this post came from a Facebook thread. The question was: “Does anyone know of a way to insert the result of an SQL SELECT into a CL Variable? I can make an SQL select into a table and read (RCVF) the file of course… But can it be done in a more “direct” way?” One of the replies to the question piqued my interest.
Before I start showing examples of code I needed a SQL statement that anyone with a recent release of IBM i could execute in their partitions. I came up with retrieving the record length for the SYSDUMMY1 table. I find the easiest way to get that information is to use the SYSFILES SQL View.
01 SELECT MAXIMUM_RECORD_LENGTH
02 FROM QSYS2.SYSFILES
03 WHERE SYSTEM_TABLE_SCHEMA = ‘SYSIBM’
04 AND SYSTEM_TABLE_NAME = ‘SYSDUMMY1’
Read more »”}]] Read More
