Praveen wrote:

> Hi All,
>
> We have installed DB2 UDB V8 on Sun SPARC 9. The GCC compiler also
> installed on this system. So, when i try to create SQL procedure, it
> says CC not found. So,
> I set the following compiler options..
>
> 1. db2set DB2_SQLROUTINE_COMPILER_PATH=/usr/local/bin
>
> 2. db2set DB2_SQLROUTINE_COMPILE_COMMAND="cc -xarch=v8plusa -mt
> -I/export/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c -G -o
> SQLROUTINE_FILENAME -L/export/home/db2inst1/sqllib/lib
> -R/export/home/db2inst1/sqllib/lib -ldb2"

The issue here is that you're using options for the Sun C++ compiler,
but you are trying to compile with the gnu C++ (g++) compiler.
(i.e. -xarch and -mt aren't valid options for g++).

I'm not sure if the GNU compilers are supported on any platform besides
Linux, but you could certainly try. The defaults for the
DB2_SQLROUTINE_COMPILE_COMMAND are documented in the AppDev Guide:
Building and Running Applications.


Good luck,




-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----== Over 100,000 Newsgroups - 19 Different Servers! =-----