SQL iQuery for #IBMi (aka Q38) @sqliquery
Transform your legacy Query/400 to modern SQL while also being able to easily run native Db2 for i SQL from CL or the Web. sqliQuery.com Chicago, IL Joined July 2018-
Tweets685
-
Followers259
-
Following53
-
Likes416
Happy Hubble telescope clock rollover day, everyone. With a 32-bit unsigned integer tracking time in 1/8 of a second, Hubble's clock rolls over to 0 every 17 years or so. Today was the 2nd time in Hubble's lifetime that this happened. Move along. #Hubble
With the shrinking & inactive #IBMi market and lack of interest in paid 3rd party software, I have decided to release SQL iQuery for free. It is now available over on my GitHub page github.com/bobcozzi/SQLiQ… The legacy sqliquery.com website will be shut down June 1 2024
Updated our SQL Tools for IBM i package. The new SQL Function POWER_SCHEDULE returns the entries of the "GO POWER" schedule you've set up. Check it out today. SQLiQuery.com/SQLTools
Hey @notesofbarry how to I make the "Actions" thingy appear? It isn't showing up on my VSCode session. What did I miss?
I have to wonder if this LinkedIn article, caused the current Security Vulnerability to be exposed? lnkd.in/gZDDCdrq Referenced article from itJungle: lnkd.in/gvXMNtn6 lnkd.in/gZSwYtM4
Great opportunity for newbies (New to i or N2I) developers to hear from the SQL guy, himself. Check it out. lnkd.in/gSY4nqbf
Two new SQL functions/procedures for #IBMi RNMOBJ (Rename/Move Object) allows you to use SQL to rename or move IBM i objects. READSRC (Read Source member) is a high performance interface that allows you to retrieve the source state…lnkd.in/gmcB2UEC lnkd.in/gs3VHdVW
Another great read in IT Jungle this week. lnkd.in/gcyUFtcS
Final day out of the office at our 2nd home away from home. Back pounding the keyboard on Tuesday. #IBMi35 lnkd.in/gjgzACRg
Happy Birthday #IBMi35. Sorry i can’t make the party… heading into the storm instead. #Islandlife
#IBMi customers, note: the SQL Tools RTVDTAQD function and the IBM DATA_QUEUE_INFO View update the *DTAQ object's LAST_USED_DATE. While this isn't a show-stopper, it is an important and undocumented "feature" of which I was unaware of until now. The cause…lnkd.in/giEFnVKn
#IBMi35 - Back in 1980 I attended my First COMMON event in Cleveland OH, attending as an employee of a Corp Member. The theme was "Our 20th Year". In 1983 I joined COMMON as an Individual Member after starting the first of several midrange (lowercase 'm')…lnkd.in/gMQK_f52
Been wondering if anyone has ever used the DAYS USED RESET DATE and DAYS USED COUNT attributes of an #IBMi object? Not to be confused with Date Last Used, which is highly important, but has anyone actually needed the Days Used and Days Used Reset Date? I'…lnkd.in/gN3gN-Na
2 new awesome, exclusive SQL functions for #IBMi are now available in #SQLTools RTVPRTFD (Retrieve Print File Description) PRTF_LIST (List Print Files Descriptions) I never knew I needed PRTF_LIST until I used it last week. It is a…lnkd.in/g3-Zgux6 lnkd.in/gs3VHdVW
We're working on a new SQL Function to retrieve PRINT FILE Descriptions. Currently there is no way to do that other than calling the native API. We've got it running on our system with the object list function to get a list of all #ibmi PRTF files. I've…lnkd.in/gtJ7YzeE
I attended my first COMMON.org conference in 1980. By 1990 (their 30th anniversary) over 4600 Attendees were showing up. I would regularly see over 200 people in each of my own Lectures/Sessions with some of my popular sessions getting 900 to…lnkd.in/gzUG24C2
Cool article in today's ITJungle by a Author you might recognize. lnkd.in/gqEgD9GT
Formally deleted #RDi (Rational Developer for i) from my systems. After the poor v9.8 licensing issues, I've decided to make things easier. I've replaced with Visual Studio Code or VSCode from Microsoft. I product I've been using almost as long as it's be…lnkd.in/gtDTtPdk
I've added a pair of useful #IBMi CL commands to my github page. These two commands allow Users to safely start and end TCP/IP HTTP Servers. It wraps the STR/ENDTCPSVR commands in nice STRHTTPSVR and ENDHTTPSVR user-written CL Commands. You're welcome! lnkd.in/gQpmqm8Q

