Too Simple Question: Statement Size

[Anurag]

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

[Fan Ruo Xin]

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_******@Yahoo.com> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

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

[Ian]

Fan Ruo Xin wrote:

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.

This reminds me of a couple of times when I literally had to remove
white space from a statement in order to get it under the 64kb limit.
Ugh.