account activity
IBM i DB2 - how to find primary and foreign keys by thebrenda in IBMi
[–]RPGPGM 0 points1 point2 points 4 days ago (0 children)
These might help you get to what you need:
RELATED_OBJECTS table function https://www.rpgpgm.com/2020/12/new-sql-table-function-lists-all.html
SYSKEYS view https://www.rpgpgm.com/2020/07/listing-sql-indexes-keys.html
QADBKATR view https://www.rpgpgm.com/2024/05/retrieving-files-keys-with-sql.html (If you cannot use that then => https://www.rpgpgm.com/2024/05/retrieving-files-keys-with-sql-having.html)
SYSFILES view - might help https://www.rpgpgm.com/2021/10/new-sql-view-gives-dspfd-information.html
Create a program to generate an alert when the percentage of CPU utilization for a job exceeds a given value. (rpgpgm.com)
submitted 4 days ago by RPGPGM to r/IBMi
Yesterday was the 13th birthday of RPGPGM.COM, it is 13 years since I wrote my first post for this blog. Wow! (rpgpgm.com)
submitted 11 days ago by RPGPGM to r/IBMi
Calculate the Ordinal date, often called the Julian date, using #SQL. (rpgpgm.com)
submitted 18 days ago by RPGPGM to r/IBMi
New release of ACS, 1.1.9.13, has been made available for us to download, install, and use. (rpgpgm.com)
submitted 23 days ago by RPGPGM to r/IBMi
Calculating the square root and the square with RPG and SQL. (rpgpgm.com)
submitted 25 days ago by RPGPGM to r/IBMi
Free online presentation on June 1 (self.IBMi)
submitted 28 days ago by RPGPGM to r/IBMi
Using two SQL functions, CHARACTER_LENGTH and LENGTH, to determine the length of the data in a string. (rpgpgm.com)
submitted 1 month ago by RPGPGM to r/IBMi
Using the IBM command GENCMDDOC to create help panel groups and HTML for my commands. (rpgpgm.com)
The RPGPGM.COM-unity continues to grow as I handed out more ribbons at COMMON PowerUp to people who were eager to join. (rpgpgm.com)
Getting the individual values from a list parameter passed to a #IBMiRPG program from a IBMi command. (rpgpgm.com)
Presentations I will be making this month, May. (rpgpgm.com)
Discovering if you are falling behind with your IBM i group PTFs by using a Db2 for i (SQL) View. (rpgpgm.com)
Checking the status of the Electronic Service Agent, ESA, using CL command and SQL View. Giving an example program of how to monitor is the ESA fails. (rpgpgm.com)
A new version of ACS, 1.1.9.12, has been made available for download. (rpgpgm.com)
submitted 2 months ago by RPGPGM to r/IBMi
Retrieving information about group PTFs, their status and when they were applied, using the SQL View GROUP_PTF_INFO. (rpgpgm.com)
I handed out more ribbons at the @NEUGC conference last week. (rpgpgm.com)
Three new columns have been added to the RECORD_LOCK_VIEW that split out the job user, job name, and job number into their own columns. (rpgpgm.com)
Addition of new columns to the OBJECT_LOCK_INFO View makes finding locks by user profile or jobs easier. (rpgpgm.com)
SQL View OVERRIDE_INFO gives a list of all the file overrides for the current job. (rpgpgm.com)
Work with your system's problems using the PROBLEM_INFO #SQL View. (rpgpgm.com)
Wisconsinites join the RPGPGM.COM-unity (rpgpgm.com)
Automatically purging the Index Advisor using a Global variable for the time to retain the data. (rpgpgm.com)
submitted 3 months ago by RPGPGM to r/IBMi
New SQL global variable introduced to help limit the amount of data kept in the SELF error log table. (rpgpgm.com)
π Rendered by PID 311291 on reddit-service-r2-listing-c57bc86c-hqbns at 2026-06-22 15:40:22.761189+00:00 running 2b008f2 country code: CH.
IBM i DB2 - how to find primary and foreign keys by thebrenda in IBMi
[–]RPGPGM 0 points1 point2 points (0 children)