473,574 Members | 2,248 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

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...........a nurag

Nov 12 '05 #1
2 1808

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.goo glegroups.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...........a nurag

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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
2505
by: calfliu | last post by:
hello: everybody! I have a simple question. How can I translate the selected value from art to recipient(hidden input button)? <form name="send" method="post" action="send.cgi"> <select name="art" size="1" style=font-size:9pt onChange="Setvalue()"> <option value="ad2">ad</option>
1
1373
by: Ryan | last post by:
I've just inherited a system and have some concerns about the speed of connections to a remote server (SQL2000). If I do a simple select statement on the table below, it takes 14 minutes to retrive 6 million rows across a 2Mb line. Obviously it's a reasonable amount of data to retrieve, but I would have thought this would be quicker if I'm...
4
1681
by: Anurag | last post by:
I feel really embarassed asking this. However, ask I will. 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"
1
1035
by: Chris | last post by:
Sorry to ask such a simple question but here it is, and I'm am new to ASP/WEB I am designing a site and I want to make it general so I can easily change the font/color/sizes of the tables/datagrids on the fly. Do I have to load in the scheme I want and adjust every attribute myself or is there a simple way of doing it that I'm missing. I...
7
2274
by: abcd | last post by:
I am trying to set up client machine and investigatging which .net components are missing to run aspx page. I have a simple aspx page which just has "hello world" printed.... When I request that page like http://machinename/dir1/hellp.aspx instead of running that page it starts downloding ...whats missing here ....why the aspx engine...
13
1523
by: aaragon | last post by:
Hi everyone, I just wanted to know if there is any difference in performance in declarating the variables in the beginning of a function or within for loops. For example: double test() { double a,b,c; for(int i=0; i<n; i++){
2
1624
by: porter | last post by:
Im guessing this is a really simple question. How do server-side includes work in c#? For example, I have a swtich statement and depending on its output, I want to include different files. I had the code in VB and then tried to port it over but I just cant find the C# file comand. switch(kind) { case "parts": page +=...
2
4886
by: --CELKO-- | last post by:
We just got a "SQL Statement too long or complex" error on the ISERIES. James was able to get a compile after replacing some full table names with (much shorter) correlation names, etc. I have not see his query, but what are the statement size limits? I thought they would be so large that this should not happen in a practical situation.
0
7831
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7746
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
8092
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
7842
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
8129
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...
0
6497
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5641
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
3768
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
1092
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.