Michael Tiefenbacher · @globomike
3 followers · 17 posts · Server muenchen.socialWelchen Table Space verwendet #Db2 wenn man ihn beim CREATE TABLE nicht angibt? details in meinem Blog: https://www.mip.de/wissen-und-praxis/db2-tipp-basics-default-tablespace #ibmchampion
Michael Tiefenbacher · @globomike
3 followers · 17 posts · Server muenchen.social
Check out my new blog on #IBM Community site: Make Table Changes trackable by using #Db2 System-Period Temporal Tables https://community.ibm.com/community/user/datamanagement/blogs/michael-tiefenbacher/2023/05/01/make-table-changes-trackable-by-using-db2-system-p #ibmchampion
Michael Tiefenbacher · @globomike
3 followers · 14 posts · Server muenchen.socialPlease vote for this #Db2 #AHA idea to get documented and supported stored procedure to generate DDL https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24LUW-I-802 #ibmchampion
CraigMullins · @craigmullins
32 followers · 946 posts · Server mas.to
Michael Tiefenbacher · @globomike
2 followers · 8 posts · Server muenchen.socialMein neuer Blog: #Db2 Historisierung - Teil 2 - Application Period Temporal Tables und Time Travel SQL
https://www.mip.de/wissen-und-praxis/db2-tipp-historisierung-part-2-business-time-temporal-tables-und-time-travel-sql
#SQL #IBMChampion
CraigMullins · @craigmullins
31 followers · 704 posts · Server mas.toRT @Db2_Whisperer
Have you seen the new idea from #IBMChampion @LaubeBrian about a NEW SCALAR function for DB2 SQL – HEX2BIGINT? If you need to lookup RIDs in Db2for z/OS, You need this function!
https://ibm-data-and-ai.ideas.ibm.com/ideas/DB24ZOS-I-1455
@globomike @DeDUGDb2 @craigmullins @ffillmorejr
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
PJ Catalano · @psqlctln
60 followers · 65 posts · Server techhub.socialSave the date: IBM z16 at SHARE Atlanta 2023 (5–8 March 2023)
Visit the IBM Booth #135 to interact with the IBM z16, take part in an IBM Storage virtual demonstration. Here is a list of PJ's recommended activities to make the booth #experience fun:
- Take a picture hugging the z16 for #HugYourMainframeDay on 10/7
- Ask them if they can play any of PJ's #instagram reels on the booth monitors
- Wear your favorite #mainframe shirt and discuss whose is better
- Ask about the names of the two quantum safe #encryption protocols that run on z16 and then geek out
- Say loudly, in the middle of the booth, multiple times, "I wish PJ were here with us." Multiple TIMES!
- Bring golden star stickers and play pin the star on the #IBMChampion
- Bring a print out of PJ's face and hide it somewhere in the booth, if you find it, take a picture, post it on social media, tag me, and hide it for the next person
((PJ Catalano is not responsible for any personal harm or fun you might encounter.))
#experience #hugyourmainframeday #instagram #mainframe #encryption #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
CraigMullins · @craigmullins
34 followers · 532 posts · Server mas.to
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