SEO

#1 (**permalink**) 02-27-2008, 12:09 PM

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

#2 (**permalink**) 02-27-2008, 12:09 PM

%NAME% wrote:

> 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

There is an END missing here.

> 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

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.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SEO

stored procedure compile error