SP Problem "SET DEBUG" etc.

[navdeep virk]

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!
[url]http://join.msn.com/?page=dept/byoa[/url]

sending to informix-list

[rkusenet]

"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

[karimulla]

Hi,

Please make sure that the database is installed on your machine rather than a remote machine.May be the debug information is generated on that remote machine just check it once by logging on to that machine.

Regards,
Karimullah