trying to get the output of a bteq script in unix to format. I am running a query to look at the top 10 worst queries. the largest field is the sql text... the output looks bad and not easy to format once you move it to windows. I am looking for a way to run this as automation and email the output so it is easy to read or easy to format.
bteq <<EOF>> $output/suspquery.log
.set width 9000
.set format on
.set format off
mailx -s "Suspect Query Report" \email@example.com < $output/suspquery.log
Am also trying to acheive the same but my output file should be an excel to the end users.
Trying to get database spae report and bad queries report.
Please help me if you alreayd done this