stored procedure compile error I tried to compile a stored procedure on DB2 v7.0 on Solaris.
The procedure is very simple as below:
CREATE PROCEDURE fullamount(OUT fullamnt DOUBLE)
language SQL
READS SQL DATA
BEGIN
However, when I "db2 -td@ -vf test.db2", I got the following error, is
there something wrong with
my compiler setting? Thanks a lot!
cc -xarch=v8plusa -Kpic -I/u4/db2cs348/sqllib/include P4827770.c
-G -o P4827770 -L/u4/db2cs348/sqllib/lib -R/u4/db2cs348/sqllib/lib -
ldb2
*** /u4/db2cs348/sqllib/function/routine/sqlproc/CS348/DB2CS348/tmp/
P4827770.exp ***
pgsjmp
Warning: cannot determine current directory
Warning: cannot determine current directory
Error in finding run directory. Using default /opt/SUNWspro/
binSegmentation Fault - core dumped |