SQL iQuery for #IBMi (aka Q38)

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.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry Yes, that's what I did before posting the last note. I removed all newlines & made it wordwrap. Which solved the issue. I had a similar issue with cut/paste in ACS RUNSQL Scripts where the paste embeds newlines & passes them on UDTF parameters causing an issue for list parms. Thx

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry in VS Code for i, how do I compile a non-RPG app? I'm coding C++ for i and need to compile it but all I see are CRTPGM and CRTSRVPGM listed when Cmd+E is pressed (on MacOS)

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry Further tests shows that it is seeing the secondary lines of the command as separate commands instead of one long one. See this image:

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry Yes. I checked on CRTCPPMOD has a default SRCFILE parameter of SRCFILE(*LIBL/QCPPSRC) so for some reason when run through QSH or via VSCODE, it isn't passing or perhaps not seeing the SRCFILE parameter option. NOTE: If I CHGCMDDFT on the server to QCSRC, it obviously works.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry Thanks. Must be some issue with the CPP compiler. It just gives an error looking for QCPPSRC which I've never seen before on 5250 CL commands.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@farzyness Not a Doctor, but likely due to food availability and content. Meaning processed food, food additives and of course the number of "forever chemicals" in our bodies in Developed/ing countries. (those without good laws/regulations concerning food)

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@nitroargo @notesofbarry I will try that. Thanks

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry what do I need to do to get VSCode for I to connect to a V7R2 system when this message is displayed? "Timeout while waiting for handshake"
Besides SSHD, is there something else that needs to be opened up? (e.g., Ports?)

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry This is a client's system. A Power9 with V7R2. They're using an IP white-list instead of a VPN to provide access. I don't think I've ever used SSH to do anything so the answer is haven't tried.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

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

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry Okay, it let me attach both save files to the Release. I left the original links to the dropbox download as well for now. Thanks for the suggestion!

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

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
https://t.co/f2PfOLkNp1
The legacy https://t.co/tD0gFr8CIo website will be shut down June 1 2024

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry I thought I looked at that but the have a 25MB limit on files. Perhaps that limit isn't imposed for Releases? IDK

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@AntonGombkoetoe @notesofbarry Unless its Mac OS in which case it is LF/CR not CR/LF IIRC.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@davepl1968 @IntNostalgia Sure would be nice to have EDIT on Twitter/X 😁

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@davepl1968 @IntNostalgia I enjoyed using MFC. Before they created "tabbed dialogs" for use non-MS coders, I created one in the community that is currently still being used today by a Retailing in their Point-of-Sale customer signature capture routine.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

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. https://t.co/edBOK5ktI4

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@OSSJesseG It'll likely change by at least 80% in 3 to 5 years. So I think "future proof" unlikely. No standards (i.e., "everything is open source") means "next week" the newest tech de jour appears for its 15 minutes of fame.

[SQL iQuery for #IBMi (aka Q38) @sqliquery]

@notesofbarry @OSSJesseG Some things in VS Code get broken and then fixed "right away".
Not necessarily a CODE for i issue, verses a VSC component or plug. As a former S/38, AS/400 and now IBM i developer, I'm unfamiliar with bugs induced by frequent updates. Once that adolescents passes, I'm all in.