RPGPGM · @rpgpgm
21 followers · 97 posts · Server mastodon.socialA 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
RPGPGM · @rpgpgm
21 followers · 95 posts · Server mastodon.socialHandling 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
RPGPGM · @rpgpgm
21 followers · 94 posts · Server mastodon.socialSpeeding 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
RPGPGM · @rpgpgm
21 followers · 93 posts · Server mastodon.social#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
RPGPGM · @rpgpgm
21 followers · 92 posts · Server mastodon.socialUseful #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
RPGPGM · @rpgpgm
21 followers · 91 posts · Server mastodon.socialNew #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
RPGPGM · @rpgpgm
21 followers · 90 posts · Server mastodon.social
📣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
RPGPGM · @rpgpgm
21 followers · 89 posts · Server mastodon.socialOnce 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
RPGPGM · @rpgpgm
21 followers · 88 posts · Server mastodon.socialRetrieving 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
RPGPGM · @rpgpgm
21 followers · 87 posts · Server mastodon.socialUsing #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
RPGPGM · @rpgpgm
21 followers · 86 posts · Server mastodon.socialFinding remote journals using #SQL.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/02/discovering-remote-journals-with-sql.html
#sql #ibmi #rpgpgm #ibmchampion
RPGPGM · @rpgpgm
21 followers · 85 posts · Server mastodon.socialUsing #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
RPGPGM · @rpgpgm
21 followers · 84 posts · Server mastodon.socialUsing 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
RPGPGM · @rpgpgm
21 followers · 83 posts · Server mastodon.social
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
RPGPGM · @rpgpgm
21 followers · 82 posts · Server mastodon.socialUsing #SQL to check if there are available firmware updates.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2019/07/checking-for-firmware-updates.html
#sql #ibmi #rpgpgm #ibmchampion
RPGPGM · @rpgpgm
21 followers · 81 posts · Server mastodon.socialUsing #SQL to find display the job locks for a particular job.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2020/06/new-sql-table-function-to-display-jobs.html
#sql #ibmi #rpgpgm #ibmchampion
RPGPGM · @rpgpgm
21 followers · 80 posts · Server mastodon.socialUsing #SQL to be proactive in identifying which user profiles have disabled their Netserver profile.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2023/02/identifying-profiles-with-disabled.html
#sql #ibmi #rpgpgm #ibmchampion
RPGPGM · @rpgpgm
21 followers · 79 posts · Server mastodon.socialFriday 10 March I will be speaking to the #LUG in Singapore.
For those of you in Asia this is an opportunity to hear me speak without having to stay up late, or get up early.
To learn more & sign up go to ➡️ https://www.meetup.com/singapore-aix-ibm-i-linux-on-power-meetup-group/events/291462816/
💙 #IBMi #rpgpgm #IBMChampion #LUG #AS400 #ASEAN
#lug #ibmi #rpgpgm #ibmchampion #as400 #asean
RPGPGM · @rpgpgm
21 followers · 78 posts · Server mastodon.socialFinding the smallest and greatest values in a #IBMiRPG array using BiFs.
💙 #IBMi #rpgpgm #IBMChampion
https://www.rpgpgm.com/2021/09/new-rpg-bif-to-retrieve-greatest-and.html
#ibmirpg #ibmi #rpgpgm #ibmchampion
RPGPGM · @rpgpgm
21 followers · 77 posts · Server mastodon.socialThe CTXiUG is pleased to announce their guest for their next meeting, in March. Patrick Behr is a well-respected speaker, and is giving two presentations that will be of interest to all #IBMiRPG programmers. Go to the website to learn more and register https://ctxiug.blogspot.com
#IBMi #rpgpgm #IBMChampion
#ibmirpg #ibmi #rpgpgm #ibmchampion