| @echo off | |
| set /a counter=0 | |
| for %%f in (*.jpg) do ( | |
| C:\libwebp\bin\cwebp.exe -q 80 %%f -o %%~nf.webp | |
| set /A counter=counter+1 | |
| ) | |
| echo ************************************ |
| vec3 gammaCorrect(vec3 color, float gamma){ | |
| return pow(color, vec3(1.0/gamma)); | |
| } | |
| vec3 levelRange(vec3 color, float minInput, float maxInput){ | |
| return min(max(color - vec3(minInput), vec3(0.0)) / (vec3(maxInput) - vec3(minInput)), vec3(1.0)); | |
| } | |
| vec3 finalLevels(vec3 color, float minInput, float gamma, float maxInput){ | |
| return gammaCorrect(levelRange(color, minInput, maxInput), gamma); |
| -- This fails to return data....why? | |
| SELECT cusip, issueDate, bidToCoverRatio | |
| FROM JSON_TABLE( | |
| SYSTOOLS.HTTPGETCLOB('https://www.treasurydirect.gov/TA_WS/securities/announced?format=json&type=FRN&pagesize=5', null), | |
| '$.root[*]' | |
| COLUMNS(cusip VARCHAR(10) PATH '$.cusip', | |
| issueDate Timestamp PATH '$.issueDate', | |
| bidToCoverRatio double PATH '$.bidToCoverRatio') | |
| ) AS X; | |
| stop; |
| -- ================================================================= | |
| -- Author: Scott Forstie | |
| -- Email : forstie@us.ibm.com | |
| -- Date : January 10, 2020 | |
| -- ================================================================= | |
| -- | |
| -- Setup: | |
| -- 1) create and populate the spreadsheet generator table | |
| -- 2) change the procedure source code: |
| -- | |
| -- Now that ACS is shipped on the IBM i via PTFs, we no longer need to manually move the | |
| -- acsbundle.jar onto the IBM i. Just apply the latest ACS PTFs and reference the jar | |
| -- at: /QIBM/proddata/Access/ACS/Base/acsbundle.jar | |
| -- | |
| -- Initial PTFs of ACS | |
| -- V7R4M0 SI71900 | |
| -- V7R3M0 SI71934 | |
| -- |
The latest beta (3.5) includes separate color settings for light & dark mode. Toggling dark mode automatically switches colors.
Vist iTerm2 homepage or use brew install iterm2-beta to download the beta. Thanks @stefanwascoding.
switch_automatic.py to ~/Library/ApplicationSupport/iTerm2/Scripts/AutoLaunch with:
| -- | |
| -- Subject: Extracting the IFS file name from a path, using regular expression built-in functions | |
| -- Author: Scott Forstie | |
| -- Date : September 27, 2021 | |
| -- Features Used : This Gist uses regexp_count, regexp_instr, substr, and SQL PL | |
| -- | |
| -- Function - The request was, if you have an absolute path, how can SQL extract the filename from the path? | |
| -- One approach is found below. | |
| -- | |
| -- |
| -- ======================================================================== | |
| -- | |
| -- Subject: Comparing two spooled files | |
| -- Author: Scott Forstie | |
| -- Date : December, 2021 | |
| -- | |
| -- IBM i Services used : OUTPUT_QUEUE_ENTRIES_BASIC, SYSTOOLS.SPOOLED_FILE_DATA | |
| -- SQL language features used: CTEs, Exception joins, Union, and row_number() | |
| -- ======================================================================== |
| -- | |
| -- Subject: Audit Journal Management | |
| -- Author: Scott Forstie | |
| -- Date : March, 2023 | |
| -- Features Used : This Gist uses qsys2.security_info, qsys2.journal_info, qsys2.object_statistics, qsys2.qcmdexc, CTEs, sysibmadm.env_sys_info, and SYSTOOLS.split | |
| -- | |
| -- Notes: | |
| -- =============================================== | |
| -- 1) There are many configuration options to consider using when establishing the Audit Journal, this Gist uses SQL to examine some of the most important choices. | |
| -- 2) Its important to have a retention strategy for audit journal - journal receivers |
