Professional Web Applications Themes

SP Problem "SET DEBUG" etc. - Informix

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 ...

  1. #1

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

    sending to informix-list
    navdeep virk Guest

  2. #2

    Default Re: SP Problem "SET DEBUG" etc.


    "navdeep virk" <nvirkmsn.com> wrote in message news:bmhfvl$95t$1terabinaries.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


    rkusenet Guest

  3. #3

    Smile Re: SP Problem "SET DEBUG" etc.

    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
    karimulla Guest

Similar Threads

  1. Drag and drop problem with "dragEnabled" and"allowMultipleSelection"
    By tata668@gmail.com in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: April 4th, 02:29 AM
  2. How to debug? "No Symbols Have Been Loaded"
    By asdf in forum ASP Components
    Replies: 0
    Last Post: January 29th, 12:47 PM
  3. WebService timeout after setting debug="false"
    By wcchan in forum ASP.NET Web Services
    Replies: 3
    Last Post: January 10th, 12:11 AM
  4. Error: "Unable to debug on server,Access is denied"
    By ganesh in forum ASP.NET General
    Replies: 1
    Last Post: August 6th, 11:33 AM
  5. how to setting Debug in "Client" Developers ?
    By Edmilson in forum ASP.NET General
    Replies: 0
    Last Post: July 1st, 06:19 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139