no..... the file is being created in /sql/x.prt
in the same place where the sql file is sitting


i need the file to be created in /reports/x.prt


in the former, i use ......... SPOOL x.prt
in the latter,
i tried ....... SPOOL /../../../x.prt
also...
i tried ....... SPOOL '/../../../x.prt'
i tried ....... SPOOL "'/../../../x.prt'"
i tried ....... SPOOL "/../../../x.prt"