Hi,
OS: SUN 7.2.3
DB: DB2 7.2 with fickpack 11
Compiler :sunone Forte compiler pack [ForteDev_sparc-s1scc-FCS-
ML-solspar
c]
H/W: ultra 10 256 MB Ram ,enough swap space
When i try to run a procedure the following error occurs
ECCCL.ADD_DELEGATE - Create stored procedure returns -7032.
ECCCL.ADD_DELEGATE:
*** BIND /export/home/db2inst1/sqll
ib/functio
n/routine/
sqlproc/EC
CCLSOL/ECC
CL/tmp/P09
36190.sqc ***
LINE MESSAGES FOR P0936190.sqc
------ --------------------------
----------
----------
----------
----------
--
SQL0060W The "C" precompiler is in progress.
SQL0091W Precompilation or binding was ended with "0"
errors and "0" warnings.
*** COMPILE /export/home/db2inst1/sqll
ib/functio
n/routine/
sqlproc/EC
CCLSOL/ECC
CL/tmp/P09
36190.c ***
DB2_SQLROUTINE_COMPILER_PA
TH=/export
/home/db2i
nst1/myenv
DB2_SQLROUTINE_COMPILE_COM
MAND=CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1/sq
llib/inclu
de SQLROUTINE_FILENAME.C -G -o SQLROUTINE_FILENAME -L/export/home/db2inst1/sq
llib/lib -R/export/home/db2inst1/sq
llib/lib -ldb2
PATH=$PATH:/export/home/db
2inst1/For
te/SUNWspr
o/bin
export PATH
SQLROUTINE_FILENAME=P09361
90
export SQLROUTINE_FILENAME
CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1/sq
llib/inclu
de P0936190.C -G -o P0936190 -L/export/home/db2inst1/sq
llib/lib -R/export/home/db2inst1/sq
llib/lib -ldb2
*** /export/home/db2inst1/sqll
ib/functio
n/routine/
sqlproc/EC
CCLSOL/ECC
CL/tmp/P09
36190.exp ***
pgsjmp
Could not open input file "P0936190.C".
--------------------------
----------
----------
----------
----------
----------
SQL7032N SQL procedure "" not created. Diagnostic file is "". SQLSTATE=00000
ECCCL.ADD_DELEGATE - Build failed.
ECCCL.ADD_DELEGATE - Changes rolled back.
--------------------------
----------
----------
----------
----------
-
on my solaris box
$cat myenv
PATH=$PATH:/export/home/db
2inst1//Fo
rte/SUNWsp
ro/bin
export PATH
$ db2set
DB2_SQLROUTINE_COMPILER_PA
TH=/export
/home/db2i
nst1/myenv
DB2_SQLROUTINE_COMPILE_COM
MAND=CC -xarch=v9 -Kpic -mt -I/export/home/db2inst1
/sqllib/include SQLROUTINE_FILENAME.C -G -o SQLROUTINE_FILENAME -L/export/hom
e/db2inst1/sqllib/lib -R/export/home/db2inst1/sq
llib/lib -ldb2
DB2COMM=tcpip
DB2AUTOSTART=TRUE
--------------------------
----------
----------
----------
----------
-
I had also gone through this site and gave permission
https://www.experts-exchange.com/Databases/IBM_UDB/Q_20787883.html
Reference:
for compiler options
http://publib.boulder.ibm.com/infocenter/db2help/index.jsp?topic=/com.ibm.db2.udb.doc/ad/r0006664.htm
http://www-106.ibm.com/developerworks/db2/library/techarticle/0205pilaka/0205pilaka.html
PDF Paper on SQL Procedures - Overview by :Nanda K. Pilaka [IBM]
--------------------------
----------
----------
----------
----------
-
Thanks
Banu