Re: CLOB fields

Rob Berendt <[email protected]> Fri, 5 Jun 2026 14:06:40 -0400
Newsgroups gmane.comp.hardware.ibm.midrange
Message-ID <CAPJ+qQMXUP91dNAi80H_8SOcFcisBggyX9ps1rCYtM7pn5geMA@mail.gmail.com>
James,
There is ZERO license requirements for iACS anymore.  None.  Well, at least
on current versions of the OS.
I know you have your own 5250 product and perhaps that is why you eschew
iACS.  There's nothing stopping you from using Run SQL Scripts and continue
to use your own 5250 product.

"Beginning with version 1.1.9.1 an  IBM i Access Family license is no
longer required to use  the 5250 emulation and Data Transfer features."
https://www.ibm.com/support/pages/ibm-i-access-client-solutions

There is a difference between
7.4 license
https://www.ibm.com/docs/en/i/7.4.0?topic=solutions-license-information
and beyond
https://www.ibm.com/docs/en/i/7.5.0?topic=solutions-license-information
IDK if they just stopped updating the 7.4 documentation and you can use
newer versions of iACS on it without the license.  I don't see why not.
After all, your 5250 product doesn't care about the license, right?  So why
should the newer versions of iACS check based on os version either?  It
might not.
And, even when a license was required it wasn't for Run SQL scripts.  It
was just for 5250, data transfer and the now deprecated iAccess for Web.

On Fri, Jun 5, 2026 at 11:36 AM James H. H. Lampert via MIDRANGE-L <
[email protected]> wrote:

> On 6/5/26 12:18 AM, Daniel Gross wrote:
>
> > IBM i Access Client Solutions Run SQL Scripts shows CLOBs
> > automatically, and shows their contents. STRSQL does not - and it's
> > also somehow archaic. Other tools are also not always perfect in this
> > way.
>
> Right, but remember, we're not an iACS shop here. I can get a web
> browser iNav session on our cloud Midrange box, but I don't see anything
> about "Run SQL Scripts." Do I need something else?
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: [email protected]
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: [email protected]
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact [email protected] for any subscription related
> questions.
>
>
-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact [email protected] for any subscription related questions.