From rpgpgm.com
IBM Power9 maintenance end of life
1 1
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Tue, 12PM
From rpgpgm.com
New built in functions %HIVAL and %LOVAL
0 1
The RPG Built in Functions %HIVAL and %LOVAL allow me to test a variable against its maximum or minimum allowed value
on Thu, 10AM
From rpgpgm.com
How to create a logical file with data from more than one member
0 0
Creating a DDS logical file that contains data from more than one member from the based upon DDS physical file.
on Jan 9
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Jan 6
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Jan 2
From rpgpgm.com
0 0
Happy 2025! What this web site did last year and what we have to look forward to in the New Year.
on Jan 1
From rpgpgm.com
How to run a SQL statement that is in a column of a table
0 0
How to execute a SQL statement that is in a column of a SQL Table, using SQL.
on Dec 26
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Dec 20
From rpgpgm.com
How to define a file twice for two members?
0 1
How to define two define two files in a RPG program, when they are really one file with two members.
on Dec 19
From rpgpgm.com
0 0
The Db2 for i (SQL) and RPG PTFs for IBM I 7.5 TR5 and 7.4 TR11 are released today.
on Dec 13
From rpgpgm.com
0 0
What I am doing with the data that SELF, SQL Error Logging Facility, has generated.
on Dec 12
From rpgpgm.com
Auto incrementing elements to Auto extending array
0 0
How to automatically increment the array element counter for a RPG auto-extending array.
on Nov 28
From rpgpgm.com
Technology Refresh PTFs for RPG are now available
0 0
IBM i 7.5 Technology Refresh 5 and 7.4 TR11 PTFs for RPG now available.
on Nov 22
From rpgpgm.com
0 0
New version of IBM Access Client Solutions, ACS 1.1.9.7, is now available to download and install.
on Nov 22
From rpgpgm.com
Using expression in CL call parameters
0 0
Using CL Built in Functions in the Parameter parameters of the CL CALL command
on Nov 21
From rpgpgm.com
IBM Power11 is coming, but not announced
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Nov 20
From rpgpgm.com
Fall 2024 IBM i Performance Guide
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Nov 15
From rpgpgm.com
Using Fields BiF to update Subfile
0 0
Using the RPG Built in Function %FIELDS to update subfile records
on Nov 14
From rpgpgm.com
0 0
The ACTIVE_QUERY_INFO Table Function allows me to see things about SQE queries that I cannot with other DDL Views or Table Functions
on Nov 7
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Nov 2
From rpgpgm.com
0 0
Special Authority Data Mart created to allow me to see which profiles have special authorities, and to capture the information over time into a file.
on Oct 31
From rpgpgm.com
Retrieving the library that contains the currently running program
0 0
Retrieve the name of the library the currently running program is found in, and show it on a display file.
on Oct 24
From rpgpgm.com
0 0
The Audit Journal Data Mart gives me the ability to copy journal entries from QAUDJRN and store them in a SQL table. I can then use the data any way
on Oct 17
From rpgpgm.com
0 0
Audit Journal Entry Services make it so much easier to retrieve data from the Audit Journal, QAUDJRN.
on Oct 3
From rpgpgm.com
0 0
This page describes the reason why I started this blog about the IBM i, a bit about me and my experiences with the IBM i and its predecessors.
on Sep 28
From rpgpgm.com
Copy source members to the IFS
0 0
Using a CL program to copy source file members to individual files in the IFS
on Sep 26
From rpgpgm.com
New View lists all file members
0 0
New SQL View makes the process of getting information about file members so much easier with lots of interesting columns of information
on Sep 19
From rpgpgm.com
Improvements to the SQL scalar function that sends email
0 0
Within IBM I 7.5 TR4 and IBM I 7.4 TR10 come a number of useful enhancements to the SQL scalar function SEND_EMAIL
on Sep 12
From rpgpgm.com
Extra columns in a Select statement but not in the group by
0 1
Including columns in the result set for a SQL statement that are not listed in the Group By clause.
on Sep 5
From rpgpgm.com
Retrieving Printer File information using SQL
0 0
New SQL View allows me to learn about all the printer files in my partition, including information about the record formats.
on Aug 29
From rpgpgm.com
Finding logical files that exist in a different library to the physical
0 1
Finding a way to list all the dependent objects that are not in the same library as their parent with SQL
on Aug 15
From rpgpgm.com
Updates to the SYSDISKSTAT View and Table Functions
0 1
Recent updates to the SYSDISKSTAT SQL View and Table Function allows me to get to information that was not available before.
on Aug 14
From rpgpgm.com
New version of ACS, 1.1.9.6, out now
0 0
New version of IBM Access Client Solutions, ACS 1.1.9.6, is now available to download and install.
on Aug 9
From rpgpgm.com
Deleting objects in the IFS with a SQL scalar function
0 0
Delete objects from the IFS using a SQL scalar function, and using a table function to diagnosed the errno returned
on Aug 8
From rpgpgm.com
Comparing differences between objects in two IFS directories
0 0
Using SQL to compare for differences between objects in two different directories in the IFS, and even in different databases/partitions
on Aug 1
From rpgpgm.com
Now possible to build SQL Alias over last member
0 0
Now I can use *LAST when creating a SQL Alias to always point to the last member in the DDS physical file
on Jul 25
From rpgpgm.com
List all object types using SQL
0 0
Being able to get a list of all the object types from a Db2 for I,SQL, View. Includes IFS and non-IFS object types.
on Jul 18
From rpgpgm.com
New functionality added to RPG's SND-MSG op code
0 0
The new Technology Refreshes, IBM i 7.4 TR4 and 7.4 TR10, bring changes to the RPG operation code to write message to the job log, SND-MSG
on Jul 12
From rpgpgm.com
Deleting old device definitions
0 0
Deleting virtual device descriptions that have not been used for a long time
on Jul 11
From rpgpgm.com
Constant keyword added to RPG definitions
0 0
Constant keyword added to RPG definitions so that the value(s) contained within the variable or data structure cannot be changed
on Jul 4
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Jul 1
From rpgpgm.com
Create an Excel spreadsheet from a CL program
0 0
Generate a Microsoft Excel spreadsheet from a CL program using SQL
on Jun 28
From rpgpgm.com
Using SQL table function to lookup SQL codes
0 0
Retrieve the message text for any valid SQL code using this Db2 for i table function
on Jun 26
From rpgpgm.com
0 0
Today marks the eleventh anniversary of the first post on the RPGPGM.COM blog
on Jun 13
From rpgpgm.com
0 0
Finding which virtual devices have not been used for 6 months using SQL
on Jun 7
From rpgpgm.com
Withdrawal of support for some development tools
0 0
IBM announce the end of support for a number of IBM i development tools, effective April 2025
on Jun 6
From rpgpgm.com
0 0
This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of
on Jun 3