Re: Select Results to File

Hi Andrew,

 

The short answer is, "No."

 

It's an interesting idea, and it's been requested before. If you search the archives for the subject "Export Oracle table to Flat file" you'll find a thread that discusses the idea of spooling the results to a file without needing to load the results into the GUI (and into memory). I don't think an clear enhancement request has been entered for this feature. It is related to the recently added request 1709361, but that one would probably be a detail under a more complete feature request. Requests 1498978 & 1055934 are also similar.

 

It would probably be useful if you could enter the key points that are needed into an enhancement request.

 

Regards,

Matt

---

From: squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx [mailto:squirrel-sql-users-bounces@xxxxxxxxxxxxxxxxxxxxx] On Behalf Of Andrew Melton
Sent: Friday, 04 May, 2007 12:23
To: Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
Subject: [Squirrel-sql-users] Select Results to File

I have a query which is returning hundreds of thousands of 
rows.  The output of the query will ultimately be the input to a 
process.  Therefore, I don't really need to see the results displayed on 
the screen, I just need them written to a file.  

Can the query 
results spool to a file, bypassing the screen?

Thanks.
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/_______________________________________________
Squirrel-sql-users mailing list
Squirrel-sql-users@xxxxxxxxxxxxxxxxxxxxx
https://lists.sourceforge.net/lists/listinfo/squirrel-sql-users