Re: CLOB fields

if you insist to use STRSQL  .. you can do like this:

Select varchar(myclob) from mytable;

if it can be in a varchar ..

you can also cast it to a varchar and it will cut it ..


..try VScode or ACS  - you see it all there




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

> Can anybody tell me how to put a value into a CLOB field, and read the
> value back from it?
>
> Obviously accessing CLOB fields is an SQL-only thing, but if I use a
> STRSQL session, all a SELECT statement shows for the field is
> "*POINTER," and if I use Squirrel SQL through a JDBC connection, all
> that SELECT statement shows for the field is "<Clob>."
>
> When I created a record in my file (currently the *only* record in it),
> the VALUES clause for the INSERT statement had a character string in
> single quotes for the CLOB field.
>
> --
> 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.