469,584 Members | 2,440 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,584 developers. It's quick & easy.

Too Simple Question: Statement Size

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

Nov 12 '05 #1
2 1637

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

Nov 12 '05 #2
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.
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Chris | last post: by
7 posts views Thread by abcd | last post: by
13 posts views Thread by aaragon | last post: by
2 posts views Thread by porter | last post: by
2 posts views Thread by --CELKO-- | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.