| // Ropp's main config | |
| // https://nilesoft.org/docs/functions/id | |
| // Cheatsheet: | |
| // Types: file|dir|drive|usb|dvd|fixed|vhd|removable|remote|back|desktop|namespace|computer|recyclebin|taskbar | |
| // remove... mod etc | |
| // multiple remove (find="view|sort|paste") | |
| // all not equal to remove(where=this.name!="shit") | |
| // type is file only remove (type="file" find="run as admin") | |
| // modify( find = value [property = value [...] ]) | |
| // |
| -- | |
| -- description: What spooled files does the current user own? | |
| -- | |
| select job_name, spooled_file_name, file_number, user_data, | |
| create_timestamp | |
| from qsys2.output_queue_entries_basic | |
| where user_name = user; | |
| stop; | |
| -- | |
| -- description: Query the contents of RUNSQLSTM spooled files for the current user |
| -- Author: Scott Forstie | |
| -- Email: forstie@us.ibm.com | |
| create or replace variable coolstuff.decdate dec(6,0); | |
| set coolstuff.decdate = '190718'; | |
| -- July 18, 2019 (yes, really!) | |
| values timestamp_format(varchar(coolstuff.decdate), 'YYMMDD'); | |
| -- Wow | |
| -- Yowza |
| @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. | |
| -- | |
| -- |