Hi, I am trying to create stored procedure in DB2. I am using version
v7.1.0.40, on Solaris.

The procedure is written in SQL PL and is very simple. However, I
could not build it. I got
SQLSTATE=42904 / SQL7032N error, with error in Diagnostic file
below:

My hinch is that I do not have the compiler and compile path set
correctly. I am missing a
run directory and a configuration for the .exp file. Anybody would
help? thanks!


*** BIND /u4/db2cs348/sqllib/function/routine/sqlproc/CS348/DB2CS348/
tmp/P2535180.sqc ***

DB2_SQLROUTINE_PREPOPTS=DYNAMICRULES RUN

LINE MESSAGES FOR P2535180.sqc
------
--------------------------------------------------------------------
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.

*** COMPILE /u4/db2cs348/sqllib/function/routine/sqlproc/CS348/
DB2CS348/tmp/P2535180.c ***

DB2_SQLROUTINE_COMPILE_COMMAND=cc -xarch=v8plusa -Kpic -I/u4/
db2cs348/sqllib/include SQLROUTINE_FILENAME.c -G -o
SQLROUTINE_FILENAME -L/u4/db2cs348/sqllib/lib -R/u4/db2cs348/sqllib/
lib -ldb2

#!/bin/sh
PATH=/software/.admin/bins/bin:/usr/ccs/bin:/usr/bin:/usr/ucb:/usr/
openwin/bin:/usr/dt/bin:/opt/csw/bin:/u4/db2cs348/bin:/u4/db2cs348/
sqllib/bin:/u4/db2cs348/sqllib/adm:/u4/db2cs348/sqllib/misc:/opt/
SUNWspro/bin
export PATH

SQLROUTINE_FILENAME=P2535180
export SQLROUTINE_FILENAME

cc -xarch=v8plusa -Kpic -I/u4/db2cs348/sqllib/include P2535180.c
-G -o P2535180 -L/u4/db2cs348/sqllib/lib -R/u4/db2cs348/sqllib/lib -
ldb2

*** /u4/db2cs348/sqllib/function/routine/sqlproc/CS348/DB2CS348/tmp/
P2535180.exp ***
pgsjmp

Warning: cannot determine current directory
Warning: cannot determine current directory

Error in finding run directory. Using default /opt/SUNWspro/bin
Segmentation Fault - core dumped

----------------------------------------------------------------------------

SQL7032N SQL procedure "MY_PROC" not created. Diagnostic file is
"P2535180.log". SQLSTATE=42904