Create Procedure时产生错误 SQL7032N

Marshall169

Create Procedure时发生如下错误
SQL7032N  SQL procedure "CHECK" not created.  Diagnostic file is
"P5523908.log".  SQLSTATE=42904

-- LOG FILE P5523908.log FOR PROCEDURE USERA   .CHECK

-- DB2_SQLROUTINE_PREPOPTS=

-- PREP/BIND MESSAGES FOR /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.sqc

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

-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sr_cpath

#!/bin/sh
PATH=$PATH:/opt/SUNWspro/bin
export PATH

-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.sh

SQLROUTINE_FILENAME=P5523908
export SQLROUTINE_FILENAME

-- COMPILATION COMMAND:

CC  -xarch=v8plusa  -mt -KPIC -I/export/home/db2inst1/sqllib/include P5523908.c -G -o P5523908 -L/export/home/db2inst1/sqllib/lib -R/export/home/db2inst1/sqllib/lib -ldb2


-- CONTENTS OF /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.exp

pgsjmp


-- COMPILATION MESSAGES FOR /export/home/db2inst1/sqllib/function/routine/sqlproc/SAMPLE/USERA/tmp/P5523908.c
CC: unrecognized option `-KPIC'
CC: language arch=v8plusa not recognized
ld: fatal: file P5523908.c: unknown file type
ld: fatal: File processing errors. No output written to P5523908
collect2: ld returned 1 exit status

-- END OF LOG FILE (SQLCODE: -7032)

flasher

有没有c编译器？

flasher

CC: unrecognized option `-KPIC'
CC: language arch=v8plusa not recognized

看看cc的选项

lizhuo

在此服务器上未安装和配置对 SQL 存储过程的支持。
需要在服务器上安装“DB2 应用程序开发客户机”和 C
编译器才能创建 SQL 过程。 在您的平台上，可能需要设置 DB2
注册表变量 DB2_SQLROUTINE_COMPILER_PATH 才能指向包含 C
编译器环境设置的脚本或批处理文件。

DB2 未能预编译或编译 SQL 存储过程。 DB2 创建作为包含嵌入式 SQL
的 C 程序的 SQL 过程。在预编译或编译阶段可以发现在初始解析
CREATE PROCEDURE 语句期间未发现的错误。