View Single Post

   
  #1 (permalink)  
Old 02-27-2008, 12:09 PM
%NAME%
 
Posts: n/a
Default 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

Reply With Quote