RE: LOB fields

[Colin Williams <colin.williams@xxxxxxxxxxxx>]

James,

There is a redbook that explains how this LOB stuff works

http://www.redbooks.ibm.com/redbooks/SG245409.html

Cheers
Colin.W

-----Original Message-----
From: James H H Lampert [mailto:jamesl@xxxxxxxxxxx] 
Sent: 13 January 2004 22:24
To: java400-l@xxxxxxxxxxxx
Subject: Re: LOB fields


Colin Williams said:

. . .
> If you use the LOB facilities available in the database, the system 
> can create links to the IFS object, and can also protect the object so 
> that it can only be accessed using the database reference, really 
> depends on what your trying to acheive, and how sophisticated you want 
> the app to be
. . .

Yes, the field in question is a CLOB field. I managed to populate it in my
test file from SQuirreL (a rather interesting Java SQL client that can talk
to the AS/400, to keep this marginally on-topic), and the value comes up in
SQuirreL, the way I typed it in, but if I then look at it using an
experimental version of QuestView that can open files with LOB fields, all I
find in my CLOB is a bunch of hex zeroes, followed by "*POINTER," followed
by some EBCDIC spaces. Nothing to indicate where the CLOB content is.

Does anybody here know where to look?

--
JHHL





_______________________________________________
This is the Java Programming on and around the iSeries / AS400 (JAVA400-L)
mailing list To post a message email: JAVA400-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/java400-l.


For the latest on Bertram Books products and services and for up-to-the-minute 
book news visit www.bertrams.com


This e-mail and any attachments may contain information that is confidential 
and privileged and is solely for the use of the intended recipient. If you are 
not the intended recipient please notify the sender and delete this e-mail and 
any attachments immediately