stored procedure compile error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

%NAME% - 12 Apr 2007 18:50 GMT

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 to this Message

Knut Stolze - 12 Apr 2007 19:50 GMT

> I tried to compile a stored procedure on DB2 v7.0 on Solaris.
>
[quoted text clipped - 4 lines]
> READS SQL DATA
> BEGIN

There is an END missing here.

> However, when I "db2 -td@ -vf test.db2", I got the following error, is
> there something wrong with
[quoted text clipped - 13 lines]
> Error in finding run directory. Using default /opt/SUNWspro/
> binSegmentation Fault - core dumped

Any reason why you are not moving to V8? There you don't need a C compiler
any longer. V7 is out of service for more than 1 year.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message