CLOB fields

"James H. H. Lampert via MIDRANGE-L" <[email protected]> Thu, 4 Jun 2026 17:11:57 -0700
Newsgroups gmane.comp.hardware.ibm.midrange
Message-ID <[email protected]>
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: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.