Re: Set explain utility
I do not know of any utility that can do this, but since using SET
EXPLAIN implies optimization of queries in a program, which implies
access to the source code of a program, why not create your programs in
a way that allows you to accomplish SET EXPLAIN ON/OFF by using an
environment variable?
For example, at the start of each program you place the following code:
main
define setexplain char
let setexplain = fgl_getenv("SETEXPLAIN")
if setexplain = "Y" then
set explain onelse
set explain off
end if
...
end main
This way, when you want to test, you simply set your UNIX environment
variable SETEXPLAIN to Y and you're happy!
Best regards,
Nigel
MarkDenham@15.96.48.192.in-addr.arpa wrote:
>
> All
>
> I'm looking for a utility that I can use to run an SQL statement, with
> SET EXPLAIN ON.>
> I want to be able to stop the program after the query profile has been
> analysed,
> before it has a chance to retrieve too much data from the database.
>
> Anybody got a utility like this?
>
> Mark
> MarkDenham@aol.com (home)
> Denham.M@amstr.com (work)
--
+--------------------------------------------------------------------+
|Name : Edmund Nigel Gall Atlantic Avenue |
|Title : Information Systems Specialist Pt. Lisas Industrial Estate|
|Company: Process Plant Services Ltd. Pt. Lisas, Couva |
| Trinidad & Tobago, W.I. |
| Business Personal |
| mailto:nigelg@ppsl.com mailto:nigelg@ppsl.com |
| Phone : (868) 636 3153/2878/3195 Phone : (868) 662 6611 |
| Fax : (868) 679 3770 Fax : (868) 662 6611 |
+------------------------ http://www.ppsl.com -----------------------+