Alas, if I wanted to create the equivalent of a pivot table using Db2 for i there is not the equivalent of the PIVOT relational operator that there is in Microsoft SQL Server.A pivot table is taking a table’s data that is in rows and “turning on its side” to become data in columns. This is best demonstrated with an example. I have a file that lists sales by color, month, and year in separator rows. I want to convert that to be one row per column and year. If I am little creative I can do pivot data with Db2 for i.I have a SQL DDL Table, TESTTABLE that contains the data I want to pivot:Read more » Read More
MustGather: How to collect and review the USERHEAPS macro output from system service tools
User heap is a type of temporary storage that the operating system uses. This document describes how to use the system service tools macro USERHEAPS output to determine the address and current size of these heaps. This support can also be used to monitor for growth of these heaps. Read More
IBM i PTF Guide, Volume 25, Number 36 – IT Jungle
IBM i PTF Guide, Volume 25, Number 36 IT Jungle Read More
SAP on IBM i: Repeatable “Refresh Database Content” for SAP Quality and Development Systems using FlashCopy Ralf Buescher
This blog entry describes a best practice for how to refresh the database content of an SAP Quality or Development System based on an IBM FlashCopy of an SAP Production System. The blog entry Homogeneous System Copy or Refresh Database Content on IBM i with SWPM using an Existing SAP … Read More
Compare All Object Authorities in a Library NickLitten
Comparing Object Authorities across different libraries is easier than you think! Using the magical powers of IBM i SQL we can easily create a spreadsheet containing all the objects in any given library and showing all their authority settings. You can run this SQL statement using green screen STRSQL or from your favorite desktop SQL Read More
