Hi!
I try to get the explain-file over JDBC (because not all developers have access to the db-servers).
Following commands:
"SET EXPLAIN FILE TO '" + fileName + "' "
<Execute the explain-statements>
"SET EXPLAIN OFF"
"SELECT FILETOBLOB('" + fileName + "', 'server')" --Read the file as ResultSet
So far this work, but I´ve a problem with the Path of the filename.
We have windows & linux – servers and so I´ve not a fixed path and I don´t know, what I should use as path.
- At linux "/tmp" works.
- At windows it´s the always the sqexpln-Folder in the installation-folder (%TEMP% doesn´t work).
Any ideas or is there an easier way to get the explain for the statements?
As workaround, do I get the OS from the server over JDBC (Then I can try a list of possible folders)?
------------------------------
Kind Regards
Stefan
------------------------------
#Informix