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.
As an Amazon Associate we earn from qualifying purchases.