Zhe Hua Peng joshuapeng1985
forstie
/ Searching the IFS for objects with "log4j" in the name.sql
Last active
August 15, 2022 13:12
The request from a client was to provide an SQL approach to search all of the IFS, finding any object that has "log4j" in its name, and producing an SQL table with the search results.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- | |
| -- Subject: Find objects that have the string "log4j" in their name | |
| -- Author: Scott Forstie | |
| -- Date : December 13, 2021 | |
| -- Features Used : This Gist uses ifs_object_statistics, job_info, RUNSQL, and SBMJOB | |
| -- | |
| -- | |
| stop; | |
| -- | |
| -- |
forstie
/ ROUND vs QUANTIZE
Created
August 18, 2019 17:10
This example shows that QUANTIZE can be used along with decfloat rounding mode to achieve programmer control of rounding numeric values.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| values current decfloat rounding mode; | |
| set current decfloat rounding mode= round_half_even; | |
| stop; | |
| -- =============================================================================================================== | |
| -- | |
| -- QUANTIZE uses the decfloat rounding mode. | |
| -- This is the default: ROUND_HALF_EVEN | |
| -- | |
| -- Round to nearest value; if values are equidistant, round so that the final digit is even. | |
| -- If the discarded digits represent greater than half (0.5) of the value of a number in the next left position, |