IBM i RUN SQL

[johnthirst]

First impressions... works well..

1. After logged in - and getting ready to run an SQL - If you do a FILE prompt. If you cancel... if you were on the SQL when you cancel switches to displays messages. Not major - just jumpy.

2. I thought there was a login issue... for the schema I added a "." to the end of the schema. It acted like it locked up (PUB400) then saw that Holger messaged that system was at 98%. Appeared locked - now system is down to 70ish% and is working. Possibly there was a timeout that was not caught?

3. Originally when I logged in - when I ran against table in which would be in the library list, it did a file not found. But using dot notation, it would work. Now that the system is 70ish% it works.

So, I currently can't reproduce 2 and 3.

A clear button might be useful for messages.

A prompt for table names list could be useful.

I'll keep on testing.

[bobcozzi]

about to update it with tons-o-fixes. Note that there is the SQL Naming option in the Settings (probably Connection Settings) and that allows *LIBL when *SYS is used. Using *SQL requires a name for the library/schema.

[bobcozzi]

Also, what platform are you running? Windows or Mac?
The new .dmg for Mac/OS (Apple) is out now: https://github.com/bobcozzi/open-runsql/releases/download/v0.1.0-macos/ibmi-runsql.dmg

[johnthirst]

Busy day today... I'm running it on Windows 11. I'll download the updated code and give it a shot. Might be Wednesday.