Having trouble with Stored Proc building/compiling!

Hi Pete,

The stored procedure builder will look in a file called sr_cpath.bat
found in ...sqllib/function/routine for the path to the C compiler,
and the include and path environment variables. If you just set variables
this file correctly, you should be okay.

You can also set some DB2 registry variables, but only set them if the
above does not work. The registry variables are
DB2_SQLROUTINE_COMPILE_COMMAND
DB2_SQLROUTINE_COMPILER_PATH

Hope this helps.

Regards,
Zamil

"Pete" <panayotis@hotmail.com> wrote:
>
>Hello all,
>
>I have been trying to compile a stored proc in db2 with no success for a
>while now (i won't say how long, 'cause it is embarassing). I have done
everything
>by the book, but I can't get it to work. I use the MS VC++ 6.0 compiler.
>
>I keep getting the 42904 error (compiler path not set correctly, etc). I
>have put every possible directory in the include, lib and path system variables
>of my machine, but it fails miserably every time I attempt to compile a
stored
>proc.
>
>Can you please help? Any pointers/help will be very much appreciated!!!
>
>Thank you,
>pete