Now on my lunch but talking to a Jr. earlier today I realize that job status on an IBM i isn't really well explained anywhere on their site.
What started the whole talk was a SIGW job, which I explained is "usually" a job that's in sleep and waiting for a signal to wake up.
We stepped through the code together to point it out, but yeah, nowhere in the docs indicating this. #ibmi
Apparently, in addition to being an #IBMi (As/400) shop, @canadiantire also uses raspberry pis
My company started to introduce git to mainframe developers. For many of them it is a culture shock. On the other hand many git experts donβt understand how the mainframers have been working for the past couple of decades. I try to build a bridge between the two parties with my latest video:
#mainframe #git #as400 #sclm #ibmi #devops
A simple way, using #SQL, to check if the current user profile belongs to particular group profile.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/03/easy-way-to-validate-if-user-has.html
#sql #ibmi #rpgpgm #ibmchampion
Handling fields from file that are VARCHAR and/or null in a #CL program.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2021/04/handling-variable-length-variables-in-cl.html
#cl #ibmi #rpgpgm #ibmchampion
Speeding up #CL CPYF using control blocking overrides.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2015/06/using-control-blocking-to-improve.html
#cl #ibmi #rpgpgm #ibmchampion
#IBMiRPG Monitor groups finally get to act like #CL MONMSG with a new operation code.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2022/05/new-way-in-rpg-to-monitor-for-errors.html
#ibmirpg #cl #ibmi #rpgpgm #ibmchampion
#ICYMI Be sure to check out our latest livestream with @burkeholland and @notesofbarry.They demo how easy #vscode makes it to learn and use #COBOL and #RPGLE on #IBMi with language integration, #debugging and sandbox mode! Watch it here π½οΈ
https://youtube.com/live/SvTZoFa5UO8
:sys_twitter: https://twitter.com/code/status/1628493660458196993
#ICYMI #vscode #cobol #rpgle #ibmi #debugging
Useful #SQL Views that allow me to see Function Usage Identifiers, and whether I am authorized to them.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/02/finding-out-if-i-am-authorized-to.html
#sql #ibmi #rpgpgm #ibmchampion
New #SQL scalar that returns the date of the first of the month for any date.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/02/using-sql-to-get-first-of-month-for-date.html
#sql #ibmi #rpgpgm #ibmchampion
π£Tricks with Spool Files using SQL
π TOMORROW Tuesday February 21 @ 6:00 PM (US ET)
π’SEMIUG
π http://www.semiug.org
π° FREE & online
π #IBMi #rpgpgm #IBMChampion #IBMiLUG
#ibmi #rpgpgm #ibmchampion #ibmilug
Once I have loaded my #IBMiRPG data structure array from an #SQL multi-row fetch I can then sort its contents, any way I want, using this.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2021/09/new-bif-added-to-sorta-to-make-sorting.html
#ibmirpg #sql #ibmi #rpgpgm #ibmchampion
Retrieving data from the System Directory using #SQL.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2022/07/access-system-directory-information-via.html
#sql #ibmi #rpgpgm #ibmchampion
Excellent cheatsheets for RPG - with link to IBM documentation for each keyword! π
https://www.markonetools.it/rpg-iv-free-interactive-cheatsheet/
Thank you, Marco!
https://twitter.com/MarcoRiva73
Using #SQL which file in the IFS contain a certain string.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2022/04/list-rows-in-ifs-files-that-contain.html
#sql #ibmi #rpgpgm #ibmchampion
Finding remote journals using #SQL.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/02/discovering-remote-journals-with-sql.html
#sql #ibmi #rpgpgm #ibmchampion
Using #SQL to perform a domain lookup helps you validate email addresses.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2022/09/using-sql-to-perform-domain-lookup.html
#sql #ibmi #rpgpgm #ibmchampion
Using a #SQL View to give a CL program everything it needs to know about todayβs date.
π #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2020/10/getting-day-of-week-in-cl-program-using.html
#sql #ibmi #rpgpgm #ibmchampion
π’ @notesofbarry is back on the #vscode livestream to demo the latest enhancements that make #IBMi access and education more accessible for everyone! Mark your π
and join us
π¬
#COBOL #RPGLE
https://aka.ms/code-livestream-page
:sys_twitter: https://twitter.com/code/status/1624853601465118720
Thank you to MAGIC User Group & everyone who attended last night's meeting.
Next up COMMON's FOCUS2023 next Tuesday afternoon β‘οΈ https://common.org/focus2023/glance
Will I "see" you there?
π#IBMi #rpgpgm #IBMChampion #IBMiLUG
#ibmi #rpgpgm #ibmchampion #ibmilug