RE: Maximum OBDC Query Size

Yeah I realized that once I re-read the question 😊

Looks like what you've discovered should give you enough runway unless you've had an issue with running your large statement.

One option to consider might be to call an RPG program that contains the SQL and return a resultset for processing from the RPG app perhaps.

Seems like this might be a good use case for some pre-processing on the IBMi to a temp table, but I don't know enough about the actual business case.

Regards,
Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com

------------------------------

message: 3
date: Mon, 8 Apr 2019 07:01:31 -0700
from: Spencer Elliott <spencer@xxxxxxxxxxxxxx>
subject: Re: Maximum OBDC Query Size

Hi Richard,
The question was about how big can a SQL statement be when submitted through ODBC NOT how big can the result set be. I am working on a project where I need to submit an extremely large SQL statement (in my opinion,
10k+) to the IBM i with a very large WHERE (500+ predicates) clause.

Spencer C Elliott


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

Spencer@xxxxxxxxxxxxxx