SP Problem "SET DEBUG" etc.

Folks, The vesion of informix is 7.31.UC6A , I have created a procedure however with I was trying to debug it the debug file did not get generated . CREATE PROCEDURE foo( x int ,y int ) returning int, int ; define etc.. -- then I added the following SET DEBUG FILE TO "dbg.out"; TRACE ON; FOREACH Select ... etc.... END FOREACH TRACE OFF; END PROCEDURE; The procedure compiles fine but no debug is generated. Am I missing something ??. Rgds. Navdeep _________________________________________________________________ Add MSN 8 Internet Software to your current Internet access and enjoy patented spam control and more. Get two months FREE! http://join.msn.com/?page=dept/byoa sending to informix-list

"navdeep virk" <nvirk@msn.com> wrote in message news:bmhfvl$95t$1@terabinaries.xmission.com... > > Folks, > > The vesion of informix is 7.31.UC6A , I have created a procedure however > with I was trying to debug it the debug file did not get generated . > > CREATE PROCEDURE foo( x int ,y int ) returning int, int ;> > define etc.. > > -- then I added the following > > SET DEBUG FILE TO "dbg.out"; > TRACE ON; > FOREACH > Select ... etc.... > END FOREACH > TRACE OFF; > > END PROCEDURE; > > The procedure compiles fine but no debug is generated. > > Am I missing something ??. > > Rgds. I bet you are running the procedure from a client box. This normally happens when the user id of the client box does not have a home directory on the server. The best recourse is to give a full path to the DEBUG FILE set debug file to '/tmp/dbg.out' ; rk- -- email id is bogus