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
midrange.com
