Re: CLOB vs STRING

David,

One technique you could use is simply to store a link (URL, file path,
whatever) to the CLOB in a text field. The file doesn't get too large (as it
would if you try to store the CLOB in a big CHAR/VARCHAR field), there's no
CLOB-retrieval overhead if you don't need the CLOB (for instance if you're
just interested in other fields in the file), and it's pretty flexible,
since it's up to you how/where you store the CLOB.

Rory

On Wed, Feb 16, 2011 at 1:51 PM, Scott Klement <rpg400-l@xxxxxxxxxxxxxxxx>wrote:

Hi David,

CLOB cannot be used with RLA. It may not work as expected with various
tools (CPYTOSTMF, CPYTOIMPF, et al), and I have no clue what happens if
you try to FTP a file with a LOB in it.

CLOB variables are never stored in the record buffer, they have to be
fetched separately, which performs slower. (You can make CHAR/VARCHAR
work that way as well, but it's not that way by default.)

On the other hand, LOB variables (CLOB, BLOB, DBCLOB) have the advantage
that they can be very large (megabytes). That's simply not possible
with CHAR/VARCHAR.

So they are good for some things, and bad for others. It's just a
matter of using the right tool for the job.


On 2/16/2011 2:25 PM, dmosley@xxxxxxxxxx wrote:

Does anyone know of any problems (performance-wise, or something else)
when using a CLOB RPG variable.

We have stored procedures that calls normal RPG programs. We had a very
generic parameter set where one of the IN params was a 32,000 VARYING
field.
Well, the value of the field got to be too large so we changed it to a
(CLOB:64,000). Now, we are thinking of rasing that size up as well.

So, I'm just curious to know if anyone has used them much, and if , (in
there own opinion), are a good idea or not. And why.

Thanks everyone,
David


David L. Mosley, Jr.
Technical Solutions Architect
Dancik International, Ltd.
2000 CentreGreen Way, Suite 250
Cary, NC 27513

www.dancik.com

--
This is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.