Re: Maximum OBDC Query Size

[Spencer Elliott <spencer@xxxxxxxxxxxxxx>]

Hi,
The maximum length of an SQL statement (in bytes) = 2,097,152
Maximum number of predicates in a WHERE or HAVING clause = *statement*

Got any idea what "*statement*" means? Does it mean that it is limited by
the statement size?

Also, does this really mean I can submit a single SQL statement to the IBM
i through ODBC that is 2 Mb?

 Thank you,

Spencer C Elliott


949-366-5234 X152 (O) l (949) 544-1237 (Skype)

Spencer@xxxxxxxxxxxxxx


www.s4isystems.com

Follow us:

[image: Follow_us][image: Follow_us][image: Follow_us][image: Follow_us][image:
Follow_us]

NOTE: This email message and any attachments are for the sole use of the
intended recipient(s) and may contain confidential and/or privileged
information. Any unauthorized review, use, disclosure or distribution is
prohibited. If you are not the intended recipient, please contact the
sender by replying to this email, and destroy all copies of the original
message.


On Mon, Apr 8, 2019 at 4:42 AM Rob Berendt <rob@xxxxxxxxx> wrote:

> These may be correct
> http://www.ibm.com/support/knowledgecenter/
> Search for IBM i
> IBM i 7.2 documentation
> Availability
> Maximum capacities
> SQL limits
> SQL
> Maximum length of an SQL statement (in bytes)
> Maximum number of predicates in a WHERE or HAVING clause
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of
> Spencer Elliott
> Sent: Sunday, April 7, 2019 1:49 PM
> To: midrange-l@xxxxxxxxxxxxxxxxxx
> Subject: Maximum OBDC Query Size
>
> Hi,
> Does anyone know the maximum size of a SQL Query that can be issued to a
> V7R2 system through OBDC? Also, what is the maximum size of a WHERE clause?
>
> Thank you,
>
> Spencer C Elliott
>
>
> 949-366-5234 X152 (O) l (949) 544-1237 (Skype)
>
> Spencer@xxxxxxxxxxxxxx
>
>
> www.s4isystems.com
>
> Follow us:
>
> [image: Follow_us][image: Follow_us][image: Follow_us][image:
> Follow_us][image:
> Follow_us]
>
> NOTE: This email message and any attachments are for the sole use of the
> intended recipient(s) and may contain confidential and/or privileged
> information. Any unauthorized review, use, disclosure or distribution is
> prohibited. If you are not the intended recipient, please contact the
> sender by replying to this email, and destroy all copies of the original
> message.
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com