473,226 Members | 1,373 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

Limits to statement size in ISERIES

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.
Mar 10 '08 #1
2 4857
--CELKO-- wrote:
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.
http://publib.boulder.ibm.com/infoce...mstlimtabs.htm
2MB for the past couple of releases.

--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Mar 10 '08 #2
--CELKO-- wrote:
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.
In v5r4:
Maximum length of an SQL statement (in bytes) 2 097 152
(from:)
http://publib.boulder.ibm.com/infoce...mstlimtabs.htm

Prior to that:
Longest SQL statement 65535
(from:)
http://publib.boulder.ibm.com/infoce...mstlimtabs.htm

--
Karl Hanson
Mar 10 '08 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Thad Rizzi | last post by:
My webserver is an iSeries and I want to run some PHP scripts on it using SQL to access data on the iSeries. Does anyone have any exapmles or resources on the most effective way to do this? I...
2
by: bccbccbcc | last post by:
Anyone know if there is an analagous statement for the "USE" statement used in SQL Server? I am trying to prevent from having to change all the references to a database in my sql statement. I...
4
by: erkki | last post by:
Hi, I have to move iSeries library to new DB2 database. Is there any easier way to do this moving operation than exporting all tables in iSeries into text files and then import them into DB2...
1
by: Yanik Reid | last post by:
When I run the following vb.net code, I'm not able to acces the my database AMFLIB. I use to be able to access AMFLIB with the old ODBC driver from IBM iSeries Access but now I want to use the...
17
by: Sulu's Beard | last post by:
Hey gang, I'm evaluating the CA ERWin product for an upcoming data warehousing project. I'm most excited about the reverse engineering aspect of this system. I've sucessfully tested it on a...
3
by: Laurence | last post by:
Hi there, Does somebody know the efficent way to connect DB2/400? Through iSeries Access ODBC/OLEDB driver or DB2 Connect? Which will more fast and efficent? In addition, does DB2 Connect use...
3
by: roberto | last post by:
I have a table (ORDERS) with this kind structure (this is not the really table): OrderId Product Amount Agent1 Agent2 Agent3 ________ _______ ______ ______ ______ ______ 000001 ...
2
by: pmlane2001 | last post by:
I have a PHP SOAP XML file size problem that I was wondering if anyone has seen before. I have an XML file that when I put it through my PHP script with 270 lines (13,082 KB) it works fine. If I...
2
by: --CELKO-- | last post by:
What are the current query size limits (bytes) for various DB2 products?
3
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 3 Jan 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). For other local times, please check World Time Buddy In...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
by: MeoLessi9 | last post by:
I have VirtualBox installed on Windows 11 and now I would like to install Kali on a virtual machine. However, on the official website, I see two options: "Installer images" and "Virtual machines"....
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...
0
by: Aftab Ahmad | last post by:
So, I have written a code for a cmd called "Send WhatsApp Message" to open and send WhatsApp messaage. The code is given below. Dim IE As Object Set IE =...

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.