Reducing the amount of unnecessary Index Advisor data

Automatically purging the Index Advisor using a Global variable for the time to retain the data

Limiting the amount of data SELF retains

New SQL global variable introduced to help limit the amount of data kept in the SELF error log table

Attend NEUGC | NEUGC

Finding Table functions with SYSFUNCS

SQL View SYSFUNCS allows me to list all the information about Scalar, Column, and Table functions all from one place

Retrieving the description for the Audit Journal Entry Types

SQL View JOURNAL_CODE_INFO allows me to get a list of all the Audit Journal Entry Types and Journal Codes with just a simple SQL statement

March presentations

This blog is about the IBM i, formerly the AS400, and offers advice about programming, operations, communications and anything else I can think of

Improvements to GENERATE_SPREADSHEET

A number of significant improvements have been made to the GENERATE_SPREADSHEET scalar function