| re: Too Simple Question: Statement Size
Before DB2 UDB Version8.2, the statement size limitation is 64K, since
Version8.2, the size limit can up to 2MB. I never heard the limitation come
from CLP, Command Center, or development center.
How do you measure - use your figure, I am kidding. The first time when I
met this limitation, because I could not find the documentation of this
limitation, I have to use an Editor (maybe UltraEditor, I forgot) to count
the size my sql stmt.
"Anurag" <k_anurag@Yahoo.com> wrote in message
news:1112875507.092485.102160@o13g2000cwo.googlegr oups.com...[color=blue]
> This simple one beats me all ends up(sincerely).
> I have been doing DB2 UDB for some time now, reading a lot of good
> discussions in this forum, writing some answers, asking a lot more but
> this simple question has floored me completely.
> Either I pretend that I know or I could let the kowledgable ones pass
> on some wisdom to me :-)
>
> When we say that:
> (1) "CLP in Db2 V8.2 still imposes a limit of 64K on the stored proc
> size;
> (2) "....If you use another client, such as command center or
> development center the SP size limit is 2MB";
> (3) "Statement size has been increased to allow 2M in Stinger"
>
> etc etc, what size are we referring to? I am baffled:
> (1) Is it that my text file that holds the SP code should be less than
> 64k?
> OR
> (2) How to ascertain SP size when using Development Center?
> OR
> (3) How do you measure the statement size while executing from CLP /
> Command Editor?
>
> As simple as this may be, someone pl throw light (and enlighten me).
>
> TiA...........anurag
>[/color]
| 
