----- Original Message -----
From: "Knut Stolze"
Al wrote:
The DBMOVE command doesn't look like the answer since it
leaves behind CLOB data.
How's that? After all, the documentation says that LOBs are
handled:
http://publib.boulder.ibm.com/infoce...e/r0002079.htm
Thanks for responding. I may be misunderstanding the docs, but what leads me
to believe this is:
| tabnnnc.yyy
| The exported LOB files of a specific table.
| "nnn" is the table number. "c" is a letter of
| the alphabet. "yyy" is a number ranging from
| 001 to 999.
| These files are created only if the table being
| exported contains LOB data. If created, these
| LOB files are placed in the "lobpath" directories.
| There are a total of 26 000 possible names for
| the LOB files.
This would seem to imply that tables with one or more CLOB fields and more
than 26,000 rows (a comically small number for a production DB) will lose
data. Is this really the case?
-Al