All Forums Database
phil1212 5 posts Joined 11/05
09 Jan 2006
redirect explain plan in a file

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.

al1_24 39 posts Joined 11/04
09 Jan 2006

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

You must sign in to leave a comment.