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

Tweets

685
Followers

258
Following

53
Likes

416

SQL iQuery for #IBMi (aka Q38) @sqliquery

a year ago

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

0 0 0 78 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

a year ago

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

1 1 9 365 1

SQL iQuery for #IBMi (aka Q38) @sqliquery

a year ago

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

0 0 0 59 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Hey @notesofbarry how to I make the "Actions" thingy appear? It isn't showing up on my VSCode session. What did I miss?

1 0 0 180 0

Download Image

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 0 83 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Great opportunity for newbies (New to i or N2I) developers to hear from the SQL guy, himself. Check it out. lnkd.in/gSY4nqbf

0 0 0 61 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 1 87 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Another great read in IT Jungle this week. lnkd.in/gcyUFtcS

0 0 0 53 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Final day out of the office at our 2nd home away from home. Back pounding the keyboard on Tuesday. #IBMi35 lnkd.in/gjgzACRg

0 0 0 73 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Happy Birthday #IBMi35. Sorry i can’t make the party… heading into the storm instead. #Islandlife

0 0 1 49 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

#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

0 0 0 63 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

#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

0 0 0 47 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 0 51 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 0 55 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 0 63 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 0 40 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

Cool article in today's ITJungle by a Author you might recognize. lnkd.in/gqEgD9GT

0 0 0 34 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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

0 0 1 91 0

SQL iQuery for #IBMi (aka Q38) @sqliquery

2 years ago

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