471,897 Members | 1,463 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,897 software developers and data experts.

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 1717

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 YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.