RE: STRQMQRY and Interactive SQL

Maybe that it doesn't return the entire data set when displaying the first
screen of results and finishes up during the user 'think time'. When
directing
output to a file the 'think time' is gone so the query is optimized to return
the entire result set.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]
On Behalf Of Lim Hock-Chai
Sent: Friday, May 11, 2007 10:12 AM
To: Midrange Systems Technical Discussion
Subject: RE: STRQMQRY and Interactive SQL

Did some more testing and find out that it create temporary access path when
I
select to output to file. It does not create temporary access path when
output
to screen. Strange.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Lim Hock-Chai
Sent: Friday, May 11, 2007 9:41 AM
To: Midrange Systems Technical Discussion
Subject: STRQMQRY and Interactive SQL

I've a sql statement that when I run it in interactive sql, it does not try
to
create temporary index file. When I run it using STRQMQRY, it try to create
temporary index. Anybody know why?


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment
to review the archives at http://archive.midrange.com/midrange-l.


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To
post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or
change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment
to review the archives at http://archive.midrange.com/midrange-l.




Privileged and Confidential. This e-mail, and any attachments there to, is
intended only for use by the addressee(s) named herein and may contain
privileged or confidential information. If you have received this e-mail in
error, please notify me immediately by a return e-mail and delete this
e-mail.
You are hereby notified that any dissemination, distribution or copying of
this
e-mail and/or any attachments thereto, is strictly prohibited.

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.