|
|
|
Junior Member
 
Group: Forum Members
Last Login: 1/23/2006 8:36:00 AM
Posts: 16,
Visits: 1
|
|
Hello,
I have to create a bteq script that automaticly get sql query done (in dbc.accesslog) for a user, and then do the explain plan of these queries.
But i need to redirect theses explain plans in a file.
WHat is the best way to do that ?
In a bteq, how d oyou redirect the result of a query in an os file ?
Thanks a lot.
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 6/27/2008 7:19:28 AM
Posts: 42,
Visits: 54
|
|
use the following commands in your bteq to export the result of a query to a file :
.export report file="filename"
your query;
.export reset
|
|
|
|