Compiling Stored Procedures on Solaris using gcc

ggnanaraj · #1 (**permalink**) 11-20-05, 07:51

DB2 UDB 7.2
Solaris Sparc 8
gcc

Has any one been able to compile a stored procedure using gcc on Solaris Sparc 8 - DB2 UDB 7.2?

db2 -td@ -vf <procname>

Registry variables have to be modified. I tried using what gcc uses on Linux. But it fails.

TIA.

przytula · #2 (**permalink**) 11-20-05, 12:26

why not indicating the error immediatly ?
how can we guess what is going wrong ?
using gcc is possible..

wangzhonnew · #3 (**permalink**) 11-20-05, 20:39

CHANGED THE DB2_SQLROUTINE_COMPILE_COMMAND AS
FOLLOWING:
DB2SET DB2_SQLROUTINE_COMPILE_COMMAND="GCC -FPIC -D_REENTRANT -I/HOME/TS5INST/SQLLIB/INCLUDE SQLROUTINE_FILENAME.C -SHARED -LPTHREAD -O SQLROUTINE_FILENAME -R/HOME/TS5INST/SQLLIB/LIB -R/USR/LOCAL/LIB -L/HOME/TS5INST/SQLLIB/LIB -L/USR/LOCAL/LIB -LDB2" AND THEN RECYCLE DB2, THEN RECREATE SQL PROCEDURE.

hope it work.
please give error message next time

ggnanaraj · #4 (**permalink**) 11-23-05, 03:18

Quote:

Originally Posted by wangzhonnew

CHANGED THE DB2_SQLROUTINE_COMPILE_COMMAND AS
FOLLOWING:
DB2SET DB2_SQLROUTINE_COMPILE_COMMAND="GCC -FPIC -D_REENTRANT -I/HOME/TS5INST/SQLLIB/INCLUDE SQLROUTINE_FILENAME.C -SHARED -LPTHREAD -O SQLROUTINE_FILENAME -R/HOME/TS5INST/SQLLIB/LIB -R/USR/LOCAL/LIB -L/HOME/TS5INST/SQLLIB/LIB -L/USR/LOCAL/LIB -LDB2" AND THEN RECYCLE DB2, THEN RECREATE SQL PROCEDURE.

hope it work.
please give error message next time

Thanks a ton! It works with the following case changes...

Code:

db2set DB2_SQLROUTINE_COMPILE_COMMAND="gcc -fpic -D_REENTRANT -I/export/home/db2inst1/sqllib/include SQLROUTINE_FILENAME.c -shared -lpthread -o SQLROUTINE_FILENAME -R/export/home/db2inst1/sqllib/lib -R/usr/local/lib -L/export/home/db2inst1/sqllib/lib -L/usr/local/lib -ldb2"

GET ROUTINE also works. However, PUT ROUTINE fails with the following error:

PHP Code:


			
$ db2 "put routine from UPDATE_SALARY_1.sar"

SQL0443N  Routine "PUT_ROUTINE_SAR" (specific name

"db2udp!put_routine_sar_1parm") has returned an error SQLSTATE with diagnostic

text "-14847,      , failed ...".  SQLSTATE=38000

$

Internet Services

Web Development

Digital Marketing

Consumer Tech