Re: Field CLOB

[Scott Klement <sk@xxxxxxxxxxxxxxxx>]

Hello Antonio,

LOB Fields (CLOB, DBCLOB, and BLOB) can only have accessed through SQL. 
  If you'd like to use SQLRPGLE and CLOB_FILE to retrieve the data to 
the IFS, and access it from the IFS, that's perfectly acceptable... It 
does not matter to HTTPAPI how you load the data into your program, so 
your question really has very little to do with HTTPAPI.

Personally, I find CLI to work best for LOB fields because I don't have 
to muck around with writing the data to a stream file, then reading it 
back, which in my opinion is extra work.   With CLI I can retrieve the 
data to a pointer in memory.  Of course, not everyone likes pointers as 
much as I do :)


Antonio wrote:
>    Hi Mr. Scott,
>    In my previous Thread on Field CLOB
>    I try to use a field of type CLOB, but if instead with a type program
>    sqlrpg I retrieve the data of field CLOB in IFS I would resolve my
>    problem. This is possible second you, and as?
>    Thanks in advance
>    Antonio

-----------------------------------------------------------------------
This is the FTPAPI mailing list.  To unsubscribe, please go to:
http://www.scottklement.com/mailman/listinfo/ftpapi
-----------------------------------------------------------------------