If you execute the SET DEBUG FILE statement with a simple filename on a local database, the output file is located in your current directory. If your current database is on a remote database server, the output file is located in your home directory on the remote database server. If you provide a full pathname for the debug file, the file is placed in the directory that you specify on the remote database server. If you do not have write permissions in the directory, you receive an error.
The following example sends the output of the SET DEBUG FILE TO statement to a file called debug.out:
SET DEBUG FILE TO 'debug' || '.out'
Related statement: TRACE
For a task-oriented discussion of SPL routines, see the IBM Informix Guide to SQL: Tutorial.