TechTip: Generate and Email a Spreadsheet with SQL

​[[{“value”:”SYSTOOLS.GENERATE_SPREADSHEET is a new SQL scalar function that is used to create a spreadsheet either from the results of a query or from a database file.
These services are complementary, allowing you to use SQL to create a spreadsheet from information in a database file and then email that spreadsheet.”}]] Read More 

Learning RPGLe JC_Hazard

​[[{“value”:”My career took a wild turn and I am now going to be (hopefully) an RPGLE developer, problem is I know naught about RPGLE.
Not sure where to find the RPGLE for dummies book cause I dont find any :D.”}]] Read More 

Mustgather: How to collect and review the HANDLEHEAPS macro output from system service tools

​Handle heap is a type of temporary storage that an application and the operating system use.  This document describes how to use the system service tools macro HANDLEHEAPS output to determine the jobs that own the largest handle heap and the current sizes.  This support can also be used to monitor for growth of the heaps.  If the heap fills, this will result in MCH6903 F/#hmalcmi with an activation group mark that is zero .  See the following reference for additional details on this type of heap:  Single Level Storage Heap Read More 

Verified by MonsterInsights