It's not really interactive vs batch...
It's OPTIMIZE = *FIRSTIO vs OPTIMIZE = *ALLIO
STRSQL and Run SQL Scripts default to *FIRSTIO, embedded SQL defaults to
But either can be changed.
On Fri, Jan 17, 2020 at 11:42 AM Vernon Hamberg <vhamberg@xxxxxxxxxxxxxxx>
This is also true - generally speaking interactive will try for faster
response, so it gets the first records. Batch tends to go for all.
The only situation that is truly interactive, IMO, is a display session.
Running statements in remote connections will tend toward the batch
On 1/17/2020 12:24 PM, Sam_L wrote:
Digging into my memory, seems to me that the optimizer may decide--
differently on batch vs interactive execution. but it's been a while...
On 1/17/2020 11:49 AM, Vernon Hamberg wrote:
I agree with using Visual Explain - it would show any difference in
what the optimizer does.
Of course, when the environment changes, the optimizer might make
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,
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
Please contact support@xxxxxxxxxxxx for any subscription related
Help support midrange.com by shopping at amazon.com with our affiliate
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.