Torbjörn Appehl @tappehl
2K Followers 2K Following IBM ISV Advisor & IBM Champion for Power Systems since 2016
IT Jungle @ITJungleNews
2K Followers 148 Following IT Jungle was created to help you figure out how to survive, adapt, and thrive in this complex IT ecosystem, whether you are an end user of information technolo
Matt Seeberger @mkseeberger
337 Followers 418 Following #JesusFollower. #TheBeardedGeek. #IBMiEngineer. Programmer, Problem Solver, DIYer
Alex Woodie @alex_woodie
3K Followers 3K Following Managing Editor of BigDATAwire, Senior Editor at IT Jungle
nrsenthil @nrsenthil2
4 Followers 171 Following
Sayali Bhorde @BhordeSaya81046
0 Followers 2 Following
l_o_powers @larryopowers
18 Followers 23 Following
Mario Luis Rodriguez ... @mairo1504
380 Followers 7K Following Soy amigo fiel y con principios únicos
giovannygu @giovanny11465gu
92 Followers 1K Following
Joe Carter @joetcarter
1K Followers 483 Following
Sever @Sever_i
1 Followers 52 Following
uthesunday @uthesunday
272 Followers 791 Following #MUFC #bigdata #HybridCloud #cybersecurity #Linux #Vmware #Virtualization #Cloud
xtrem medium @MediumXtrem
0 Followers 15 Following
Viruslogic @Viruslogic
4 Followers 15 Following
Jacob Anderson @JacobAn36912021
5 Followers 58 Following
Tomas Martinez @T0masM
22 Followers 88 Following Software Engineer. #IBMi / #Systemi / #iSeries / #AS400 (or Whatever IBM decides to call it this week) enthusiast.
nothing @Gabscratchr
3 Followers 10 Following
J @jmpabc01
0 Followers 41 Following
Bruce Collins @BruceHossCollin
1 Followers 35 Following
rainierio @rainierio
460 Followers 923 Following
Kbatt @Kbatt9
1 Followers 61 Following
Builder Solutions @LANSA_Recruiter
18 Followers 273 Following LANSA Recruiter with over 20 years recruiting. I know who is who and would like to help
Prabhleen Sharma @PrabhleenSharm1
10 Followers 414 Following
Alonso @aresICC
12 Followers 223 Following
ascervftj @ascervftj
32 Followers 206 Following
Manu gupta @Manugupta86
24 Followers 374 Following
Adam Taylor-Williams @adam_on_i
274 Followers 90 Following @KatoIntegration IBM i dev. #ibmi enthusiast, PASE aficionado, ILE fan. @GatewayTech grad. He/Him. 🏳️🌈
Benjamin FAVRET @benjamin_favret
19 Followers 252 Following iHuman near his iDevices. #IBMi lover. #Zelda lover
Gregory Martin @mrgamartin
58 Followers 296 Following Proud Dad of Lacrosse and Swim athletes. IT Professional
Miguel @BONALDEMIGUEL
158 Followers 2K Following One should not pursue goals that are easily achieved. One must develop an instinct for what one can just barely achieve through one's greatest effort - Einstein
The Parks @as400pe
56 Followers 1K Following
Adolfo Vera @adolfoverapy
67 Followers 391 Following Dispongo cierto tiempo para proyectos pequeños de conversion o actualizacion de programas en RPG sobre DB2 for i, no publico nada sobre trabajoKevin Patterson @kepatter72
8 Followers 133 Following
Rick Montgomery @RickM39402
2 Followers 42 Following
SD2021 @SD20212
1 Followers 59 Following
Rajesh @rajeshravitweet
149 Followers 1K Following
Marc Couture @couturem
1 Followers 125 Following
Abel Willium @AbelWillium
50 Followers 815 Following We are .net development company that caters to all your .net technology needs Full-cycle dot net development services to produce world-class desktop, web.
knib @knibknib2
27 Followers 489 Following
Arturo Reyna @ArturoRrynaF
2 Followers 17 Following Programador as400 Diplomado en Administración de Proyectos
Vikthor H. Manoath @vhmanoath
25 Followers 864 Following
arlenstovall @arlenstovall
173 Followers 269 Following
Christian Larsen @ChristLarsen
64 Followers 170 Following Programador informático. Difícil de explicar. Adoro a mi familia. #España #Malaga #LaTierra 🇪🇸
David A. Vitteri @david_vitteri
32 Followers 2K Following
Jesse Gorzinski @OSSJesseG
1K Followers 285 Following Open Source Enthusiast. Irish Lord of Kerry. Fan of Apache Camel. Not an agent or representative of any company in the context of this account.
Scott Forstie @Forstie_IBMi
2K Followers 81 Following Db2 for i Business Architect. https://t.co/GBCpTwiOSx
Torbjörn Appehl @tappehl
2K Followers 2K Following IBM ISV Advisor & IBM Champion for Power Systems since 2016
Simon Hutchinson @RPGPGM
1K Followers 74 Following #IBMiguru, #IBMChampion (x5), #IBMiCommunity advocate, President of @CTXiUG, @COMMONug SME, John Earle Speaker scholar, & founder of https://t.co/VSJOWkhHfK.
Dawn May @DawnMayiCan
2K Followers 329 Following IBM i expert, Immed Past President of COMMON North America, IBM Champion. I blog, write, and speak about IBM i. An advocate for #IBMi Education and Community.
IT Jungle @ITJungleNews
2K Followers 148 Following IT Jungle was created to help you figure out how to survive, adapt, and thrive in this complex IT ecosystem, whether you are an end user of information technolo
Ranga Deshpande @RangaDesh
728 Followers 253 Following #IBMi monk #IBMChampion #Maverick #Trailblazer @COMMONBe & Eu, CIO Executive Circle Belgium, Hospital IT, #ESG @JulesBordet Innovation, Aerobiology Walking
Steve Will @Steve_Will_IBMi
3K Followers 109 Following Steve is CTO and Chief Architect for the IBM i operating system, used by hundreds of thousands of enterprises world wide. IBM i runs on IBM Power Systems.
Common Europe @CommonEurope
950 Followers 968 Following Common Europe is an umbrella for IBM user associations, representing 19 European countries. Empowered by our differences, united by European values.
Bob Cozzi @bobcozzi
654 Followers 485 Following "Be like water, my friend" -Bruce Lee. — I dare you to do better.
Birgitta Hauser @BirgittaHauser
671 Followers 102 Following
Dave W Plummer @davepl1968
88K Followers 74 Following Hi! I'm Dave Plummer. You might remember me from such Windows components as Task Manager, Windows Pinball, Calc, ZIPFolders, Product Activation, etc. Cheers!
DBeaver @dbeaver_news
6K Followers 26 Following The universal database manager for working with SQL and NoSQL. https://t.co/vaQl4J5Hpi https://t.co/VVCTDNujjA https://t.co/1APO93R7Bg
i Magazine・IS magaz... @iMagazine6
148 Followers 1K Following IBM i(AS/400)ユーザー、IBMユーザーのシステム構築・運用、モダナイゼーション、DXをリードする情報をご提供しています。創刊2000年。We focus on the Dev/Sec/Ops and Modernization and DX of IBM i and IBM users since 2000
LUG Large User Group @LUG_Office
337 Followers 61 Following Since 1994, the LUG has facilitated a unique relationship between IBM development and over 100 companies who have significant investment in IBM i™ products.
The Iron Monger - Ala... @The_Iron_Monger
1K Followers 547 Following A Technological Artisan certified for IBM Iron. Love sharing technical knowledge. Views here are my own #NerdHerd #AIX #IBMi Proud #IBMChampion - Alan Fulton
The Omni User @omniuser
314 Followers 107 Following An Association of Chicagoland Computer Professionals focused on IBM midrange servers now known as IBM i
S4i Systems @S4iSystems
282 Followers 345 Following Work Simplified with Enterprise Document Management inclusive of imaging, data capture, distribution, archive, retrieval, eForms & workflow.
Therese Eaton @tetweetings
804 Followers 805 Following Leads IBM UK’s #Data, #AI & #Automation Tech Sales Channel Team | #watsonx | #aiops | Speak4myself
Jyoti Dodhia @JyotiDodhia
1K Followers 1K Following Retired, still interested in IBM Power Systems. All opinions are my own. I was previously a Power Technical Specialist at IBM UK Ltd.
Mike Ryan @mikeryaniUG
160 Followers 30 Following chairman i - UG the user group for IBM i professionals.Marcel Sarrasin @marcelsarrasin
118 Followers 45 Following
Utilities 400 @Utilities400
835 Followers 609 Following Providing the IBM i community a comprehensive suite of innovative solutions designed to enrich and enhance your #IBMi enterprise (tweets by Andrew Nicholson).
Christine McDowell @ChristineMcDowe
95 Followers 148 Following Senior Marketing Director @freschesolution #IBMi
Steven McIver Jr. @smciverjr
123 Followers 79 Following IBM i, VIOS, Power Systems, FlashSystems. Senior System Administrator at @ServiceExpress
Doug Mack @mckdrmoly
216 Followers 17 Following Db2 for i Consultant for IBM specializing in Analytics and Database Modernization
ProData Computer Serv... @ProDataPro
133 Followers 36 Following ProData is a leading provider of IBM i software tools, including it's famous database utility, DBU!
Midrange Dynamics Nor... @MDCMSNA
239 Followers 65 Following Drive your business forward with products built to empower your change management, DevOps, and CI/CD processes and Rest API creation. Learn more: https://t.co/hhRDab74AR
Kim Greene @iseriesdomino
501 Followers 217 Following President of Kim Greene Consulting, Inc. specializing in Domino and collaboration solutions for IBMi and Windows consulting with over 20 years of experience.
PowerWire @PowerWire
635 Followers 468 Following Independent IBM #PowerSystems, #IBMi, #AIX & #PowerLinux news & tech tips Views our own...
Andrew Borts @andrewbytes
187 Followers 298 Following Nerd, Barbershopper, short attention span... uh.. Nerd, Barbershopper...
Common Sweden-Data3 @commonsweden
446 Followers 426 Following The Swedish usergroup for IBM Power systems.
Tim Rowe @TimRowe_IBMi
725 Followers 19 Following Business Architect Application Development & Systems Management IBM i
Von Enselman @enselman
471 Followers 423 Following Director of Professional Services for iTech Solutions specializing in Quality Assurance on the IBM i
Pete Massiello @petem59
1K Followers 194 Following @iTech_Sol is an IBM Premier Business Partner, specializing in IBM i. As certified IBM i System Administrators, we can help you with all your #ibmi needs.
IBM Research @IBMResearch
229K Followers 1K Following Inventing what's next in science and technology. 🌍🔬 Subscribe to our newsletter: https://t.co/kyfsvQN1Dn
IBM @IBM
714K Followers 4K Following We don’t just imagine the future. We build it. 🤝 We create with technologists, developers, engineers and our partners to build a smarter world. 🌎
IBM Hybrid Cloud & In... @IBMcloud
229K Followers 3K Following We deliver secure, AI-ready infrastructure like z17 & LinuxONE to power hybrid cloud. Let’s create smarter business — together.
Scott Klement @darkbagel
1K Followers 33 Following IBM i enthusiast, RPG programmer, Gamer, and generally a geek.
COMMON - A Users Grou... @COMMONug
3K Followers 2K Following #IBMiEducation, networking community, industry advocate and leading education provider for Power Systems users. #NAViGATE2024 Registration Below
Mike Pavlak @MikeyPEI
1K Followers 301 Following Solution Engineer at Perforce and IBM i (AS/400, iSeries, etc. & PHP, Python, Node.js & Open Source Geek)
HELP400 @help400
469 Followers 46 Following HELP400 was the publisher of ServerNEWS, the IBMi Spanish magazine. Now curate content for digital magazines like 'IBMi Spotlight' and 'NEXT Computing Era'.
ARCAD Software @arcad_software
811 Followers 766 Following ARCAD Software is global leader in Application Lifecycle Mgt on #IBMi - Change & Release Mgt, Test automation, Application Analysis, Enterprise #Modernization
Charles Guarino @charlieguarino
956 Followers 76 Following #IBMi enthusiast, IBM Champion, Moderator of iChime, Podcaster at Tech Talk SMB, Speaker, Business Owner, Application Developer using Modern Tooling, #RDi