Prev: Shift_JIS to UTF-8 Conversion
Next: convert a decimal number into character
From: spider007 on 7 May 2008 05:48
Hi,

I want to pass a 2-3GB file as a parameter (XML type) to a Stored
procedure. Is that possible? What is the max limit of parameter size
for XML datatype?

Thanks.
From: Serge Rielau on 7 May 2008 06:48
spider007 wrote:
> Hi,
>
> I want to pass a 2-3GB file as a parameter (XML type) to a Stored
> procedure. Is that possible? What is the max limit of parameter size
> for XML datatype?
There is a limit of 2GB for CLOBs (which I presume your file to be in
the end).
I'm curious why is this file so big?

Cheers
Serge

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
 | 
Pages: 1
Prev: Shift_JIS to UTF-8 Conversion
Next: convert a decimal number into character