SET EXPLAIN ON

I have experienced difficulties with not being able to create the sqexplain.out file in one directory or another. Usually I have had something more important to do than chase down what is really wrong with file and/or directory permissions, but I am sure that is where the conflict lies. A work around that I have used on occasions is to create sqexplain.out by another means outside of ISQL. (e.g. cat, or vi file creation). set explain on will cause output to be appended to the file if it already exists and that seems to wrok around the permission problem. that is probably the key to the original problem, too. +-----------------------------+------------------------------------------+ | Con Woodall | Internet: cwoodall@vth1.vth.colostate.edu| | Veterinary Teaching Hospital| | | Colorado State University | Voice: (303) 491-1244 | | Fort Collins, CO 80523 | Fax: (303) 491-1205 | +-----------------------------+------------------------------------------+